Hope this will also fit to the situation.

create table mytest (Custid integer, CustGrp integer)

go

insert into mytest(custgrp, custid)

select 100, 331

union

select 100,233

union

select 100,332

union

select 101,322

union

select 102,423

union

select 102,873

go

Select

   A1.*,

   cast(a1.custgrp...

Program - > Administrative Tools - > Computer Management  -> Services and Applications - > Services

Search for MSSQL Server right click and start

Search for SQL Server Agent right click and start

Try this out......

INSERT LOGFILEHISTORY (FILE_NAME,SIZE_K,FULL_DATE,CHAR_DATE,CHAR_TIME)
SELECT FNAME,LSIZE/1024,FILE_DATE,CRDATE,CRTIME
  FROM #LOGFILES AS a
 WHERE NOT EXIST (
                    SELECT 1 
                      FROM LOGFILEHISTORY 
                     WHERE FILE_NAME = a.FNAME
                  )

Thanks,
Ganesh

I have tried all these options but it is not consistent.

1. SQL Query Analyster - >Tools -> Connection Properties -> Unchecked the SET ANSI_WARNING

Right click on the tempdb and refresh

Execute the...

Can you pls check the web user is a part of MSDB database. And it's cumbersome to create a user in MSDB for each of the web user.

Since you call...

Thanks a lot. It worked fine.

Say for example you are going to insert record to Table1 from Table2

Insert into Table1 (PrimaryColumn,Col2,Col3)

select  * from Table2 as source2

where not Exists (select * 

                          from Table1

                        where...

1. i need to query which are the unique accounts between the two tables

select * from TableOne

union

select * from TableTwo

2. i need all of the accounts found in Table two...

There are no provision provided by the Designer to install or deploy the packages on another server. While running the following script make sure the .dts resides on the same...

I would suggest let the stored procedure takes the database names as input parameter.

Sorry if my answer sounds silly.

Thanks,

Ganesh

Hi Smith,

Firstly I don't know whether my answer would help you or not because these kind of weird errors would come possibly for the configuration reason.

Next I would like you to...

One more way

DELETE

  FROM #Tmp

 WHERE Id IN

      (

      SELECT Id

        FROM #Tmp

       WHERE Id NOT IN

           (

            SELECT MAX(Cast(Id AS varchar(15)))

              FROM #Tmp...

I have understood two things from your question.

1. Since the stored procedure takes much time, the user doesn't know at what particular point the procedure is currently moving on.

2....

Hi,

In order to pass the value to the query dynamically, you have to go for Global variable. Then your query would look like this

select dnrt_phone_numb,dnrt_agency,dnrt_in_date

from super_dba.dncrt

WHERE (DNRT_IS_DATE > ...

It's really great thought. But If I want to execute a stored procedure which returns more than one value which I need to call subsequently in my nested procedure. How...