Okay, now he has crossed the line!! Who the hell does he think he is calling me a liar!!!!

<>

Excuse me??? I made a mistake???

I'm sorry, but I don't appreciate being called...

All Alex needs to...

Considering the question was supposed to be humorous, everything. This site is more...

From BOL (Books Online):

DBCC CHECKIDENT

(

table_name

[ , { NORESEED | { RESEED [...

WayneS (7/1/2009)

---

raghu,

May I ask why you felt it necessary to delete your initial post? The problem you were having may be useful to someone else; without your problem description they...

Paul White, Love your new avatar!

What nerve this one has to change the posted code after I had posted a solution. I should have quoted the original post. I won't make that mistake...

Here is the data and code as copied from the thread. Please note the expected results are wrong for ram!!

Eswin (7/2/2009)

---

Jeff,

Table:

Create TABLE SomeTable1

(

Date datetime,

teacher varchar(5),

student varchar(3),

class char(1) )

Data:

INSERT INTO...

It may be now, but it wasn't at the time I copied down your code. ...

Eswin (7/2/2009)

---

Christopher Stobbs (7/2/2009)

---

Depending on how you system works you might need to make this dynamic as you may get more years creeping in for example 2009/2010/2011 ect.

if you need...

There are only two ways you might be able to accomplish this feat. First, if you running SQL Server 2008 Enterprise Edition, you can use native compression during the...

Really? That's it? How about this:

create TABLE dbo.SomeTable12

(

SchoolYear SMALLINT,

Teacher varchar(5),

Student varchar(3),

Class char(1) );

INSERT INTO dbo.SomeTable12

(SchoolYear, Teacher, Student, Class)

SELECT 2006,...

RBarryYoung (7/2/2009)

---

Lynn Pettis (6/30/2009)

---

Roy Ernest (6/30/2009)

---

David, That was funny... Gail, Grant, Lynn, Jeff, GSquared and all of you the Ghost busters... :hehe:

Lynn, you were posting at break neck speed today.....

What is the exact result you want and is the source date a datetime column?