Viewing 15 posts - 9,931 through 9,945 (of 15,381 total)
jagger_89 (11/29/2012)
November 29, 2012 at 8:37 am
Good question Lokesh. The incorrect answers were suitably feasible so it took some serious thinking on this one.
November 29, 2012 at 7:50 am
Yes we can help but you have to help us help you. You changed your ISNULL to COALLESCE but is seems that you still don't understand how it works.
case when...
November 28, 2012 at 3:05 pm
swenri (11/28/2012)
My output can not have a null or blank value. It has to have a value like ‘NVD’ or ‘N/A’ anything...
November 28, 2012 at 2:08 pm
richard.noordam (11/28/2012)
November 28, 2012 at 1:35 pm
I decided that just for fun I would put together a few different ways of the same query.
The first two do not use a cte or ranking function. I would...
November 28, 2012 at 12:40 pm
monilps (11/28/2012)
While working with Ranking Function it occurred me that how can I re-write this query without using Ranking function. I am not able to come up with any logic...
November 28, 2012 at 12:25 pm
NOTE: I need this T-SQL query without using CTE or Ranking Function like RANK(), ROW_NUMBER(),etc...
This sound like homework with this caveat. This can be done with them. We used to...
November 28, 2012 at 12:14 pm
Optimizing queries is more of an art form than a science. There are just way too many factors for any kind of automation to be able to optimize queries. The...
November 28, 2012 at 12:10 pm
sasansamani (11/28/2012)
Sean Lange (11/28/2012)
sasansamani (11/28/2012)
November 28, 2012 at 12:00 pm
sasansamani (11/28/2012)
Sean Lange (11/28/2012)
sasansamani (11/28/2012)
November 28, 2012 at 11:52 am
Koen Verbeeck (11/28/2012)
sqlfriends (11/28/2012)
Koen Verbeeck (11/28/2012)
^ is the negation. So %[^0-9.-]% means "every character that is not 0 through 9, a dot or the minus symbol".
Thanks, and thanks for...
November 28, 2012 at 11:38 am
sqlfriends (11/28/2012)
Thanks,how about the difference
between
like '%[0-9]%'
and like '[0-9]%'.
Are you familiar with with using wildcard searches? The first one will find any row that contains a...
November 28, 2012 at 11:34 am
Viewing 15 posts - 9,931 through 9,945 (of 15,381 total)