Hmmm. Now this is going to have...

Most definitely!

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)

---

It doesn't help basically i want it to be in.. wether im doing mistake some where in the script?

...

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)

---

I also want to add links to these 3 blog posts because there is much more detail. I still do not have the magic way to take...