You still haven't shown us what you've tried. But from your required results, it looks as if you need a PIVOT query. If you search for "pivots and...

Sounds like homework to me. What have you tried?

John

Tony

If it's a collation conflict you're suffering from, you can use the COLLATE clause in your query. If the problem is different data types, you can use CAST or...

Please will you post the actual code you're running? If that is it, I would recommend sorting out the typos, syntax errors and undeclared variables before you worry about...

Brandie

Could the second one be from Object Explorer or similar? I think you get the third for linked server queries.

John

Import the XML into a staging table, then the <XMLColumn>.value function to shred it into the individual columns.

John

Chandan

Yes, for simple queries such as the one you posted, that's a good summary. Of course, there are reasons why the query optimizer may not pick the best plan...

Thanks. But the index which is being used is having only 1 column and if the other column is being retrieved internally from clustered index, shouldn't the execution plan show...

A non clustered index consists of the index key column(s) plus the clustered index column(s). That's why your query was covered by the non clustered index.

John

Do what I'd do, and type "xp_cmdshell" into your favourite search engine. If you're not familiar with the command line syntax of whatever zip utility you're using, you'll need...

What do you mean by "allocated memory threshold"? Is it an alert that's generated when a particular process uses more memory than the threshold you set? If so,...

Like I said, I can't see your screen. What is wrong with the results your query produces, and what is wrong with those my query does? Maybe you...

What is missing? Don't forget I can't see your screen.

I think you've made it more...

Gautham

First you said that the _dup table has the same columns plus an ID column, then you said that some columns may be missing. Do I take it you...

Russell

All five instances will be fighting for that 36GB. I would advise you to set max server memory on each instance, to stop that from happening.

Edit - when you...