Please avoid posting the same question multiple times.

Is this related to this question?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=185868

Forgot to add. Create the new table first and add an INSERT INTO newtable before the SELECT.

select min(userid), count(*) from tLogins

where userid>=1 and userid<=20

group by userid

Well, then...

Q1: Have a look at BOL for NOT EXISTS. You don't remove duplicates with it, but rather insert only those rows that...

Counterquestion:

Q1: You are aware of SQL Server's Books Online?

Q2: You have searched this forum for answers?

Now if this has helped, and you're a lazytyper, this should also work

select left(datename(month, < your column > ),3)

I would consider this a task for your presentational layer. anyway, does this help?

select left(convert(varchar,<your column >,100),3)

Piggy-backing on Dave, SQL Server doesn't not automatically reclaim space unless this space is needed for inserting a new row.

Google groups beta sucks...

I had this thread in mind http://snipurl.com/f95u

Isn't it strange? I have an evening off, kids are asleep very early and I hang around this forum.

Okay, I've just created a...

I would contact MS PSS to help you out here.

Maybe this will give you some ideas.

create procedure dbo.validatedate @inputdate char(6)

as

 declare @31st datetime

 set @31st = '19001031'

 select dateadd(month, datediff(month,@31st,cast(@inputdate+'01' as datetime)),@31st)

 --your other stuff goes here

 return

go

exec dbo.validatedate '200501'

drop procedure dbo.validatedate

But as...

Has your developer experienced any issues with this word?

Maybe you get some additional ideas here: http://www.sommarskog.se/share_data.html