I am not sure if this always works, but could you try removing the print and select statements in the following code (for second SP) WHILE ( @fetch_status2= 0) BEGIN select @cmplt_code WHILE (@Month <> 14) BEGIN print @month Do Let me know if it worked for you Edited by - mandard on 06/24/2003 12:24:39 […]
2003-06-24
I have done this exact thing and found it worked much more easily than expected. 1. backup db's, including master - just in case 2. down server remove drives 3. Hookup drives to new box, and if the drive designation is the same as it was before then continue, else backup, detach and reattach as […]
2003-06-19
Thank you very much for the input. Any suggestions on how to automate the process of adding hundreds of users? Thanks again. WM
2003-06-19
This is not what the poster is asking for. They are requesting that in the same query, return both scalar and non-scalar aggregates, ie count of all and also count of a single group, and given the format the poster wanted (repeating the scalar aggregate in each row), none of the solutions presented so far […]
2003-06-19
You need to use a CASE statment instead of WHERE clause to restrict the values going into the aggregate. The code below assumes that you can't have negative values in dbo.Defect_Data.SUMDEFECTS. So you don't need to restrict the input to the SUM. If you did, you would use a CASE statement as with QDefectCount, but […]
2003-06-19
You need to use a CASE statment instead of WHERE clause to restrict the values going into the aggregate. The code below assumes that you can't have negative values in dbo.Defect_Data.SUMDEFECTS. So you don't need to restrict the input to the SUM. If you did, you would use a CASE statement as with QDefectCount, but […]
2003-06-19
1 reads
You need to use a CASE statment instead of WHERE clause to restrict the values going into the aggregate. The code below assumes that you can't have negative values in dbo.Defect_Data.SUMDEFECTS. So you don't need to restrict the input to the SUM. If you did, you would use a CASE statement as with QDefectCount, but […]
2003-06-19
1 reads
The script below will solve your problem,it runs for bot sql 7.0 an sql 2000. -- Caution : database compatibility level must be 7.0 or higher .. dbcc shrinkfile ( [Logical Log File Name], truncateonly ) backup log [Logical Database Name] with truncate_only GO if exists ( select * from sysobjects where name ='tmp_00000000000001a') drop […]
2003-06-19
1 reads
With all the time we spent on this thread you probably could have just done 2 calls to the database, and used the results of the second call in your summary row... I'm all out of ideas. Generally, I try to break unrelated queries into different resultsets; perhaps someone else out there has an answer...
2003-06-18
2 reads
🙁 The problem is that I am also trying to get the total questionnaires per WSI not just the one that have SUMDEFECTS > 0. I need to have it as one so I can then build the html table with the summary information.
2003-06-18
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers