Viewing 15 posts - 3,421 through 3,435 (of 15,381 total)
Koen Verbeeck (1/14/2015)
Sean Lange (1/14/2015)
Koen Verbeeck (1/14/2015)
Sean Lange (1/14/2015)
Charles Kincaid (1/14/2015)
Seems that COUNT() does some...
January 14, 2015 at 2:10 pm
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
The question of today wasn't bad at...
January 14, 2015 at 1:44 pm
Koen Verbeeck (1/14/2015)
Sean Lange (1/14/2015)
Charles Kincaid (1/14/2015)
Seems that COUNT() does some fun things. I...
January 14, 2015 at 1:42 pm
Your first table is in direct violation of first normal form (1NF) which says you can't have more than one value at any given intersection in a table.
The article Luis...
January 14, 2015 at 1:39 pm
Charles Kincaid (1/14/2015)
Seems that COUNT() does some fun things. I have been using COUNT(1)...
January 14, 2015 at 12:44 pm
simon.letts (1/14/2015)
Yes the unit are attached to IT and support the business so they are a little more technical and use SSMS
Yikes!!! On one hand you have people who can't...
January 14, 2015 at 8:40 am
simon.letts (1/14/2015)
But as i say, using the ANSI format is what I want to get away from, it needs to be dd/mm/yy for ease of use by our...
January 14, 2015 at 8:32 am
simon.letts (1/14/2015)
execute myproc '13/05/99', '14/05/99'
Then use ANSI standard date formats.
exec myproc '1999-05-13', '1999-05-14'
Or set the dateformat in your connection.
set dateformat dmy
execute myproc '13/05/99', '14/05/99'
January 14, 2015 at 7:50 am
edwardwill (1/14/2015)
Stewart "Arturius" Campbell (1/14/2015)
edwardwill (1/14/2015)
Stewart "Arturius" Campbell (1/14/2015)
edwardwill (1/14/2015)
Actually, it returns:Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ','.
what version of SQL Server are you using?
2008 R2...
January 14, 2015 at 7:42 am
This so far is the scariest thread of the year. Complete and total lack of understanding by some arrogant "senior" team member. I would run away as quickly as possible.
January 14, 2015 at 7:34 am
simon.letts (1/14/2015)
Thaks for that. So can you give me an example of how you would have coded it please. 🙂
I would have coded it exactly as your original post....
January 14, 2015 at 7:23 am
Good question. I am rather shocked at how many people got this wrong (12% at the time of this posting). As many times as this has been covered it is...
January 14, 2015 at 7:22 am
Koen Verbeeck (1/13/2015)
FYI, I received the Author of the Year award at MSSQLTips.com!Thanks everyone for voting!
Congrats!!! Well deserved!!!
January 13, 2015 at 3:06 pm
simon.letts (1/13/2015)
I had to set the 2 variables to varchar, I had them as datetime! doh
Then...
January 13, 2015 at 12:26 pm
Viewing 15 posts - 3,421 through 3,435 (of 15,381 total)