Luis Cazares (12/10/2013)

---

This is a possible solution for 2005 because it won't accept the VALUES table construct.

SELECT cStudentID, Quarter, GPA

FROM #Temp

CROSS APPLY (SELECT 'CummulativeGPA', CummulativeGPA UNION ALL

SELECT 'Q1GPA', Q1GPA UNION...

Thanks For Your reply.

I run...

Awesome

Thanks You so much. It works Perfect for me...

Sean Lange (10/15/2013)

---

Here is another way to do this. I added an identity column as a primary key.

This should work for any combination of spaces and X's.

See the link in...

Awesome Thanks for Your Help !!!

Here is DDL and sample Data

CREATE TABLE #TEMP

(vcPeriods char(20))

INSERT INTO #TEMP VALUES (' X ')

INSERT INTO #TEMP VALUES (' ...

Sean Lange (10/11/2013)

---

You are very welcome. Make sure you read that article and understand what the splitter function...

Sean Lange (10/10/2013)

---

yogi123 (10/10/2013)

---

Hello

I need to Create a Function who pulls data from string and load to the table. here is sample string

'CHG_FEP_SVC_GRP_ID(1) :: Expected Value = 1 :: Actual...

Steve Jones - SSC Editor (6/17/2013)

---

It looks like the cleanup task failed, not the backup. Did you check the backup file?

As mentioned above, you should have a detailed log for...

Sean Lange (6/4/2013)

---

Awesome job posting ddl and sample data!!! This is exactly the right way to post!!!

Here is one way to solve your challenge.

select * ,

case when x.iSchoolYearCode is null...

Lynn Pettis (4/11/2013)

---

autoexcrement (4/11/2013)

---

Sorry, I would like to help, but there are just too many things about all of this that don't make sense to me.

For example, why are...

Thanks Sean Lange and Lynn Pettis

really Appreciated

Hello

I Attach Screen Shot

Please Check it and let me know any thoughts

kapil_kk (2/20/2013)

---

try this.. hope it will work

SELECT

iSchoolYearCode,

CASE WHEN vcCalendarCategoryCode = 'Quarter Start Day' THEN dtCalendarDay ELSE 0 END AS QuarterStartDay,

CASE WHEN vcCalendarCategoryCode = 'Quarter Grade Closing' THEN...

I try this

select iSchoolYearCode,

CASE WHEN iCalendarDatCategoryID = 15 THEN dtCalendarDay

ELSE '' End,

CASE WHEN iCalendarDatCategoryID = 89 THEN dtCalendarDay

ELSE '' End

from #Temp1

but didn't work