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

Hello

so far I got this

SELECT iSchoolCode ,

iSchoolYearCode,

dtCalendarDate ,

ROW_NUMBER() OVER ( ORDER BY...

Sean Lange (2/12/2013)

---

This matches your description of your business rules but it doesn't match the data you said you wanted. Not sure which one is correct because you said

so if...

anthony.green (1/9/2013)

---

Yep that is correct.

ROLLBACK IMMEDIATE, will force any connections in that databases to stop executing and rollback what they where doing if they where in the middle of a...

so it means

ALTER DATABASE myDB SET SINGLE_USER...

Thank for Your reply

but job is failed to step-1 as killed spids

I need to resolve that.

anthony.green (1/9/2013)

---

What version of SQL are you running?

What is the purpose of the task at hand, do you just want to boot people out or are you setting the DB...

Thanks for reply

It was my bad

actual script is as below

declare @spid varchar(2)

declare @execstat nvarchar(10)

declare kill_cursor cursor

for...

Jason-299789 (1/3/2013)

---

Ok, I didnt realise there was any other logic.

This is a way to do it with a Left Join

Select t2.*

from #temp2 t2

Left Join #temp1 t1 on t2.StudentLocalID=t1.StudentLocalID...

Thanks for your help

can you please solve another way, so i can implement that in my real logic.

Thanks For Your Help

Great !!!

Thank You so Much

Yes, basically this Store Proc call to another procedure that import...

Hey

Now i got this error

Msg 3201, Level 16, State 1, Line 1

Cannot open backup device '\\10.9.2.109\stars\ABC\STARS_backup_2012_11_19_173006_6820968.bak'. Operating system error 5(Access is denied.).

Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE...

i check...

Eugene Elutin (11/13/2012)

---

BTW. Formatting your query nice, improves its readability and therefore its maintainability:

SELECT vcEmployeeUniqueID

,vcLastName

...