Hi Erikkur,

Thanks for the reply. Here is my try.

SELECT *

FROM

(

select Val,Cat,ROW_NUMBER() over (partition by Cat ORDER BY Empid ) AS Rn

FROM (SELECT Empid,Empname,CAST(Empsalary as varchar(50)) AS EmpSalary,CAST(Empdesignation as varchar(50)) AS...

Finall i am able to achieve with the below line,

queryout D:\Report.txt -T -c -t, -b 100 -S Resdox-0043\KGJ-DEV -U sa -P Pasword123

Ok, After browsing the web i found and i tried with the below option.

EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT N from sample.dbo.tally" queryout D:\Report.txt -N -S Resdox-0043\KGJ-DEV -U sa -P Pasword123'.

...

thanks, got the difference. If it is float, it does.

Appreciate your time.

Found the issue. It's problem with my text. it has some extra comma's. Thanks.

Hi Andrew,

Thanks for the reply.i did analyse further and seems it's problem with the CSV file. When i convert my excel data to CSV and if i open the CSV...

This is my updated Logic

declare @dt date,@UserCompanyId int = 100

declare @year char(4) = '2014',

@month char(2) = '03'

set @dt = @year + '-' + @month +...

Hi Josh.

Thank you Man. understood how to include quotes. Awesome.

Hi Jhon,

Yes, i knew i am missing the quotation for the path. that's what i mentioned on my first post. Here is my another try

set @sql= 'BULK INSERT...

Hey guys,

thanks for your replies.

my try :

set @sql= 'BULK INSERT ' + @TableName +

' FROM ' + @FilePath + ' WITH (

FIELDTERMINATOR = ''' + @delimiter +'''

,ROWTERMINATOR...

Hi Luis.

Yes, I don't have duplicates. So the first suggestion should work for me. Thank you for your suggestion and time on this.