Viewing 15 posts - 31,846 through 31,860 (of 59,102 total)
I believe Tom has this nailed. The Green Arrowhead used to be the "run" command prior to SQL Server 2000. In 2005 and up, it's now the "run...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 11:15 am
Heh... you've gotten really good at hitting "hot spots" for me in your articles, Andy. π
[Rant ON]
Unless you're the project manager, there's no way to reduce this type of stress...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 10:27 am
I have to ask... how many columns do you have in common between the header and detail tables? There should only be one an only one column in common...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 9:35 am
BWAA-HAAA!!! I love it. Powershell... deprecation warning. Yeah... let me run out an learn how to use that!:-P
The more things change, the more they stay the same. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 9:22 am
Gosh, there are a thousand reasons why this might be so... anywhere from someone changing the FILLFACTOR on the Clustered Index to having an improperly configured or less capable disk...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 9:14 am
mahdib21 (11/26/2011)
The "AS" phrase is producing an error :/?
First, post the code that you're actually having a problem with. Lots of folks make a mistake when copying code.
Second, are...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 9:01 am
vani_r14 (11/26/2011)
I am trying to come up with a Script that lists the dates individually in each month in a column format.
Currently i have written a function...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 8:57 am
AmitAgrawal (11/25/2011)
Hi,You can try below solution
delete T1
from MyTable T1, MyTable T2
where T1.dupField = T2.dupField
and T1.uniqueField > T2.uniqueField
Finally... a different idea than the rest. However, that uses a Triangular Join....
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 8:49 am
dastagiri16 (11/27/2011)
delete from talbe where id not in (select max(column_id) from talbe group by column_name)
Except for the missing columns, that's identical to the original problem-code. π
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 8:45 am
Cadavre (11/25/2011)
Since this post seems to not want to die, here's an update of the test script I posted before to include the unique solutions posted since.
Heh... apparently reading previous...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 8:42 am
It's the same as any other alias... either of the following methods work just fine...
SELECT SD_SalesOrderID = SD.SalesOrderID,
SH_SalesOrderID = SH.SalesOrderID
...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 8:34 am
znkin (11/27/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 8:16 am
viiki.seth (11/27/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2011 at 7:50 am
I'll have to leave it to one of the others, thenm Robin. SSRS isn't my strong suite.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 26, 2011 at 8:49 am
rmechaber (11/24/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 26, 2011 at 8:36 am
Viewing 15 posts - 31,846 through 31,860 (of 59,102 total)