Viewing 15 posts - 46 through 60 (of 229 total)
GilaMonster (2/19/2009)
...If I'm interviewing a person, I want to know what they know and what they don't, not what interview questions they're memorised...[/url]
Although that would be quite a novel experience...
February 19, 2009 at 4:25 am
I know I haven't always been a beaming icon of knowledge and made my fair share of dumb or irrelevant suggestions (trying to be consilatory) but, is it just me...
February 19, 2009 at 4:18 am
Ford Fairlane (2/17/2009)
GSquared (2/17/2009)
Max (2/17/2009)
Man, you guys are so lucky, we were so poor I had to push the horse up the hill. 😉
Sisyphus move over! New guy with...
February 18, 2009 at 6:39 pm
GSquared (2/17/2009)
Sisyphus move over! New guy with version 2.0 is here! 🙂
Guess you're referring to Oracle, I do certainly see parallels. 😉
February 17, 2009 at 5:28 pm
GSquared (2/17/2009)
I had an Access database that...
February 17, 2009 at 5:18 pm
Man, you guys are so lucky, we were so poor I had to push the horse up the hill. 😉
February 17, 2009 at 1:15 pm
Jack Corbett (2/17/2009)
The only problem with this is that now the query has to scan every row in t_Sale to apply the coalesce.
Dinkum? Sorry about the slang - and no...
February 17, 2009 at 1:09 pm
louisevb (2/17/2009)
Hi Max, so glad this website was recommended to me getting great advise. Thanx so much for those website, they are excellent. 🙂
Absolute pleasure, wish I could go through...
February 17, 2009 at 12:57 pm
I understand this is purely an academic post and that you have resolved the performance issue with the left outer joins.
When you say "reads", do you mean index scans or...
February 17, 2009 at 8:56 am
I think your WHERE clause should look something like:
wherecasewhen err_cd in ( 20, 30 ) then err_cd * 10000
when err_cd is null then 0
else err_cd
end <...
February 17, 2009 at 4:05 am
Hi Bruce,
Gints wrote some informative tests on join criteria: http://www.gplivna.eu/papers/sql_join_types.htm#p6.4, thanks Gints, this does help clarify a lot.
February 17, 2009 at 3:54 am
Pity you're using SQL2000 otherwise you could probably pivot the data.
Edit: Doh! http://www.sqlservercentral.com/scripts/Miscellaneous/31719/
February 16, 2009 at 5:29 pm
Jeff Moden (2/16/2009)
gints.plivna (2/16/2009)
Jeff Moden (2/16/2009)
Roy Ernest (2/16/2009)
Calm down people ... Calm down...:D It is a Monday afternoon...:D Not the best day to have arguments.... 😉
It's a GREAT day for...
February 16, 2009 at 5:13 pm
Quite admirable, one of our accountants just defected to our team. :Wow:
You'd only have to learn C# if you want to programme and create software applications. Learning C# and sql...
February 16, 2009 at 4:58 pm
Viewing 15 posts - 46 through 60 (of 229 total)