Viewing 15 posts - 31 through 45 (of 136 total)
I haven't done this myself, but I would probably try to apply the concepts behind splitting strings using a tally table that Jeff Moden explains in this article: http://www.sqlservercentral.com/articles/T-SQL/62867/ You...
December 4, 2011 at 7:43 am
Using NOT EXISTS, here's how you would return all rows from City and State with a value of CustomerID that does not exist in Paid:
SELECT City.Name, City.City, State.State
FROM City INNER...
December 4, 2011 at 7:20 am
Eric Niemiec (12/3/2011)
Also without knowing your entire situation and schema, I would take the NOT IN approach as it is slightly easier than the EXCEPT syntax.
Except that NOT IN exhibits...
December 4, 2011 at 7:10 am
LutzM (12/3/2011)
If I'd only know the expected result based on the sample data I might be able to provide an alternative solution (using ROW_NUMBER() and/or CROSS APPLY)...
I played with those...
December 3, 2011 at 10:24 am
tmccar (12/3/2011)
Yes, that's looking good. The actual file has 51 columns and 117,000 rows but it should be possible to apply the same procedures to it.
Yep, the general concept should...
December 3, 2011 at 9:37 am
tmccar (12/3/2011)
...The "first occurrence" will be the lowest value of "Project_" in "Large". I hope that's clear!Tom
Note: In my code above I'm assuming that you want the first value of...
December 3, 2011 at 9:24 am
tmccar (12/3/2011)
...The "first occurrence" will be the lowest value of "Project_" in "Large". I hope that's clear!Tom
Yep, that helps a lot! Try this:
SELECT Large.*, Small.[Path]
FROM (
-- Create a derived table...
December 3, 2011 at 9:22 am
And...this sort of looks like a simplified reposting of this: http://www.sqlservercentral.com/Forums/Topic1215790-391-1.aspx
I'm going to second LutzM and strongly suggest that you provide DDL, sample data, and an example of your desired...
December 3, 2011 at 6:57 am
Why are you grouping if you aren't using any aggregate functions? Maybe you're actually looking for SUM(ISNULL(OverT.OverTH,0)) grouped by AttendDate?
December 3, 2011 at 6:54 am
Satya_0000 (12/3/2011)
How to find permormance issue with repect to Parameter Sniffing? and how to resolve it.
Well...I would start by looking for performance issues in general, and then trying to determine...
December 3, 2011 at 6:49 am
tmccar (12/3/2011)
and I only want the first occurrence...
December 3, 2011 at 6:42 am
Last night I decided to throw together some (simplified) test data and example code to illustrate some of the points in my previous post, and in the process, realized that...
December 1, 2011 at 5:31 am
OK...been tearing into this quite a bit tonight, and I think a rewrite may be in order for the parts of the query that pull the actual financial information. There's...
November 28, 2011 at 8:38 pm
sotn (11/28/2011)
We found in the BIOS the power saving setting, so now CPU-Z is set to 2100 Mhz instead of 800
However the query was still marginally...
November 28, 2011 at 10:49 am
yingchai (11/28/2011)
Hi JonFox,I attach the full query (.txt) and execution plan (.sqlplan) here. Thanks.
Thanks yingchai! I'll have to take a detailed look at this tonight after work, but at first...
November 28, 2011 at 8:50 am
Viewing 15 posts - 31 through 45 (of 136 total)