If you need more than one of the identity values at a time (inserting multiple rows in the header table), you can use the "Output" clause instead of Scope_Identity(). ...

You're welcome. Glad we could help.

Occurred to me after I wrote the above that there's an easier way to do this:

SET NOCOUNT ON ;

SET STATISTICS TIME ON ;

DECLARE

@compid INT,

...

I replaced the final query with this:

DECLARE

@compid INT,

@begDate SMALLDATETIME,

@endDate SMALLDATETIME

SELECT

@compid = 17,

...

That's pretty much the same thing I do. Disable indexes, truncate, load, enable indexes. It's very efficient.

There's an option in SSIS in the import control that allows you to tell it what character is used to begin and end fields. That's in addition to a...

That's pretty usual. Lots of applications do something like that.

Make sure the SSIS package is on the same server where you're running the insert. That usually solves that problem.

You're welcome. Glad we could help.

It's because you're selecting from the base table directly, not from a derived table with just what you need.

Try this:

Select emp_id, 'Sum Value' as PivotOn, DAP_Ord_AL, DAP_Rnt_AL

From

(select emp_id, PDFTextBoxName,...

If you post...

If I go to the conference (I'm definitely going to try to get the money together for it), I'll hopefully be able to stay at a friend's house. I...

Steve: You should read the first chapter of Problems of Work. The editorial reads like an excerpt from it. The book has some very good advice on...

insert into #TempTable (OwnerName, FatherName, RationCardnO)

values ('Aakula Anjaiah','Veeraiah Wap','6825011205')

And so on, for each set of values.

Is that what you need?

Excellent. Glad we could help.