I'd go with the powershell as well, but here's one more alternative:

I've used SQLRecon in the past, which is free and did the job for me, but was last...

side note to mister.magoo: which SSMS add on is that that lets you group totals from the results grid?

CTE with variables? sure, it's just like any other SELECT statement WHERE SomeColumn = @Param is certainly valid; just declare the variables before teh CTE, adn make sure you end...

newbieuser (2/12/2013)

---

Thanks a lot Lowell. CTE works perfect. This sql is run within a loop in a program and it is causing performance issue.. I have created a topic(Remote Query...

UT excellent job with the DDL and sample data;

does this give you the results you are looking for?

SELECT

ID,

TTYpe,

TTime,

COALESCE(NULLIF(TFunction, ''), TStatus) AS...

bah the above won't work because of the local table.

divide and conquer is what you'll need to do i think.

i would try to use a CTE that gets just the...

amybe...but the problem with open query is your command has to be a static string...no variable, or concatenation of stirngs plus variables are allowed.

how would this worl for you:

SELECT *...

at least viewing the estimated execution plan would give you a ballpark number;

it works for me fine when i use

EXEC(@ViewStr)

--or

EXEC sp_ExecuteSQL @Statement = @ViewStr

I don't think you need the parameters in the EXEC anyway;

the string passed doesn't have...

i believe that unless you have started your instance with trace flag 1807, the server can only attach databases that exist on local, and not network storage.

the trace flag is...

NineIron (2/12/2013)

---

Here's an example list. I need to exclude this MRN from my query because it contains the value 250.

MRN ...

davidsalazar01 (2/12/2013)

---

Lowell,

It's only one occurence (e.g.<DID>) in the XML and your right I only want the data between the tags. Would the samples you posted do the trick? ...

could the script be overwriting the same backup file with differnet databases?

ie the db "Dictionary" gets backed up to C:\Data\Backup.bak, and then the database "SandBox" overwrites teh exact same file...

david the select statement you posted will find where the END tag begins...wouldn't you want the value between the <did> </did> tags?

could the opening <did tag have attributes?

is there more...

You probably have all the links you needed now Jeff, I'm late to the party on this one, but here's one more:

Project Gutenberg has a large number of ftp mirrors...