Viewing 15 posts - 646 through 660 (of 1,229 total)
nick-1043370 (1/6/2012)
The bummer is it's a different date range each time! Ideally I'd like whatever code I use to get the date range in question first, i.e. find the...
January 6, 2012 at 6:41 am
Koen Verbeeck (1/5/2012)
Thanks again everyone for their congratulations!
You're the daddy!
Well done dude. You know those little foam things you put in your ears when you're clay-pigeon shooting? Get some!
January 6, 2012 at 6:16 am
nick-1043370 (1/6/2012)
I need to take a set of records for people with hotel check-in/check-out dates, and display a table that has a column for each date in the range, with...
January 6, 2012 at 6:11 am
Brandie Tarvin (1/6/2012)
...Am I the only person who hates the idea of an entirely NULL rowset with only an Identity in it?
A polititian? :hehe:
January 6, 2012 at 4:48 am
Shamshad Ali (1/6/2012)
Hello chrisM@home,There is one scenario in which the query is not returning me expected data when there is no any Parent exists in groupAssociation table ....
Since you...
January 6, 2012 at 4:41 am
Without specifically capturing dates, you might get some milage from this:
SELECT a.Reference, x1.codes, y.[DESCRIPTION]
FROM #TempData a
CROSS APPLY(
SELECT codes = REPLACE(REPLACE(REPLACE(a.codes,'& ',''),'/',','),' ',',')
) x1
OUTER APPLY (
SELECT b.[DESCRIPTION]
FROM #TempCodes...
January 6, 2012 at 4:24 am
Can you post the actual plan for both queries - and the code for the function? Looks like the function is being executed once per row and it only needs...
January 6, 2012 at 2:38 am
How long does this take to run:
SELECT [item] FROM dbo.fn_Split('33',',')
Can you post the CREATE statement for this function?
January 6, 2012 at 2:22 am
SQL Kiwi (1/6/2012)
January 6, 2012 at 1:26 am
J Livingston SQL (1/4/2012)
.....unless someone can provide a solution that is just as quick to run.???...
A recursive CTE yielding an output set would do the job in about 4 times...
January 6, 2012 at 1:25 am
atchristian (1/3/2012)
...I do NOT have a primary key set. The primary key would be: TradeID, AnalysisTypeID, VolumeTypeID, Hour...
If this is the edge case it appears to be, then you may...
January 5, 2012 at 1:03 pm
Evil Kraig F (1/5/2012)
ChrisM@home (1/4/2012)
Shredding XML isn't instant - you may gain by separating this from the...
January 5, 2012 at 12:51 pm
CELKO (1/5/2012)
...Buy a copy of HIKING IN SETS for more details...
My cat bought this book and got completely lost on the first example - with a catnav.
January 5, 2012 at 12:49 pm
drew.allen (1/5/2012)
ChrisM@home (1/5/2012)
drew.allen (1/4/2012)
ChrisM@home (1/4/2012)
say there are ten rows with the same VND_ID and only one of them matches the filter?
You'll need to post sample data illustrating the problem and...
January 5, 2012 at 12:44 pm
Viewing 15 posts - 646 through 660 (of 1,229 total)