My take on it. Prob better ways to get the result required

DECLARE @TempData TABLE ( tdID BIGINT IDENTITY(1,1),anumber BIGINT )

INSERT INTO @TempData

...

Just tried this on some text fields and it worked as expected for me. what types are the fields in question?

Try the following link

http://www.sqlteam.com/tools/bcphelper.zip

I use this when creating anything using BCP and saves me a load of time.

Pop a text box in the page footer with the information you want.

In the text box visibility properties hide based on the following expression

=Globals!PageNumber<>Globals!OverallTotalPages

This will only display on the final...

Quick google search threw up this:

http://support.microsoft.com/kb/937277

Have you considered / checked?

We had a similar problem where a CSV file we get supplied either has 275 or 256 columns.

To resolve this we read in the first line of the CSV file...

Can be done quite easily in SSIS.

See attached SSIS solution which will look through a directory and pop a message up when a xls file is found. All you...

As part of the data flow in SSIS add a Derived Column task (image attached), inside that, give it a Derived Column Name, set it as a new column or...

Ah, thanks for that 🙂 M

SELECT DISTINCT o.name, o.type_desc, p.name, p.type_desc

FROM sys.sql_dependencies d

INNER JOIN sys.objects o

ON d.object_id = o.object_id

INNER JOIN sys.objects p

ON d.referenced_major_id = p.object_id

Worth a try...

You could try grouping by user and doing a compare of the previous user to the current user being looked at possibly

http://blog.strictly-software.com/2011/11/error-copying-tables-importing-or.html

This seems to have a solution

You can do this sort of. The problem comes from the fact that you can (as far as I can tell) only look at the previous record within a...

You could change you code like the example below

WITH testdata

AS ( SELECT 222 AS ID...

Unless i'm missing the point??

The stored procedure exists on the server. The application connects to that server. If you need to change the server in the application then...