You could also bring all the tables together into one table using a partitioned table. You would just have to add a new partition each month. This way,...

You can add an Execute SQL Task before your package completes that executes the following code:

update dbo.YourTable set

export = 1

where

export =...

Limiting the number of responses you can post to another users post limits the discuss that can occur with some questions/responses posted. You can learn a lot from these...

You say you are losing tables when you change compatability levels? Are you losing user tables or system tables?

😎

WILLIAM MITCHELL (10/25/2008)

---

I'm not in favor of changing the order of columns, but it is possible.

It is very easy to change the order of the columns in SSMS if you...

I find I stay a way from sites that charge a fee for joining, which is one big reason I like SSC. I can get help here when I...

I know many people who use the BEGIN END even if there is only one statement. They do it so that if they need to add additional statements later,...

We are deploying Hyperbac at my current employer. It does what we need, allows us to use native SQL Server Backup/Restore commands, does well on compression, and has decreased...

Books On-Line (BOL) is the best place for you to start reading. As you read through the various parts regarding security and still have questions, don't hesitate to jump...

GilaMonster (10/10/2008)

---

Oh, please......

Well, first of all, I had to fix the code you posted. Both tests ran the same stored procedure. After fixing the code, yes the stored procedure with...

Okay, freaky!! That's where my thoughts were also!

😎

Me too! Our problem was we were focused on trying to figure out why the query wasn't working instead of finding an alternative that would.

😎

Then I'd try this:

select

obitno,

oaorsc

from

hsdet

inner join hshed

on...

Just a guess, but try this:

select

obitno,

oaorsc

from

hsdet

inner join hshed

...