Database

SELECT 
    myid, 
    mydate
FROM 
    myTable
WHERE 
    myid NOT IN (SELECT 
                     myid
                 FROM 
                     myTable
                 WHERE 
                     mydate IS NULL)

SELECT myid, mydate<br />
FROM myTable mt1 <br />
WHERE not exists (select 1 from myTable mt2<br />
                  where mt2.myID = mt1.myid and mt2.mydate is null)

new_phoenix wrote:

Does anybody know where there is an article about how to write a .HLP help file? It is my understanding that it can be done in Windows and can also be done in a web type application.

Mehawitchi wrote:

I take it that you are dead sure that no way on earth could a "Select" statement pick more than 255 columns.

<br />
Create procedure sp_Call_Refresh_ValuationRoll_dts <br />
AS <br />
declare @Command varchar(1000) <br />
SET @Command = 'DTSRun /S SGIIRCONETGS01 /U sde /P topology /N Valuation_Roll_Refresh' <br />
<br />
EXEC master.dbo.xp_cmdshell @Command <br />
GO <br />

<br />
xp_cmdshell failed to execute because LogonUserW returns error 1909. please make sure the service account SQL Server running under has appropriate privilege. For more information, search Book Online for topic related to xp_sqlagent_proxy_account.<br />
Msg 50001, Level 1, State 0<br />

Sonia Gupta wrote:

we are told to stop using the goto keyword , as far as the memory consumption is concerned.