Viewing 15 posts - 19,066 through 19,080 (of 26,490 total)
I understand that what you wrote was an illistration of how IN works. My point is if you actually write a WHERE clause like that, you would use OR...
August 24, 2009 at 11:12 am
rambilla4 (8/24/2009)
Selected row details:
Date8/24/2009 8:45:00 AM
LogJob History (LSBackup_Mydb)
Step ID1
Serversqlvs\ins1
Job NameLSBackup_Mydb
Step NameLog shipping backup log job step.
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
2009-08-24...
August 24, 2009 at 9:54 am
Not disputing the NOT IN not working if nulls exist in the data.
I'm disputing the explicit code that has been shown. First, whoever wrote should not have used somecol...
August 24, 2009 at 9:51 am
Andy DBA (8/24/2009)
rja.carnegie (8/24/2009)
Andy DBA (8/18/2009)
For example:
WHERE somecol NOT IN (1,2, NULL)
is equivalent to
WHERE NOT (somecol = 1 OR somecol = 2 OR somecol = NULL)
Wait, isn't that...
August 24, 2009 at 8:24 am
arup_kc (8/24/2009)
August 24, 2009 at 8:21 am
Ravi (8/24/2009)
i have attached the same query that...
August 24, 2009 at 8:06 am
arup_kc (8/24/2009)
As an example, the cursor/temp table issue. In several SP's I have replaced the cursor with a combination of temaptable+while and it gave me better performance.
Unfortunately, in this case,...
August 24, 2009 at 6:50 am
Ravi (8/24/2009)
Query works if i have 1 negative value in that list for the Particluar Item,City, Street like
Date: 07/07/2009, Item : A City : NY , Street :...
August 24, 2009 at 6:46 am
trudye10 (8/22/2009)
Thanx to all of you for all your help, patience and guidance. I have managed to get the query completed.Thanx again,
Trudye
Trudye,
Glad to hear that you managed to complete...
August 22, 2009 at 9:17 pm
GilaMonster (8/22/2009)
Lynn Pettis (8/22/2009)
Lynn tries to work with everyone. 😉Aren't there a few that have made even your personal black-list?
You are right, to a point. But it seems...
August 22, 2009 at 4:33 pm
conmcgarry (8/22/2009)
But then I was wondering, if somebody were to enter an incorrect e-mail address initially, this would insert the incorrect e-mail address into...
August 22, 2009 at 11:04 am
GilaMonster (8/22/2009)
Lynn answers people that I won't. I answer people that Jeff won't. Jeff answers ones that I won't, etc.
lol... Actually expected something more like this: I answer people...
August 22, 2009 at 10:42 am
I don't think such a list should be posted. I'm not going to tell anyone who they should or shouldn't help. If you (speaking plural here) choose not...
August 22, 2009 at 2:40 am
gnuoytr (8/21/2009)
Umm. This thread is about Oracle and MySql. Whether such a thread should be on SQLServer dedicated site is not my call.
Actually, this thread is a discussion...
August 21, 2009 at 4:46 pm
Bob did a good job describing what we need above. Please follow his lead and build us the better mouse trip to show us your problem and what you...
August 21, 2009 at 4:18 pm
Viewing 15 posts - 19,066 through 19,080 (of 26,490 total)