If at all possible, move the execute outside the loop. Concatenate a where clause if you need to then perform the execute once. There is also a way...

Maybe I'm missunderstanding this but why do you have to wait? Can't you create a dependency on the creation of the file and the step that needs the file?...

If you are using DTS to move the data then this is possible through transformations. You could do this using a VB script transformation. If you need furthur...

Is the datatype for this particular column nvarchar, nchar or ntext? These support unicode and should eliminate your problem.

Darren

Darren

What exactly are you trying to do? Look at "Summary and Grouping Behavior in the Query Designer" in books online. Is that what you are looking for?

Darren

I got it to work. Use a transformation of type VB Script and use the string manipulation in the example below. This assumes the length of the string...

I also found this in Books Online:

When using DTS to copy data between SQL Server databases with different code pages and collations, data may be lost or incorrectly translated.

To...

Are you using DTS Import? If so, you can specify the transformation and you can check what it's setting as the default datatype.

Darren

Are you looking at the Event Viewer application logs or the sql server logs? If it's the latter, what is the name of your SQL server registration in Enterprise...

Do you have the log files and data files pointing to 2 separate disks? Are you using a RAID 5 configuration? Does it seem like reads and writes...

I work for a utility billing software company. We developed a CIS system from scratch starting in 1998. We didn't even hire a DBA until 2000. Although...

I was assuming you would fill in your table names where I guessed on the names. By query Analysis do you mean Query Analyzer or perhaps viewing the Execution...

Who's maintaining the user logins for SQL Server? Can you ask them to give you sysadmin access instead of giving out the sa password?

I would try putting the values of your in clause into a temp table or static parm table, then join to that vs. having such a big "in" clause. ...

I would use a sub select.

Like:

select Customer, count(*) from CustomerTable where CustomerId in (select distinct(CustomerId) from Sales where CustomerHasSaleFl = 1)

group by Customer with rollup

with rollup gives you the grand...