Try this script. You need to look at your duration figure as it appears to be more than a week. I also assumed that you use '10' to seperate the...

Dynamic SQL should do the job given required columns exists in all tables with the same name. Even if the columns names are different in some tables, you may be...

Thanks Peter.

Looks like either define @V2 as VARCHAR(MAX) or convert it to VARCHAR(MAX) in the concatination will give the correct results, but not NVARCHAR(MAX). Still don't know why though.

Try this: Sheets("Sheet1").Copy Before:=Workbooks("Book2").Sheets(1)

It's really a VBScript question. You can google for the answer (too many there) or try record a macro in Excel and then see the code (that's...

Please check your statement can...

CTE & ROW_NUMBER() were instroduced...

kimberlyphillips01 (5/22/2011)

---

Can someone tell me why my statements are adding days instead of weekdays? The returns on all of the variables and subselects are int, I have tried several...

Can you re-produce the problem with adjusting memory setting to it's original values? If you can re-produce it, it may be related to memory setting (but I don't know why...

Msg 50032, Sev 16, State 1: The process cannot access the file because it is being used by another process. LiteSpeed for SQL Server could not open the...

If I read it correctly, you are trying to replicate the 30 views for each schema for those users required. Any special reason for that? Can't you create the view...

There is no black/white answer, "it depends". It depends more on your specific query and environment. please post your query and plan.

Yes, restart service is the way to fix. Most interesting to me is that, I experieced this a few times on SQL2000 but not other versions above that (yet). I...

Try this script that list the columns of a table in any index:

select column_name = c.name

from sys.index_columns ic

inner join

sys.columns c

on ic.object_id = c.object_id and ic.column_id = c.column_id

where object_name(ic.object_id) = '<your...

One way might be set up a database role and grant "deny access" to those tables you want to hide from the user. Add those users as that role member.