Viewing 15 posts - 9,871 through 9,885 (of 14,953 total)
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(). ...
April 22, 2009 at 2:33 pm
You're welcome. Glad we could help.
April 22, 2009 at 2:30 pm
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,
...
April 22, 2009 at 2:27 pm
I replaced the final query with this:
DECLARE
@compid INT,
@begDate SMALLDATETIME,
@endDate SMALLDATETIME
SELECT
@compid = 17,
...
April 22, 2009 at 12:58 pm
That's pretty much the same thing I do. Disable indexes, truncate, load, enable indexes. It's very efficient.
April 22, 2009 at 11:10 am
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...
April 22, 2009 at 11:06 am
That's pretty usual. Lots of applications do something like that.
April 22, 2009 at 11:03 am
Make sure the SSIS package is on the same server where you're running the insert. That usually solves that problem.
April 22, 2009 at 9:52 am
You're welcome. Glad we could help.
April 22, 2009 at 9:49 am
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,...
April 22, 2009 at 9:48 am
Matthew Lehn (4/21/2009)
That's what I get for using Textpad (for the macros) to produce the sample dataset instead of SSMS, lol. Anyways, I PM'd the changes to you.
If you post...
April 22, 2009 at 7:01 am
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...
April 22, 2009 at 6:55 am
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...
April 22, 2009 at 6:50 am
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?
April 22, 2009 at 6:36 am
Viewing 15 posts - 9,871 through 9,885 (of 14,953 total)