Right now your query returns:

COMPANYCATKWcntcmpcntcatcntkw

PIZZA HUTPIZZAPIZZA555

PIZZA HUTPIZZAPIZZAggg555

PIZZA HUT ADPIZZA ABCPIZZA555

PIZZA HUT PKPIZZA INDOPIZZA555

PIZZA HUT SINGAPORE PTDLTDPIZZAPIZZA555

PIZZA HUT SINGAPORE PTE LTDPIZZAPIZZA555

PIZZA HUT UAEPIZZA PHPPIZZA555

Could you please show what exactly do you...

Give us your address and we will send you our invoices. It will cheer...

I can only suggest you to follow this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

select STUFF(s,4,len(s)-3,replicate('*',len(s)-3))

from

(

select 'Lokesh' s

union select 'Gowda' s

) q

river1 (5/24/2012)

---

It's as you told:

C:\Program Files\WinRAR\WinRAR.exe x -u "c:\import\PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - T - 1118.rar" "c:\import\PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - ...

select GROUP_ID, EMP_ID, NTILE(4) OVER (partition by [GROUP_ID] order by [EMP_ID]) AS GROUPLIST

from [dbo].[EMP_REC]

Because MS introduced FORMAT function into SQL2012 . May be they done it to pick on you...

:hehe:

... Besides missing...

You should always use ISO format (YYYY-MM-DD) when converting string values into datetime (or date). This will work regardless of server locale.

river1 (5/24/2012)

---

This is how the command tries to execute:

"C:\Program Files\WinRAR\WinRAR.exe" x -u c:\import\"PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - T - 1118.rar" c:\import\"PastaExportacao SGCTlocal - 4.01 -...

try using double quotes around file name:

set @NomeFinal ='"file1 codp meta2.rar"'

Eugene Elutin (5/24/2012)

---

If it's followed on twitter now, I just wonder if the OP did try...

Not very clear what the problem is. You have duplicate records which you don't want to show?

Use : SELECT DISTINCT.

Otherwise, please provide DDL and sample data as per link at...

insert into [dbo].[EMP_SUMMARY]

select GROUP_ID, EMP_ID, NTILE(4) OVER (ORDER BY [GROUP_ID], [EMP_ID]) AS GROUPLIST

from [dbo].[EMP_REC]

If it's followed on twitter now, I just wonder if the OP did try my favoured...

colin.counsell (5/22/2012)

---

Ok, thanks guys.

On my connection I get '5496', whereas in the job it is '5176.

The diff being that my connection has ARITHABORT and QUOTEDIDENTIFIER switched on.

I'll try and change...