Viewing 15 posts - 1,396 through 1,410 (of 3,221 total)
Heck we all do that at times
March 7, 2011 at 7:53 pm
Craig Farrell (3/7/2011)
So you're looking for something like this?
SELECT
t1.*
FROM
UnnamedTable AS t1
JOIN
(SELECT
[id],
MIN( times) AS mintime
FROM
UnnamedTable AS t2
GROUP BY
[id]
) AS drv
ONt1.id = t2.id
and t1.times = t2.mintime
Think you have to change your...
March 7, 2011 at 6:14 pm
chaudharyabhijit
Now the result set shows me over 10,000 rows and i was wondering how can i create a query to find out just the ones that are duplicates.
And once these...
March 7, 2011 at 12:59 pm
Duncan Pryde (3/7/2011)
I've now finally answered every QOD in existance! (until tomorrow's comes out, anyway)
It's been a tough...
March 7, 2011 at 12:16 pm
Jamie Longstreet-481950 Posted Today @ 4:28 AM
Other than speaking of your own expertise, what is there to convince a developer to follow these obscure rules...
Least anyone...
March 7, 2011 at 6:19 am
Please reply here
http://www.sqlservercentral.com/Forums/Topic1073727-1292-1.aspx
March 6, 2011 at 11:27 am
Have you downloaded and installed the adobe flash player plug-in (Active X plug in) for whatever browser you might be using?
If Internet Explorer - you can down load from:
March 5, 2011 at 1:58 pm
amittheming
To help others to assist you, please, please post the table definition, sample data in an easily usable format, and most importantly the desired results from the sample data.
...
March 5, 2011 at 8:19 am
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Congratulations .... excellent with the jelly bean analogy even a dummy like myself was able to understand the process.
March 5, 2011 at 7:37 am
First of all a good maintenance plan should include backup/recovery. Are your using Simple Recovery or Full Recovery Model?
Second what is your apparent obsession with SHRINKING either...
March 4, 2011 at 4:06 pm
Sean Grebey-262535 (3/4/2011)
March 4, 2011 at 3:47 pm
Would be thinking of running that with various of the 50 or so parameters supplied and looking at the execution plan ......
and making decision to simplify based on the...
March 3, 2011 at 5:00 pm
GSquared (3/3/2011)
I just edited the original post to make the link fully explicit.
Returned to your "edited" original post .. now the link is WORKING like a charm.
Nice visual...
March 3, 2011 at 11:05 am
GSquared (3/3/2011)
While you won't see my ETL and database work...
March 3, 2011 at 10:47 am
Viewing 15 posts - 1,396 through 1,410 (of 3,221 total)