Viewing 15 posts - 1,216 through 1,230 (of 6,486 total)
The water cooler must be leaking, because it just got deep in here:).
That said - trying to disassociate law from social contract is like trying to separate a jelly fish...
July 12, 2011 at 11:19 am
keep in mind any string parsing relies on finding a pattern that isn't used. I personally wouldn't be banking on space as a delimiter.
July 7, 2011 at 2:03 pm
Looks like LOG() is the natural log. LOG10 is log base 10.
Keep in mind that LOGnnn(Y) = LOG(Y)/LOG(nnn)
July 7, 2011 at 10:53 am
one big difference:
SET @thevar = ( SELECT TheID
FROM TheTable
...
July 7, 2011 at 10:09 am
Sorry - I was in a bit of a hurry - so I wasn't as helpful as I should have been. That said - you did get the overall...
July 6, 2011 at 12:59 pm
Why not normalize the data and do away with the entire issue? Having repeating data in multiple columns is a basic violation of first normal form, so you will...
July 6, 2011 at 12:09 pm
One word of caution: be prepared with what you think in your head is appropriate and fair. The thing about bringing in salary reports like was suggested is...
July 6, 2011 at 9:23 am
As currently defined your procedure actually allows @b-2 to be null - what it doesn't do is it doesn't allow you to skip passing the parameter. In other word...
June 28, 2011 at 1:46 pm
sqlnaive (6/21/2011)
Agreed. Nolock should not be followed. However if MS has provided that hint, then where exactly it should be used [to be precise] ?
Like Grant said - it won't...
June 21, 2011 at 10:58 am
A second way is to simply specify the root. Stealing form Sean's example:
select [Your Field] as field from [Your Table] for xml path (''), root('fields')
June 21, 2011 at 10:27 am
davidandrews13 (6/17/2011)
select
'alias' = firstname + ' ' Surname
from
people
i can't reference that alias...
June 17, 2011 at 10:22 am
This may be counterintuitive, but - chunk up the update. i.e. do it as a bunch of smaller updates. Since you have an identity column as the clustered...
June 3, 2011 at 3:14 pm
djackson 22568 (5/24/2011)
john.richter (5/24/2011)
May 24, 2011 at 3:30 pm
Jeff Moden (3/10/2011)
WayneS (3/10/2011)
and probably more efficient than correlated sub-queries.There's only one way to know, huh? 😉
I would have expected Wayne to be right, but in 2K8 - I'm getting...
March 10, 2011 at 10:17 pm
If she's a veteran then she should know that that's not a very good set of instructions to start from. You could always try approaching it with some form...
March 9, 2011 at 9:30 pm
Viewing 15 posts - 1,216 through 1,230 (of 6,486 total)