look at the post again...the code for reading the status column is a...

yes...

exec sp_tables_ex LinkedServerName

that will show all the sheets(tables) that exist in the Excel spreadsheet...or any other linked server for that matter. that retrieves the metadata from whatever linked server...

mea culpa; it was low hanging fruit and i'm try...

syntax.

a case statement has only a single CASE keyword between the CASE and END,

ie

CASE

WHEN [condition1] THEN [value]

WHEN [condition2] THEN [value]

ELSE [value3]

END

you can look...

to get the table counts, i see you'll have to loop thru everything one way or the other;

here's one way to do what you asked...i'm using sp_msforeachdb, which uses a...

oops sorry i misread your code...i thought @KeyWhat was which field,@keywhere was the value...i updated my code, but it's not what you wanted...except if they only use one of the...

at the very least, you can get rid of the OR statements, correct?

it looks like your application picks two search terms, but your current WHERE statement you build searches 8...

the problem is you have a "do all find all" procedure. it has tha couple of problems:

multiple OR statements.

LIKE statements that start with a percent sign.

with multiple OR...

If a table was dropped, it's indexes went...

george here's one way to do it;

i'm using a function CHARINDEX2, which finds the Nth occurrance of a string within the string.

with that, i can find the first CrLf and...

here's one way to do it; in this case, i put the total Hours a s acolumn in the same row...not normalized, repetative, but the data is there.

this is based...

not true.

when it comes to compiling...

it's just a bit bigger: (19,4)

here's an example:

create table money(

mymoney money)

select * from sys.columns where name = 'mymoney'

select type_name(system_type_id) ,

type_name(user_type_id),

'('+ convert(varchar,precision)+ ','+ convert(varchar,scale) + ')'

from sys.columns where...

in SQL server, there is always more than one way to skin a cat:

this should provide the same logic...the order by is the key:

create table #NoName(

ProdCode varchar(30),

Width ...

Richard

for my DDL database trigger, I'm using execute as without an issue;

here's how my trigger starts:

CREATE TRIGGER [ReturnPREventData]

on DATABASE WITH EXECUTE AS 'dbo'

FOR

CREATE_PROCEDURE, DROP_PROCEDURE, ALTER_PROCEDURE

AS

here's a complete exampel for...