i though blank() was a new SQL 2012 function, haha; pasted it to test and everything!

without the real code, i could just post a snippet:

but it something like this:

SELECT ColumnList,Priority

From YourTable

GROUP BY ColumnList,Priority

ORDER BY

CASE Priority --the column we will custom...

not sure what you can do yet;

two of the values cannot be directly converted to TIME datatype (the zero and negative values)

msdn says the possible values for TIME datatypes are...

Sure :

...

ORDER BY

CASE

WHEN 'Top Priority'

THEN 1

WHEN 'High'

THEN ...

holy crap! you have people with sysadmin permissions, on the Live server, Klutzing around and making DDL changes at will?

time to update your resume, it's only a matter of time...

same issues remain...run and test your code, don't just change one thing and re-post it..

test test test!

Lowell (4/4/2013)

---

ok then, here's two hints:

1. your final SELECT belongs outside of the loop,...

vivekkannan.k (4/4/2013)

---

thx Lowell 🙂

yes u r correct, users have Sysadmin permission .

Is there any way to Audit the Changes (delete , disable) on DDL Triggers .

The sys.triggers table has...

there's a VALUES command hanging out there, and the column names should not be in single quotes;

create table PendingIO (

[database] varchar (100),

Physical_name varchar (100),

io_pending int,

io_pending_ms_ticks int,

io_type varchar (20),

num_of_reads int,

num_of_writes int,...

ok then, here's two hints:

1. your final SELECt belongs outside of the loop, not inside.

2. your final SELECT command with the Department and SUM() should not reference any @variables whatsoever.

if...

looks like an incomplete paste from your actual source? can you edit and put the whole command that is failing?

only a sysadmin can disable the triggers, so as long as only you have sysadmin permissions, it's not a problem.

if other people have sysadmin,and you want to prevent them from...

you are grouping by a variable instead of the column from the temp table.

this is not allowed:

GROUP BY @Department

there is no need for a cursor in the operation you...

posts like this make me want to cry.

you offer training, but seem to be asking...

also, the If Not Exists is a scripting option.

you can set it yourself, so that from whenenver you change the setting, it scripts the objects out as dynamic sql with...

the mere existence of linked servers will not affect anything; it's the same as your phone having my number, and my phone having yours; they are independent.

now if you try...