Hey good article Roy !

Thumbs up from Curaçao

hehe yes my mistake,

I didn't mean to say that it should never happen, just that from my own past experiences I haven't seen a good use for it, but...

WITH RECOMPILE has been a new friend of mine for few months only now,

we have a few SSRS reports running against our data warehouse and some of them have...

ah sorry, I didn't notice your own correction when looking over the thread

SELECT [Month] = DATENAME(mm, DATEADD(mm, MONTH(SomeDateTime), 0)), Amount = SUM(SomeAmount)

FROM #MyHead

WHERE SomeDateTime >=...

Looks like the problem was with my trace definition. I was tracing more then what is required by DTA. Now I split my trace into one dedicated for DTA and...

this pop up offers you 2 choices, to look online for info on the bug... .which leads nowhere, or to 'close the program'. If you click on that the popup...

thanks!

i don't know which problem you are running into when trying to set the DB in single user mode... but usually this would work

ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK...

try catch was introduced with 2k5, he needs his script to work with 2000 as well

otherwise i would agree... try catch is so much cleaner...

if you want the ability to commit or rollback depending if an error occured or not you can do something like this:

BEGIN TRANSACTION

update Report_T set Cost_AM = 720.00, Total_Cost_RPS_AM =...

you can convert the timestamp to binary and then convert the binary to varchar

however my code below involves an undocumented function... not sure if there is a better...

if this last one doesn't work it would help if you could post a script to create these tables and populate them with few sample entries

would that work?

select c.CompID, t.ResID, t.TaskID, t.Date, t.Hours

from dbo.Companies c

inner join dbo.ResourcesEmploymentHistory h on h.CompID = c.CompID

inner join dbo.TrackingHours t on t.ResID = h.ResID...