i think you would need to use sql loop through the msdb database to create a script which you can then save to a batch file and run that. ...

Also, in the example in this article you can do away with the SQL statement and enter the expression directly into the variable.

+ Select the variable and go to it's...

you could use a case statement:

where

case month(dob)

when 1 then 1

...

you can use the expression builder to do this.

right click the text box that will hold your title, click expression builder on the context menu. you can then use...

That was my first plan, actually. I had a dynamic link that pointed to firstly the .wav file via a UNC path and secondly via http. Neither of...

nice question. nice and sneaky.

Assuming the author does mean a CASE expression, and then the answer is "yes", you would have to wonder why you would use it at all, as (in the example...

During the summer months here in Cornwall, UK, I like to nip down to the beach and go for a swim during my lunch. It wakes me up, invigorates...

How about...

"The older I get, the better I was"

Tommy H

another problem could occur if you use the PRINT command in your sp. this sp will run fine in QA but will cause a web page to fail.

great article! CTEs were well explained and the examples demonstrated the application of CTEs effectively and succinctly. cheers.