The operation : -

'When right(itemcode,2) between 6 and 32 then "GL-0632'

Could only be used if you use a numeric value instaed of right(itemcode,2).

Regards,

Andy Jones

Hi, see the article: -

http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp

Regards,

Andy Jones

Hi, sounds like a full table scan is being performed. Indexes on all columns used to join / filter will improve things.

Regards,

Andy Jones

select A + ', ' + B from TABLE

Regards,

Andy Jones

Thanks for your comments - some answers: -

I used goto labels because my original solution required the logging of a specific error message and then a general one e.g. 'Load...

I save as 'structured storage file' and add to VSS to version control. To open a structured storage file, right click on the Data Transformation Services node in EM, select...

I believe dynamic Sql is the only way to achieve this, an alternative to using EXEC is sp_executesql which can reuse the execution plan, improving performance.

Regards,

Andy Jones

Hi, try,

select

c

,count(c)

from

(

select c1 as c from a

union allselect c2 from a

union allselect c3 from a

union allselect c4 from a

union allselect c5 from a

) t

group by c

This is for...

You could: -

1. Restore your DB with a new database name.

2. Delete all the other objects in the new database except the table you want to restore.

3. Use a DTS...

Are the source and destination tables both SQL Server tables? If so, then just use TSQL commands to move the data. If your source is a flat file or spreadsheet...

Instead of a trigger you could run SQL profiler.

Regards,

Andy Jones

If you're running the script from query analyser you can simply output to a file (not gird or text) by specifying on the toolbar (or tools - options menu)

Regards,

Andy Jones

It looks like FIRST_M_DATE is of char datatype and contains records that cannot be cast to dates and therefore dateadd fails.

Regards,

Andy Jones

Gloabal variables are also configurable when executing the package. When running from the command line use "dtsrun /A" or there is a global variables collection property of the package class...

You can click the parameters button to bind ? to a global variable. "I should be prompted for the parameter" I don't think this is the case, why do you...