This is actually a good example of a bad design.

Make a separate table:

CREATE TABLE Periods (

PKCOLUMNs from original table,

Period tinyint,

EV_FFM (unknown datatype),

CONSTRAINT...

Here is an excellent article[/url] for utilizing the "quirky" update to perform running totals. Lutz has already pointed you to the best articles for pivoting your data. (You might notice...

What do you get when you run this?

SELECT MBLD.Total_Loan_Amount, MBL.Total_Loan_Amount

FROM dbo.MBL_Daily MBLD INNER JOIN dbo.Master_Bidder_Listing MBL ON MBL.Cert = MBLD.Cert

WHERE MBL.Total_Loan_Amount <> MBLD.Total_Loan_Amount

If this works okay, try with those numbers...

sqlbi (8/27/2010)

...

Why not just make a job that runs the package every minute / 5 minutes, etc.?

Jack,

In looking at the I-9 form from your previous link (2nd post in thread), I see something that might help you out:

You need to produce documentation that

1. Establishes your...

I just ran this on a server running 9.0.4053, and it works just fine. Sure sounds like a trigger to me.

if object_id('tempdb..#temp') IS NOT NULL DROP TABLE #temp;

CREATE TABLE #temp...

In T-SQL, this will work:

select [StartOfYear] = DATEADD (year, datediff(year, 0, getdate()), 0),

[EndOfYear] = dateadd(day, -1, DATEADD(year, datediff(year, 0, getdate()+1), 0))

Reporting Services is...

Sigh. (Bang head on desk).

How to do troubleshooting 101...

So, where all do you have '2003'?

Oh, it's here:

(2003-04,2003-05))

how about putting those in quotes, like:

('2003-04','2003-05'))

Can you try creating a spreadsheet instead of copying a template? Just use the Execute SQL Task to run a create table statement, pointing to the Excel destination. If the...

SET ROWCOUNT is on the deprecated list. Use TOP (n) instead.

Andrew Notarian (8/27/2010)

After playing around with this a bit, yes it needs to be done separately. It can be combined on the CREATE TABLE, but not on the ALTER TABLE.

So:

ALTER TABLE systeem...

You've actually got two things going on:

1. The selection of the records to insert, and

2. The actual insertion of records into the table.

As everyone else has already covered, the use...