Viewing 15 posts - 6,001 through 6,015 (of 7,484 total)
Stefan Krzywicki (4/18/2011)
While I like ASP.Net, I'm a VB programmer when it comes to non-SQL Server things and there's no free compiler that I know of.
Personally I hate VB anyway,...
April 19, 2011 at 5:47 pm
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...
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) +...
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...
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....
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...
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...
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...
April 16, 2011 at 12:14 pm
WayneS (4/16/2011)
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...
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...
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...
April 15, 2011 at 11:37 am
LutzM (4/14/2011)
April 15, 2011 at 6:51 am
GilaMonster (4/14/2011)
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...
April 14, 2011 at 4:06 am
Viewing 15 posts - 6,001 through 6,015 (of 7,484 total)