Viewing 15 posts - 14,611 through 14,625 (of 15,381 total)
With over 70 views and not a single response it should be pretty clear that what you posted isn't even close to enough information for anybody to understand what you...
May 31, 2011 at 8:32 am
colin.Leversuch-Roberts (5/31/2011)
You may get some issues if your user databases have a different collation...
May 31, 2011 at 8:28 am
Another thing you might consider is to use NULL and [UserID] instead of using "free" and "Use". This will provide you the same information about IF it the record is...
May 31, 2011 at 7:24 am
There is no way sql will be able to tell if your application crashes or not. I have to say it sounds like a poor application design the requires a...
May 28, 2011 at 10:05 pm
OK so I have to ask...is the identity property for the column set to Yes?
May 28, 2011 at 10:00 pm
Unless you have this figured I have to agree with BitBucket. I can come up with 3-4 different potential things you might be trying to do. If you provide some...
May 27, 2011 at 3:05 pm
WayneS (5/27/2011)
Jeff Moden (5/27/2011)
Rani-434268 (5/26/2011)
Ex.
1. Dr Vasudev Narasima MD Vasudev Narasima...
May 27, 2011 at 11:13 am
Why use a simple statement like update myTable set Salary = salary + 100? when a horribly slow and bloated cursor approach will take exponentially longer to run?
May 27, 2011 at 10:01 am
David Burrows (5/27/2011)
Ninja's_RGR'us (5/27/2011)
So in relation to your wife, what's the difference between union and union all? plz keep it PG! ;-):-PThe level of commitment 😉
LOL! Like the commitment...
May 27, 2011 at 7:38 am
Phil Parkin (5/27/2011)
Sean Lange (5/26/2011)
Phil Parkin (5/26/2011)
I use a binary search to do this...
Phil the pedant steps in 🙂
What you have described is a 'bisection method' - a binary search...
May 27, 2011 at 7:27 am
Let us know if want/need some help.
May 27, 2011 at 7:10 am
Sounds like what he wants is a way to find duplicate patterns of strings in a field and remove the second occurrence. Of course this would require parsing the field...
May 26, 2011 at 8:55 pm
Aside from that query being a total mess (as you obviously are well aware and unfortunately can't fix), the functions in your where clauses make it not SARGable. Not really...
May 26, 2011 at 8:44 pm
Ninja's_RGR'us (5/26/2011)
Awesome, I had to talk about it... you'd be surprised by the # of people who don't know the difference.!!
hehe I just had to clarify that exact topic to...
May 26, 2011 at 8:18 pm
Phil Parkin (5/26/2011)
I use a binary search to do this...
Phil the pedant steps in 🙂
What you have described is a 'bisection method' - a binary search acts on a sorted...
May 26, 2011 at 3:01 pm
Viewing 15 posts - 14,611 through 14,625 (of 15,381 total)