You might try searching this site for this to be sure, as I know I have read it somewhere, might even have been a Question of the Day.

You need to...

Just use that as the working title. :w00t:

Steve could always retitle it prior to publishing.

😎

Not a problem, I just thought I might have missed something somewhere. So, should this be written up as counter-point article to the one that started this?

😎

True, but when you script the create statement or edit the table in the designer in SSMS, the columns are listed in the order you defined them in the initial...

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 (...