I love the peer review here; i didn't think of spaces in table names at all...

makes me think it's better to grab the execution plans instead, and parse the XML,...

Here's my first guess at it; i left lots of stuff in there to look at to help understand it.

With PayRollHours (TheTime)

As

(

SELECT 1.5 UNION ALL

SELECT 30.75 UNION ALL

SELECT 40.00 UNION...

good...

i get very few false positives when i go after my procedure and function definitions using that technique:

SELECT definition,T1.*,T2.* from sys.sql_modules

CROSS APPLY dbo.DelimitedSplit8K(definition,' ') T1

CROSS APPLY dbo.DelimitedSplit8K(definition,' ') T2

WHERE...

you could search for words that exist after "FROM" and "JOIN", right? and that should get the tables, regardless of the prefix?

I'm playing wiht a splitting with a delimited...

can you post some more details? the DDL for the table, a couple of sample rows, and an example of what you have to change wehn you add a new...

Eric i see just a couple of things i'd change.

the IF UPDATE(Canc) is misleading...it doesn't test if the column changed...it tests if the column was referenced in the update;

some...

if you google "Oracle UNPIVOT", you should get some examples of this "transpose" thing you are looking for.

that one is a snippet from a specific report that gets sent as a raw text;

it's being padded so that in courior font it uses lines up in pretty...

SQLdr.Read would move the pointer to the next row; my code is very similar to yours, so i think RBarryYoung is right...it seems like you have a boatload of rows?

...

pretty sure your going to hit the wall trying to script the password;

ADD SIGNATURE TO OBJECT::[TestSendMail]

BY CERTIFICATE [DBMailCertificate]

WITH PASSWORD = '$tr0ngp@$$w0rd';

i was playing around and came up with this,...

As Lynn was asking, it's a real TIME datatype, you can add values via dateadd.

/*

(No column name)(No column name)

16:40:27.000000016:52:41.0000000

*/

declare @time time

SET @time = '16:40:27'

SELECT @time,DATEADD(ss,734,@time)

Are you sure about that?

copy and paste it to SSMS...that stops right away with a syntax check, since the EXEC command cannot exist inside the parameter list.

H4K (8/29/2012)

---

You...

I just tested this: you must drop all the objects that use the type, drop and recreate teh type, and then create all the objects that used to use it...

you want to make sure that YOU are in the database, so that when it is set to single user, YOU are the single user. otherwise, like if you rant...