Another option...

delete a from

(select *, row_number() over (partition by CityName, Zip, Description order by CityName) as x from SC) a

where x > 1

You have a terminology problem here, so it's hard to understand...

Yep - that...

This query...

select *, Year * 100 + Month as YearAndMonth from #t1

...gives this output...

/*

PRID Month Year ...

Here's another way...

select PRID, YearAndMonth / 100 as Year, YearAndMonth % 100 as Month

from (select PRID, min(Year * 100 + Month) as YearAndMonth from #t1 group by PRID) a

For a start, you can just take what you've done and nest the query you were putting into #A1

select #A1.PRID,Y,Min(Month)

from (

select PRID,Min(Year) as Y

...

jpettigrew (4/30/2008)

---

Hello All,

I need to create stored procedure that will output information created 3

months after the record was created. For example: if the stored procedure was

run today or based...

Use the other post! This one is the duplicate! Leave it alone... 😉

You'll get a reply, don't worry. The trouble with posting it twice is that someone might spend time trying to help you, only to discover you'd already been helped, or...

Duplicate http://www.sqlservercentral.com/Forums/Topic490818-359-1.aspx

Please don't cross-post.

Got me again! 😀

The characters are probably some other 'invisible' characters - like tabs or returns.

Use something like this to figure out what the ascii values are...

select distinct ascii(substring(MyColumn, number, 1)) from myTable...

This site is for SQL Server - you need a different site. Try this one...

http://www.dbforums.com/forumdisplay.php?forumid=81

Like this?

insert tableA

select col1, col2, col3, ... ,'MHCIRC1208' from tableA where bspid like '%CI11%'

Or is 'MHCIRC1208' derived somehow?

I hate it when that happens 😀