Looks like your script is producing a prompt which cannot be catered for when using xp_cmdshell and will give you the symtoms described

Do the files already exist in the destination...

OK, OK, so a bit of a faux pas

answer should have been  (426.0/852)*100 based on first post instead of correcting remi

wow we all got it right, a point to everyone, except remi of course

The int/int in brackets will result in int before the division by 100.0

Try

select (426.0/852)/100

Sorry, some people might get offended (or I get beaten up by the moderator for using offensive language)

Politely put

Rubbish in, Rubbish out

Only meant as a joke

I guess your query will fail.......

Yep, c**p in, c**p out

May need to change the subquery to

(select count(*) from [#order] x where x.customerid=c.[id] and (x.[date]<o.[date] or (x.[date]=o.[date] and x.[time]<o.[time]))) AS...

If I have the ddl correct and you do not mind the results in updated date/time sequence then try

SELECT CASE WHEN [suppress]=0 THEN [Order_ID] ELSE NULL END AS [OrderID],

CASE WHEN...

Try adding backslash to the end of the xcopy to tell the system the output refers to a directory

eg

xcopy /Q "c:\Inetpub\ftproot\adam\MisBack\Bais\%1.AIS" "c:\Inetpub\ftproot\adam\Mission"

to

xcopy /Q "c:\Inetpub\ftproot\adam\MisBack\Bais\%1.AIS" "c:\Inetpub\ftproot\adam\Mission\"

Yes. As I said before I think you are pushing the limits of sp_executesql which has a limit of nvarchar(4000). EXEC allows you to concatenate several strings together e.g EXEC(@string1+@string2+@string3)...

We all can do that

Simply, if possible I would add the Company key to the select statement, wrap the whole statement as a subquery and join the Company table at that point.

I think you...

lol, nice one Farrell.

About time someone got one up on remi

Varchar will only store the actual data...

True.

declare @test-2 varchar(4000)

set @test-2='abc   '

will only store 6 characters (plus small...

SELECT b.Top_state, b.Tot_State, c.School_name, c.Tot_marks AS [Tot_School]

FROM (

SELECT TOP 5 a.Top_state, SUM(a.Tot_marks) AS [Tot_State]

FROM Tresult a

GROUP BY a.Top_state

ORDER BY SUM(a.Tot_marks) DESC) b

INNER JOIN Tresult c ON c.Top_state = b.Top_state

AND c.School_name...