Actually I think I answered my own question 😛

I inserted PRINT @sqlquery and I can see the string in the message window.

I compare this to the Kinect that I got for the XBox last year. I love it as you do not need a controller to play games, but a...

Thanks for this information. The IF - THEN - ELSE statements seemed to have done the trick.

Paul, thanks for this article and very needed for me at this time as I have an intern who is learning about SQL Server database design. I quickly printed...

Thanks for the responses

Yes, thanks! And I love your byline - Not a DBA, but trying to learn!

Star TRek was inconsistent. Sometimes a scan for something takes a minute sometimes it takes a split second. Data sometimes performs incredible calculations, sometimes he can't. Kind of sily.

Another show...

I can't wait for Project Natal - now named Kinect! I am a HUGE Xbox 360 gamer. There will still be need for a controller, and Kinect will...

The type of job does matter to me, but it is not that important to me either. As long as whatever I am doing I can do at my...

LOL! DBA - Administrator...sorry about that.

Thanks for the information. And I ask this because we do not "formally" have a DB here. I am the IT Jack-of-all-trades. From programmer, to DB, to...

This is really interesting and humbles me in my writing of T-SQL. I could do this in a snap using Visual Basic or C#; I am sure I could...

And it works. Just tested it. Thanks again!

Yep, I was just thinking that. I am going to pass a "dummy" variable switch and I am using an IF ELSE statement.

Thanks!

Thank you - this actually did it!

declare @thisTime decimal(8,2)

set @thisTime = datediff(hh, getdate(), '11/22/2009')/8.0

select @thisTime