Do you have non numerical values in table s?

Try googling "CAST SQL" or "CONVERT SQL"

You should be able to just copy and paste the codes and replace the column names.

I'm assuming you are refering to and have already tried this?

Password

If the child package is password protected,...

Oops, it seems like you have the opposite problem.

Right click on the job and open the properties.

Go and edit the job step where the package is being executed.

Go to Execution...

I ran into the same issue and the following steps worked for me.

Right click on the job and open the properties.

Go and edit the job step where the package is...

Same result as TakeITeasy, but using a derived table.

SELECT*

FROM(

SELECT ROW_NUMBER() OVER (PARTITION BY id ORDER BY adate desc) AS ROW,

id,

amount,

adate

FROM @t

) T

WHERE T.ROW = 1

If you have a static table for qualifiers, you can create a script that selects the fields with the delimiter and qualifiers.

SELECT fn_GetFieldWithDelimiter(Column1, 'Column1') + fn_GetFieldWithDelimiter(Column2, 'Column2') + ...

FROM...

I see...

I'm guessing you have a config table with ColID, IsQualified, Qualifier columns, and within the CLR you'll be doing a look up by ColID?

Have you considered using bcp utility?

You can use ROW_NUMBER() with PARTITION clause.

http://msdn.microsoft.com/en-us/library/ms186734.aspx

I believe the web page can't insert while T1 is still open because of index locks. T1 should only be doing page locks (depends on your existing row vs inserted...

Both are still true by default.

However, there are way to explicitly prevent them from happening.

SQL Server has no multi-version consistency model, which means that "writers block readers and readers block...

I can take a stab at it, althougth I've never needed to predict performance improvements per hardware upgrades...

I would start by making sure all the proper indexes are present. (I...

Does the 4 gb belong to the server hosting the virtual machine or to the virtual machine?

I...

Try using UNC path instead of F:\