Nope, not required. A INSERT + UPDATE stament could do it; else, as you are in SQL 2008, you can use MERGE syntax to do that in one shot.

Post...

Doable, but with a bit of help from you.

Please read the following article and provide us create table, sample data and ur expected output based off of the sample data

How...

Try DATENAME function

Totally lost.... can you be more elaborate on what u r trying to accomplish?

take a look at this article for more information -> How to post questions[/url]

Schema binding has its own advantages and disadvantages.. But whn u create a view, how ofter do u alter it? You wouldnt right? then i think, schema binding can be...

Yep, Practice and experience can only...

Jeff Moden (5/2/2012)

---

ColdCoffee (5/2/2012)

---

Jeff, this following produces wrong result for STUFF

SELECT STUFF(CONVERT(VARCHAR(30),'2012-12-12 18:07:33.933',7),4,5,'-')

Result -- 201-12 18:07:33.933

But this produces proper result:

declare @date datetime = '2012-12-12 18:07:33.933'

SELECT STUFF(CONVERT(VARCHAR(30),@date,7),4,5,'-')

I guess, the CONVERT, when...

For anyone that is interesed in solving the problem but feeling sore due to OPs attachement, pfa the .sql file that has the table script, insert statements and my solutions...

Method 1 (Multiple Row Number)

; with base as

(

SELECT sg.schoolyear, sg.schoolid,sg.GradeCd,g.GradeSortNbr

, rn1 = row_number() over...

Jeff Moden (5/2/2012)

---

Most of us will be in trouble if we go to a country that uses more than 3 character abbreviations for months. 😀

Regardless of language selected (well... at...

Completely agree.. it looks more of a dud column..

We dont need , 2 ROW_NUMBERs

this will do

; with cte as

(

select t.teacherid,t.tlname,t.tfname, cast(t.schoolid as varchar) as schoolid, s.schoolname

, rn = row_number() over (partition by t.tlname,t.tfname order by...

try this

; with cte as

(

select t.teacherid,t.tlname,t.tfname, cast(t.schoolid as varchar) as schoolid, s.schoolname

, rn = row_number() over (partition by t.tlname,t.tfname order by s.schoolid)

from teacher t

join school s...

Can you reduce the number of rows in ur sample data? my SSMS hangs while i copy paste it 🙁

Did u alteast read the article me and Lynn pointed?