Viewing 15 posts - 301 through 315 (of 430 total)
Sean Lange (8/29/2013)
saravanakumar.G (8/28/2013)
Thanks for the reply.
Yes. the SP is working if we put single quotes across the tablename ('schemaname.tablename').
I want to try...
September 2, 2013 at 12:34 pm
Right idea, wrong apply! I was so intent on finally coming up with a good use for cross apply that I didn't realize I needed an outer apply. So here's...
August 31, 2013 at 8:39 am
SQLRNNR (8/27/2013)
erikd (8/27/2013)
Ah. That's weird. Why does that happen? I jumped from 2005 to 2012, and never ran into that happening. I feel pretty lucky :Whistling:
I should probably clarify a...
August 27, 2013 at 10:47 am
Ah. That's weird. Why does that happen? I jumped from 2005 to 2012, and never ran into that happening. I feel pretty lucky :Whistling:
August 27, 2013 at 9:40 am
Koen Verbeeck (8/26/2013)
kakumanukalyan (8/26/2013)
SELECT ContactID,Concat('$',AVG(TotalDue)) AS [Avergare Total Due]FROM Sales.SalesOrderHeader
GROUP BY ContactID
ORDER BY 1 ASC
Not really a fan of doing this in the database layer. If the result is NULL,...
August 27, 2013 at 8:21 am
wolfkillj (8/23/2013)
Jeff Moden (8/21/2013)
weston_086 (8/21/2013)
August 23, 2013 at 11:04 am
Peter Schott (8/23/2013)
August 23, 2013 at 6:54 am
I use this with OPENDATASOURCE. I think you can re-purpose the idea to do what you need.
I generally find this method more readable and reasonable for a human being...
August 23, 2013 at 6:48 am
Those are cool. And yeah, I don't blame you. I'd hate to just hit f5 on all that outside of a SP/function.
I call that red letter roulette.
August 23, 2013 at 6:18 am
dwain.c (8/22/2013)
August 22, 2013 at 9:31 pm
aaron.reese (8/22/2013)
Reminds me of one of my favourite jokes:
Q: Why does Excel get Christmas and Halloween confused?
A: OCT31 = DEC25 (actually OCT2DEC(31) = 25 but it doesn't...
August 22, 2013 at 5:28 pm
Koen Verbeeck (8/22/2013)
You'd be suprised what you can find these days 🙂
In the same file something was doing MATH on a phone number column during import.
So 212-555-5555
or 212-555-5555 /...
August 22, 2013 at 2:03 pm
David McKinney (8/22/2013)
For more on the xml approach, check out this article (the url is for part 2, but part 1 will give you the introduction.)
This looks neat. I'll check...
August 22, 2013 at 9:42 am
Sean Lange (8/22/2013)
erikd (8/22/2013)
Sean Lange wins the Twisting the Knife Before 10am award! Congratulations! 😛
Not my intention at all. Using sql to help you build sql is good idea and...
August 22, 2013 at 8:49 am
Sean Lange wins the Twisting the Knife Before 10am award! Congratulations! 😛
August 22, 2013 at 7:41 am
Viewing 15 posts - 301 through 315 (of 430 total)