I'm just guessing, maybe you wanto to do this instead:

SELECT Top(1) @Grp_TTCount = COUNT(DISTINCT TID) AS TTCount

FROM table1.dbo.db1

WHERE (CONVERT(nvarchar, DATEADD(s, CREATE_DATE, CONVERT(DATETIME, '1970-01-01 00:00:00', 102)), 101) = @Report_Date)

AND CR_GP...

SET @Grp_TTCount =

(

SELECT Top(10) CR_GP, COUNT(DISTINCT TID) AS TTCount

FROM table1.dbo.db1

WHERE (CONVERT(nvarchar, DATEADD(s, CREATE_DATE, CONVERT(DATETIME, '1970-01-01 00:00:00', 102)), 101) = @Report_Date)

GROUP BY CR_GP

ORDER BY COUNT(DISTINCT TID) DESC

)

This code seems to try...

... oops! I found it: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=296760

I think I will vote for it.

I'm still waiting for a FINALLY block to be implemented in some future version.

I think it would be really useful and I wonder why Microsoft decided not to implement it.

Maybe...

I think TRY/CATCH was one of the biggest enhancements introduced in T-SQL with SQL2K5.

I wonder how on earth I could live without it.

From BOL:

Errors Unaffected by a TRY…CATCH Construct

TRY…CATCH constructs do not trap the following conditions:

* Warnings or informational messages that have a severity of 10 or lower.

* Errors that have a...

You could simply schedule each job to start a the same time. You could also set up a "runner" job to start all the other jobs with msdb.dbo.sp_start_job.

For what parallelism...

Of course you can!

Try/Catch was introduced to allow the developer to handle errors in code. One legitimate way to handle an error is to simply ignore it.

Be careful that a...

Maybe this was typed with a cell-phone keyboard. Looks like an SMS...

jacroberts (8/13/2009)

---

If the the site implemented Wiki, users could go in and correct any errors on the articles?

That way the site could host a set of excellent, up to date,...

steve_melchert (8/12/2009)

---

I'm not sure what jobs y'all have that allow writing these 1,000 word posts. I've spent more time on this board in the last couple of days than...

I'm not a big fan of Heinlein, but I read Lazarus Long and I liked it very much.

Edited: The original title is Time Enough For Love, which was published in...

The log backup contains both log entries and data pages modified by bulk operations.

Always from BOL:

Under the bulk-logged recovery model, if a log backup covers any bulk operations, the log...

When you turn back to FULL recovery and take a log backup, you can restore to any point in time subsequent to reverting to FULL recovery.

But this is not the...

Sure it will, you would only have to wait longer.

While loops are no better than cursors on...