Hi,

I not able to get the desired result form the cursor!!.Is there any way to get the result.

Regards ,

Amit Gupta

Thanks peter !!

It's  working fine peter but i want to know ABOUT those cloumns also taht contains a UNIQUE CLUSTERED INDEX ON columns

Thanks & Regards,

Amit Gupta

Tariq,

Plz check it out! Is the system on which Sql server is installed is accessible to you or not??

IS there is a proper network connection between systems..

and one more thing...

Hi Michel,

I am using the following Query : but it is executing properly.

select ltrim(rtrim(convert(varchar(255),

'           gfbdfrfrf                 dfjdfhjdfh      kjfdkf           ')))

Regards,

Amit Gupta

Kenneth...

Thank you so much..

Hi,

Note : The corrections to be made in red

INSERT INTO PS_JWI_GENRPT_TMP1

select R.BUSINESS_UNIT,

R.PROJECT_ID,

R.EMPLID,

CASE when J.JOBCODE in ('100061','200061', '400061', '100064', '200064', '100073', '200073', '100070', '200070')  THEN 'Proj+' when...

Hi,

Use this one..

First Insert the Non duplicates records into a temp table

1) Select distinct * into #t1 from <table_name>

2) Truncated your Table

Truncate table <table_name>

3) Insert Non duplicate Records into your...

Hi,

Can you provide the script of table with insert statement so that i can check it ?

Regards,

Amit Gupta..

Hi,

Is both the servers on LAN (Local Area Network) if yes,then you can use the DTS Wizards to transfer all the Database and its all Objects into that server.

If No,...

Hi,

Press Ctrl + D before execution of your Query

and then Run Your Query

Regards,

AMIT GUPTA

MCDBA

Ritesh,

I want to ask a Question to you ?

Why you want to work in Sql Server 7. It does't allow you to execute a user defined function..

Regards,

Amit Gupta..

Ritesh,

Pls send the procedure and function to me and arrange a copy of database backup (if you can).

E-mailId: mailgupta_amit@yahoo.com

Regards,

Amit Gupta

Sorry!!!,Ritesh

There is no such feature in Sql Sever 7.0 , but you can do one thing.You can load the Sql Server 7.0 data into Sql server 2000 with the help...

Hi,

Use the folowing Query to solve your problem : it is slightly tricky::

SELECT 'R' Type ,COUNT(*) AS Records, CONVERT(VARCHAR, registerdate, 101)

FROM users WHERE registerdate > @startdate AND registerdate <...

Hi,

Don't ever use cursors.

Use temp tables in place of that.

***** Have a nice day ********

Regards,

AMIT GUPTA