Viewing 15 posts - 10,951 through 10,965 (of 15,381 total)
I tend to agree with Lowell on this one though. A phone number is rather meaningless by itself. It only gains relevance when you know what it belongs to. I...
August 24, 2012 at 12:33 pm
and CO.OrderID in (Select OrderID from OrderHandsets(nolock) where ConDate is not null or ConDate <> '') --This is where i need to check each row
You should change this to...
August 24, 2012 at 12:28 pm
And no amount of testing can ensure that using join hints will be correct. What is better on the data today may very well be different tomorrow when the amount...
August 24, 2012 at 12:19 pm
adonetok (8/24/2012)
Thank you for help.I did the way you are showing but it is not convenient.
Every time I need to modify it.
Well SSMS is not designed to be a data...
August 24, 2012 at 12:12 pm
I would drop that function entirely. It is about the worst performing methods of splitting strings. Take a look at the string splitter article referenced in my signature.
Secondly I would...
August 23, 2012 at 12:30 pm
ChrisM@Work (8/23/2012)
Ankur Bajaj (8/23/2012)
People having a good laugh at my cost! +1 to that....
Nobody is laughing at you. Some of the folks who have responded on this thread may at...
August 23, 2012 at 8:48 am
I got this correct for all the wrong reasons. I didn't have a clue what the point of the question was but since the variable, temp table, and persistent table...
August 23, 2012 at 8:27 am
That is because you changed the not in to exists. Exists does not work like that. It evaluates to true or false and does the action accordingly. You should change...
August 22, 2012 at 8:55 pm
Evil Kraig F (8/22/2012)
SQL Kiwi (8/22/2012)
There is a better, and easier way to do it using NOT EXISTS and INTERSECT. I describe the technique here: http://bit.ly/EqualityComparison
That. Is. ...
August 22, 2012 at 8:53 pm
dcwilson2009 (8/22/2012)
August 22, 2012 at 3:12 pm
sqlfriends (8/22/2012)
I think Greg meant not sargable is because I use Isnull function on the left of the comparison.
It doesn't matter which side, it is going to force a scan...
August 22, 2012 at 3:02 pm
lallu_jaya (8/22/2012)
Iam having multiple values for test_status which I didnt mention in my 1st post.
I am having other status like rerun, non completed, investigate etc which I want to...
August 22, 2012 at 3:00 pm
dcwilson2009 (8/22/2012)
August 22, 2012 at 2:58 pm
Michael Valentine Jones (8/22/2012)
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61024
I especially like the query posted by RobWafle at 02/01/2006 12:05:48 that had over 40 left...
August 22, 2012 at 2:52 pm
sqlfriends (8/22/2012)
Evil Kraig F (8/22/2012)
sqlfriends (8/22/2012)
can I use isnull(student.mailingaddress,'')<>isnull(esis.mailingaddress,'')Yep, that's the usual workaround, just realize the entire query will be non-SARGable.
I would like my query to be sargable.
So what other...
August 22, 2012 at 2:48 pm
Viewing 15 posts - 10,951 through 10,965 (of 15,381 total)