Viewing 15 posts - 61 through 75 (of 83 total)
I'm going to play devil's advocate here (like MS needs any help...). In my copy of online help the...
May 17, 2011 at 7:28 am
At the risk of exposing how much I might not know, why all the alter statements changing fields from tinyint to int, as well as NOT NULL? I would assume...
April 13, 2011 at 1:36 pm
I am quite sure that on Friday when this question first appeared that the nvarchar definition was on the web site as well as the email (which of...
April 12, 2011 at 7:09 am
Ernie Schlangen (4/11/2011)
April 11, 2011 at 6:20 am
As one of the 40% who got this wrong (and learned from it) I'd say there are several advantages to a procedure like this:
1. It's great for problem solving. If...
March 16, 2011 at 7:01 am
The biggest issue I've seen with reports is the merging of cells. This usually happens if I have multiple tablixes on the same page that would export to being in...
March 3, 2011 at 6:31 am
I'll have to hang on to this. While I've not needed to rerun everything, on occasion I've needed to rerun some stuff. Your code will give me a good starting...
January 26, 2011 at 6:43 am
No problem and no offense meant. As noted, it's an entertaining little item and it was nice to look for the "Gotcha" in the script.
September 3, 2010 at 7:23 am
It should be noted that no matter what value is passed into the procedure, you will always get 10 "words" (language to be determined) from this procedure.
select @i=0
...
while @i<10
...
set...
September 3, 2010 at 6:04 am
Thank you much for the explanation and for taking the time to write it up.
Bob
August 31, 2010 at 7:11 am
I don't mind being wrong (heck, if I were right all the time...) but it does mystify me a bit that the HAVING clause empties the result set. I selected...
August 31, 2010 at 6:33 am
ChrisM@home (2/12/2010)
If you set up your sample as a CREATE...
August 2, 2010 at 2:46 pm
I'm sure I'm one of many that has noticed this, but I sent an email to the webmaster indicating that the link to this post is broken both from Monday's...
August 2, 2010 at 5:56 am
For all who look at the data in the URL, I agree that there is no explicit statement that one cannot have a 0 increment. I suppose the following line,
"If...
July 15, 2010 at 6:23 am
cengland0 (6/30/2010)
info 25880 (6/30/2010)
Yes, that's reason, because the result of an implicit casting of '-' is zero
SELECT 6 + 1 + '-'
So if you substitute the '-' with something clearly...
June 30, 2010 at 6:23 am
Viewing 15 posts - 61 through 75 (of 83 total)