Jeffrey Williams (10/27/2008)

---

Lynn Pettis (10/27/2008)

---

Actually, I think it better to have standard columns like these listed first in the tables as they shouldn't change. This way, as new columns...

Where is there a triangular join in this query? I am joining row i to row i + 1 using an outer join, then this derived table is then...

Here is some code to start with:

create table #TempTable (

PersonalID int,

fk_IntakeMainID int,

FullName varchar(64)

);

insert into #TempTable

select 1,1,'Bob Smith' union...

You may have to adjust the code I posted above to subtract 12 instead of 13. Give that code a test in a test environment. better yet, change...

Here is the code I'd try:

delete from table

where

asofdate < dateadd(mm, -13, dateadd(mm, datediff(mm, 0, getdate()), 0))

😎

When you are talking about keeping a rolling 13 months worth of data, are you talking about current month plus the last 12 previous months? For example, if you...

Here is some test code I just wrote. See if this helps you figure out what you need to do.

create table #TestTable (

OrderNo varchar(13)

);

insert into...

Jeff Moden (10/27/2008)

---

Man, would I like to be able to comment here on external articles so I don't have to sign up for every forum that has a "dangerous code"...

Let's start with the individuals who started the site and what they wanted to deliver. Then let's look at the people that have come to the site. I...

Since you were jumping from SQL Server 6.5 to SQL Server 2000, it is possible that some of the system tables from 6.5 were depreciated and then dropped from SQL...

Shree (10/27/2008)

---

I set a parameter to decide whether to include zero sales or not.

Select * From table

Where Case

When @NoSales = ‘No’ Then (...

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?

😎