By default XCOPY will prompt to overwrite files and since prompts cannot be resolved in xp_cmdshell without using TYPE and redirector/pipe, I suspect that is why 'nothing happens'

Try adding /Y...

No loops, no cursors, no RBAR

You just love patting yourself on...

One way to do the stream in sp is to use the sp_OA procs

DECLARE @conn int, @rs int, @st int, @f varchar(8000), @i int

DECLARE @hr int

DECLARE @sql varchar(255)...

Why? What purpose will it serve?

However, use Enterprise Manager (2000) or Management Studio (2005)

Or

Drop indexes and contraints on the table

Rename the table

Recreate the table with the additional column

Populate the new...

What do you mean by 'large' and what is the datatype of 'Text'

The usual way to do this is to use a function

CREATE FUNCTION dbo.udf_text (@ID AS int) RETURNS varchar(8000)...

SQL Server, under certain circumstances (eg CREATE / ALTER table), when generating constraint / key names, will add characters (like your example) to names to make sure they're unique

To avoid this...

REPLACE(CHAR(64+FLOOR(number/27))+CHAR(64+number-(FLOOR(number/27)*27)),'@','0')

The only other thing I can suggest is to use your original code, check that each query's syntax is correct and add the first query code to the end of...

I don't know Informix but suspect it is probably due to multiple joins using ansi-92 syntax. I think Informix requires the query like this

SELECT i.itin_booking_num, i.itin_revision_num, i.itin_delta_num, i.itin_item_id_num, i.itin_line_num,

 ...

make the first statement a subquery and JOIN it to the second, e.g.

SELECT i.itin_booking_num, i.itin_revision_num, i.itin_delta_num, i.itin_item_id_num, i.itin_line_num,

  i.itin_parent_id, i.itin_service_type, i.itin_operator_code, i.itin_service_info, i.itin_service_class,

  i.itin_departure, i.itin_arrival, i.itin_from_city, i.itin_from_city_loc, i.itin_to_city,...

bcp, by default, will treat the input file as one batch

To change the batch size use the -b parameter

e.g. -b 1

will set the batch to 1 row and will fire...

Do you mean

DATEPART(week,[date]) - DATEPART(week,DATEADD(month,DATEDIFF(month,0,[date]),0)) + 1

or is there something special about the 'week' number you want.

...try and do your joins in the FROM...

With apologies to Shakespeare, but could not resist

DECLARE @temp TABLE ([ID] int IDENTITY(1,1),ItemName VARCHAR(6),ItemNo  INT,ItemValue NUMERIC(20, 2))

INSERT INTO @temp (ItemName,ItemNo,ItemValue)

SELECT a.ItemName,a.ItemNo,a.ItemValue

FROM @MyTable a

ORDER BY a.ItemName ASC,a.ItemValue DESC,a.ItemNo ASC

SELECT a.ItemName,a.ItemNo,a.ItemValue

FROM @temp a...