Oh I see. I will have a look, thanks 🙂

Hi Igor,

No. The issue is "''''''''''''''''"...so many! because for every ' I have to do '' to escape it. Is there another way to escape in TSQL? So I can...

but then it will still have many apostrophes? just in a different location~

Hi Igor,

What do you mean?

Ha :pinch:

select name,

case

when maths > science and maths > comp then 'maths'

when comp > science and comp > maths then 'comp'

else 'science'

end

from student

Do what Jeff said but replace

PARTITION BY StudentName

With

PARTITION BY SubjectName

Can't delete this thread~ The TRY/CATCH did work \o/ its just that the output file didnt print any text after the error.

Elliott Whitlow (7/25/2013)

---

YAlso using linked servers to reach out to a lot of servers tends to fail, a lot. It can be done but it is not idea. SSIS is...

Oh I have this: http://www.mssqltips.com/sqlservertip/1037/system-information-in-sql-server-2000-vs-sql-server-2005

My question was more whether anyone has done "CREATE VIEW sys.databases ...;" already or not~

Ah I see, <> ignores nulls too o:

Wouldn't you use IS NOT NULL and > 0?

According to here[/url] it will rebuild everything. The easiest way to make sure would be to just schedule it on some database to run tonight then go back tomorrow &...

See which account the SQL Server process is run as. Grant privileges to that one.

Hi David,

Have you run your maintenance plan? If so is there any that haven't had stats collected on them since the last run time? If so then they haven't all...