Viewing 15 posts - 376 through 390 (of 416 total)
NULLIF((EVT.VAL2), 0)
Maybe I'm just missing something here, but how can the above EVER return a zero?
December 16, 2014 at 11:18 am
Are you able to build a calendar or "dimDate" table? That will simplify this and similar queries that come up in the future.
December 16, 2014 at 9:38 am
Anybody? Any ideas? Bueller? Bueller?
December 12, 2014 at 10:09 am
Matt Miller (#4) (12/10/2014)
sqldriver (12/9/2014)
Grant Fritchey (12/9/2014)
doesn't everything in sql server? 😉
Still trying to figure out what the use-case for multi-statement table-valued user-defined functions is. But, other than...
December 10, 2014 at 11:43 am
i saw lots of people on social sites having problems with:
1+1+1+1+1+1+1+1+1+1+1+1x0+1 = ?
most of the answers was 1. So saying Simple may apply differently to others :hehe:
I wonder how the...
December 10, 2014 at 8:37 am
I would suggest that if your procedure is so complicated you need to step through it you can probably gain a lot by simplifying your code. Often times what I...
December 9, 2014 at 10:10 am
I do believe that this is a violation of the ANSI standard. Maybe not of the letter of the standard (I am not even sure if variables are included in...
December 8, 2014 at 4:07 pm
Eirikur Eiriksson (12/8/2014)
DonlSimpson (12/8/2014)
Are you required to store the number with the formatting? It can be easier to apply the formatting when retrieving the phone number.
Quick thought, if there...
December 8, 2014 at 1:28 pm
It seems like you might want to consider doing this with a reporting tool rather straight out of sql server.
December 8, 2014 at 12:51 pm
Hugo Kornelis (12/8/2014)
DonlSimpson (12/8/2014)
Hugo Kornelis (12/7/2014)
This code does a "swap" of two variables without requiring a third temporary variable
Ahem. Why not simply use a single SELECT?
SELECT @a =...
December 8, 2014 at 12:30 pm
Are you required to store the number with the formatting? It can be easier to apply the formatting when retrieving the phone number.
December 8, 2014 at 12:12 pm
Hugo Kornelis (12/7/2014)
This code does a "swap" of two variables without requiring a third temporary variable
Ahem. Why not simply use a single SELECT?
December 8, 2014 at 9:28 am
Hugo Kornelis (12/7/2014)
Pretty good trivia question, but readers: please do not ever think about...
December 7, 2014 at 10:59 am
I'm just not sure about somebody who is just not sure about Heisenberg.
My other thought for a tagline was "Will Rogers never met Pete Rose."
December 5, 2014 at 7:57 am
Ed Wagner (12/5/2014)
I'm glad we don't have the memory prices of that era any more.
🙂
December 5, 2014 at 7:53 am
Viewing 15 posts - 376 through 390 (of 416 total)