Viewing 15 posts - 6,001 through 6,015 (of 7,483 total)
bubs (4/18/2011)
Yes the ClosedDate is of type date.Getting a different conversion error: "Explicit conversion from data type int to date is not allowed."
OK, it's absolutely clear what is going on...
Tom
April 19, 2011 at 5:33 pm
What is the type of the ClosedDate column of the PerformanceReviewHistory table?
If the type is DATE, try using
....PRH.ClosedDate BETWEEN + cast(' + convert(nchar(8), @pStartDate, 112) +...
Tom
April 18, 2011 at 11:38 am
Jeff Moden (4/17/2011)
Tom.Thomson (4/17/2011)
Incidentally, you can't call a stored procedure using OPENQUERY either.Maybe not, but OPENROWSET works a treat.
Interesting. I wonder why MS decided to forbid calling a...
Tom
April 18, 2011 at 10:52 am
GilaMonster (4/18/2011)
Higher compression. Ability to split the archive into multiple files (great for huge archives going onto CD/DVD or for getting through email limits). Encryption and passwords....
Tom
April 18, 2011 at 10:29 am
nikplic (4/17/2011)
Is it possible do something like this:set@sql=' select * from resultStoredProcedure
where myCondition'
Thanks
No, there's a problem with the set of rows returned by a stored procedure - you can't use...
Tom
April 17, 2011 at 5:40 pm
It depends what you like. Personally I would have gone crazy if I hadn't done a lot of different things, and learnt a lot of new stuff because I...
Tom
April 16, 2011 at 1:38 pm
Your problem is that @pEmployeeIds exists in the stored procedure, not in the batch executed by DYNAMIC PIVOT.
The solution: embed the value of @pEmployeeIds in the string passed in, and...
Tom
April 16, 2011 at 12:14 pm
WayneS (4/16/2011)
Tom
April 16, 2011 at 12:04 pm
In the UK it's generally impossible to do a Tax return this early - there is all sorts of stuff for which you need figures, some of which you don't...
Tom
April 16, 2011 at 11:46 am
It's certainly possible.
Using openquery with loopback will limit what you see out of the stored procedure, because openquery only return's the stored procedures's first result set, so it may not...
Tom
April 16, 2011 at 10:29 am
LutzM (4/15/2011)
Question aside: where did you learn German? I'm impressed!
I didn't think that was impressive, it is after all something very short and simple, no complexity or long words or...
Tom
April 15, 2011 at 11:37 am
LutzM (4/14/2011)
Tom
April 15, 2011 at 6:51 am
GilaMonster (4/14/2011)
Tom
April 14, 2011 at 5:48 am
majorbloodnock (4/14/2011)
Jeff Moden (4/14/2011)
Koen Verbeeck (4/14/2011)
fname lname-1111520 (4/13/2011)
I get it: "then", "than", "there's", "there are". Stop reading (and I did), it can't be coherent.
Oink? You stop reading...
Tom
April 14, 2011 at 4:06 am
Craig Farrell (4/14/2011)
I'm going to assume I'm just too...
Tom
April 14, 2011 at 3:36 am
Viewing 15 posts - 6,001 through 6,015 (of 7,483 total)