Viewing 15 posts - 376 through 390 (of 860 total)
vinu512 (5/1/2012)
This does:
SSelect * From ClientDetailsWhere InterviewDate IN (Select MAX(InterviewDate) From ClientDetails Group By ClientID)
the problem with that query is the IN list contains the max interview date for each...
May 2, 2012 at 8:32 am
since in your other thread you ask how to build a tally table i thought i would give you one method to do it with a tally table. it...
May 2, 2012 at 8:07 am
crookj (5/1/2012)
Daniel Bowlin (5/1/2012)
Revenant (4/30/2012)
Peter Trast (4/30/2012)
crookj (4/30/2012)
Peter Trast (4/30/2012)
Peter Trast (4/30/2012)
Lynn Pettis (4/30/2012)
Peter Trast (4/30/2012)
EL Jerry (4/30/2012)
Daniel Bowlin (4/30/2012)
anthony.green (4/30/2012)
capn.hector (4/27/2012)
SQLRNNR (4/27/2012)
EL Jerry (4/27/2012)
Lynn Pettis (4/26/2012)
Freedom!Wallace?
Gromit
tie down
kangaroo
captain
Ship.
Wreck
Iceberg
Lettuce
Pray
ing
Mantis
Raimi
Spiderman
Mothman
The...
May 1, 2012 at 12:52 pm
paradski (5/1/2012)
May 1, 2012 at 12:46 pm
Lynn Pettis (5/1/2012)
If you would take the time to read the first article I reference below in my signature block and follwo the instructions regarding...
May 1, 2012 at 12:18 pm
Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
capn.hector (5/1/2012)
Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I...
May 1, 2012 at 10:07 am
jmadsen 98862 (5/1/2012)
It is quite disappointing that SQL ServerCentral continues to leave Mr. Celko's comments on this...
May 1, 2012 at 9:58 am
Can you post DDL and Sample date (See the link in my signature for help on posting that if you need it.) it looks like your where clause is...
May 1, 2012 at 9:33 am
looking through the code it looks like you select LinkID and name then run them through individually getting one result for each LinkID and Name. you can deffinitly rewrite...
May 1, 2012 at 9:29 am
S_Kumar_S (5/1/2012)
May 1, 2012 at 9:07 am
Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over...
May 1, 2012 at 9:03 am
imex (4/30/2012)
with CTE as
(
select ClientID, max(ID) as ID from ClientDetails group by ClientID
)
select d.ID, d.ClientID, d.InterviewDate
from CTE as c
join ClientDetails as d on d.ID = c.ID
Hope...
May 1, 2012 at 8:40 am
to those who are saying its a cross post look at the DDL and Sample data and output. clearly a different problem just that the OP used the same...
May 1, 2012 at 7:58 am
mohammed moinudheen (4/30/2012)
Sapen (4/30/2012)
If upgrading the OS to Enterprise edition is the only solution then I am sure it is wasted (budget constraints).
What would be the implications on SQL Server...
April 30, 2012 at 8:37 pm
Jeff Moden (4/28/2012)
capn.hector (4/23/2012)
SQLKnowItAll (4/23/2012)
Jeff Moden (4/23/2012)
capn.hector (4/23/2012)
+1 however i saw this same question as homework for one of my sql classes.
Interesting! Where did you take...
April 30, 2012 at 6:14 pm
Viewing 15 posts - 376 through 390 (of 860 total)