Viewing 15 posts - 13,921 through 13,935 (of 15,381 total)
You are welcome. Thanks for letting us know you got a solution.
September 27, 2011 at 8:17 am
You are welcome. Sometimes the obvious answer is sitting right there and you just can't see it. Been there more times than I care to admit. 😉 Glad you got...
September 27, 2011 at 8:16 am
thundersplash845 (9/26/2011)
Sean, yes ,SQL shows Error conversion... Instead of this, is there any possible way to display user-defined msg??or If the above is feasible from reporting end (SSRS)....??
This error...
September 27, 2011 at 8:09 am
GSquared (9/27/2011)
Sean Lange (9/26/2011)
/soapbox on...
/soapbox off
It's a pretty fair bet that some people would assume I'm a pretty rabid conservative. On the other hand, there are plenty who think...
September 27, 2011 at 7:59 am
Jeff Moden (9/26/2011)
Sean Lange (9/26/2011)
/soapbox on....
/soapbox off
I have to ask... have you ever worked in a warehouse or on a production line?
No I have never worked a production line. I...
September 27, 2011 at 7:53 am
That is because there is a missing parenthesis to close the sum function.
September 27, 2011 at 7:08 am
kdfischer - Did that get you what you needed or do you still need some help with this?
September 27, 2011 at 7:06 am
Evil Kraig F (9/26/2011)
If you'll setup the data and schema to be consumable, I'll actually plug away at the code when I get some time to get...
September 26, 2011 at 3:38 pm
Reading this again, why do you need subqueries at all? What are trying to get out this table?
September 26, 2011 at 3:18 pm
What do you mean by "it isn't working"? Are you getting error message? Is the result not what you expect?
September 26, 2011 at 3:15 pm
You're welcome. glad that works and thanks for letting us know.
September 26, 2011 at 2:39 pm
/soapbox on
Boy I must be on of the few conservatives on here...the amazon article was thought provoking but I find the author's stance does not align with my own. By...
September 26, 2011 at 2:25 pm
It might be easier to just cast one of your values in your division inline like this.
select (CAST(freecount as decimal) / enrollment) * freecount from OpSumm
September 26, 2011 at 1:52 pm
Also, what do each of these return?
select @@LANGUAGE
exec sp_helplanguage @@language
September 26, 2011 at 12:47 pm
It is the same table that you scripted. I just changed the name to a temp so it would cause issues with your existing table. You provided the create...
September 26, 2011 at 12:44 pm
Viewing 15 posts - 13,921 through 13,935 (of 15,381 total)