Unfortunately, as much as I'd love to use TRY_CONVERT(), we are stuck in the dark ages using 2k8R2

I don't think you quite understand the issue. I'm attempting to parse a non-date into a date variable. Yes this sounds stupid, but I'm testing whether or not it can....

Hi,

Earth is closed for maintenance, please come back later. We apologise for the inconvenience.

Mice

Don't use the *, only select the columns you need.

Personally, I'd advise against sharing temp tables between nested procedures, it can lead to a world of pain.

Our approach is to have a persisted table, create your records in there...

Yeah, my bad.. Should be BETWEEN 0 AND 30

I couldn't see any difference in CPU or Query cost between my answer and Lynn's answer when doing <10 records.

It's all down to preference.

DECLARE @FictionalDate DATE = '1969-12-15'

DECLARE @bdays TABLE...

In SSIS you can use the DATEPART function. So, even though it would be a little more code that you might want, you can concatenate all the separate parts you...

Very useful tool, thank you, but I don't know why you felt the need to include a whole text document about "God" in the project files. I'm not sure what...

gutted, sorry.. Should have read the post..

😉

CONVERT(TIME,DATEADD (ms, @YOURMILLISECONDS, 0))

I've been using the send mail functionality for a while now and have found so many uses for it, it's really cool. I send out morning reports using an HTML...

I find Professional Microsoft SQL Server 2008 Administration from Wrox press very useful

Chris

Order Your Next Takeaway Online

You can create a role that has the permissions you want and then grant that role to the new user

e.g. create role NEW_ROLE

grant select any table to NEW_ROLE

grant xxx to...