Thanks Hugo for the explanation

good basic question to start the week 🙂

+1

very nice question as doesn't know much about OUTPUT clause 🙂

easy one for the Tuesday....

As there was no question on Monday so I was expecting some Tricky question today 😛 :hehe:

can you plz send the script the you are using for this?

Ok

then my suggestion is to store words in separate rows so that you can perform operation LIKE as you mentioned.

Hi,

It depends on your requirement. If you to perform any operation on those words later like update etc. then its better you store those 70K words in 70K rows...

try this too....

;WITH mycte AS (

SELECT iCalendarDatCategoryID,vcCalendarCategoryCode,iSchoolYearCode,dtCalendarDay,

ROW_NUMBER() OVER(PARTITION BY iCalendarDatCategoryID ORDER BY dtCalendarDay) AS rn

FROM #Temp1

)

SELECT iSchoolYearCode, min(dtCalendarDay) as [Quarter Start Day], max(dtCalendarDay) as...

you can try this one now...

;with cte as

(

SelectiSchoolYearCode

,dtCalendarDay

,iCalendarDatCategoryID

,vcCalendarCategoryCode

,ROW_NUMBER() OVER(Partition By iSchoolYearCode, iCalendarDatCategoryID Order by dtCalendarDay) RowNumber

From#Temp1

)

SelectiSchoolYearCode

,Max(Case

When vcCalendarCategoryCode = 'Quarter Start Day' Then dtCalendarDay

End) As [Quarter Start]

,Max(Case

When vcCalendarCategoryCode = 'Quarter Grade...

ok i didnt ran that query..

lemme try again

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 dtCalendarDay...

you can do this using CASE also..

good one micky....

I was also going to write the script with using UNION ALL as yogi already described...

i think you get your answer now 😛

you can also do backup and restore through a sql query...

Backup

Backup Database db_name

TO DISK = 'path of the location'

WITH FORMAT

RESTORE DATABSE db_name

FROM DISK = 'path where your databse file is...