Viewing 15 posts - 196 through 210 (of 466 total)
SQL Surfer '66 (8/26/2013)
Sean Lange (8/22/2013)
In SSMS right click the database -> Reports -> Schema Changes HistoryThanks Sean. Very interesting. Must take a closer look at the different reports.
I did...
August 28, 2013 at 11:13 am
Steve Jones - SSC Editor (8/21/2013)
Sept 2, check. Ready and waiting. A whole new strategy this year to try and not sweep up the basement.
Draft as many Denver Broncos as...
August 22, 2013 at 8:05 am
calvo (8/22/2013)
Not having any experience with the level of competition in Japan, are his hits in Japan any less meaningful?
Based on how the Japanese teams have fared in the World...
August 22, 2013 at 8:02 am
SQLDCH (8/20/2013)
The league is full and ready to draft. See you all on September 2.
Sweet. Hopefully nobody drafts the Green Bay defense in the first round again this...
August 20, 2013 at 3:54 pm
Luis Cazares (8/14/2013)
Even better would be a decimal(8,2) 🙂
You'd get an error if you had a number that filled up that decimal(10,4) though, would you not?
123456.7890 * 100 would not...
August 14, 2013 at 3:39 pm
Just convert it to a decimal(10,2) instead of decimal(20) after you multiply by 100.
convert(decimal(10,2), mydec * 100)
August 14, 2013 at 3:20 pm
It looks to me that you don't have a closing parenthesis for the cte. Not sure why you have the sub-select in the cte either, but you'll have to...
August 12, 2013 at 2:40 pm
Lynn Pettis (8/5/2013)
Okay, I made sure to sign up just now. Been a bit busy with coming to Afghanistan and all.
I think you get a pass for that one....
August 5, 2013 at 12:12 pm
Only a month until the season starts! It looks like we are still a couple teams short in the league as of now, are there still a couple people...
August 5, 2013 at 10:49 am
Steve Jones - SSC Editor (7/22/2013)
Rockies are doing well, getting close to .500 and keeping the...
July 23, 2013 at 8:18 am
If it were me I would just build it in it's own table because it will likely have to be used again, but you can build it on the fly...
July 18, 2013 at 10:39 am
The only way this can be done is by building another table with a cross reference of values. Does something like that already exist in your system?
July 18, 2013 at 10:20 am
Just throwing this out there, anyone feel free to chime in, but if we are having the same guys playing here, what are the thoughts on doing a keeper for...
June 27, 2013 at 1:40 pm
Pretty weird to be thinking about fantasy football in June, but I am back in. Hopefully I can improve on my 5th place performance from last year!
June 24, 2013 at 4:03 pm
Since you have an integer in the else part of your case statement, it tries to implicitly convert anything else that comes out of the case to an int. ...
June 24, 2013 at 2:54 pm
Viewing 15 posts - 196 through 210 (of 466 total)