Hi,

Thanks a lot for your help , Its working with using Max and group By .

I want these values as seprate :

Id , IIN ,IMS

So ,If i am using else here it is giving me blank values ,I want to use only...

I have to calculate the amonts for Previos day ,SO I am using where

condition

WHILE ( @DateMinRes <= @DateMaxRes )

BEGIN

INSERT INTO...

Thanks !!

yes its good to use csv ,but can I use this cvs for creating multiple tabs also.

i.e.

I am having some value as @date

Select * from table1 where date=@date

Select...

Thanks !!!!!

Hi,

Thanks yes its working fine , I was doing some mistake last time..

Thanks But Its not working , I want to delete all records from TableVariable

Thanks to all for the replies. The solution given by Lynn and Chris was Perfect....

Currently I have started as

Case

CASE

WHEN CHARINDEX('ZY050340',Data)>0

FRom XYZ_TB

Thanks a lot for suggestions: 🙂

Hi I got help from my colleague and we are doing like this as:

Select @trancount= ( cast( substring(Data,charindex('KL0509',Data)+8,7) as int)-1) from DB..ABC_TB

----------------------------------

select Data,

DB..String_FN( (cast( substring(Data,charindex('KL0509',Data)+8,7) as int)-@trancount), 7,...

Thanks!

What should I use ,If want to Overwrite the existing file :

Currently I am using below query ,but its not working....

@sql = 'copy ' + @from +...

Thanks for the information about MOVE command. I was not aware about this earlier.

I have now implemented my requirement using the MOVE command.

Is there any other way to implement this...

I got the solution from one of my colleagues

Please find the solution below

DECLARE @from VARCHAR(200)

DECLARE @to VARCHAR(200)

DECLARE@to_move VARCHAR(200)

DECLARE @sql VARCHAR(200)

DECLARE @sql_mov VARCHAR(200) ...

just for faste performance and for learning purposes