triple post.

please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...

How is the xml variable stored originally?

Do you get it from an xml column, a flat file or anything else?

Is there any known filter you could apply within your openquery...

This is just another good example...

Glad we could help. 🙂

Edit: (Un)fortunately, we can't help you to get (a) shot. 😀

Another reason might be an additional UNIQUE constraint other than the primary key.

As you've stated above, you checked the KEYS section in SSMS. Did you check the CONSTRAINT section as...

It's rather a task for UNPIVOT...

Here's a sample (pretty much straight off BOL and slightly modified):

DECLARE @t TABLE (col1 VARCHAR (10), col2 VARCHAR (10), col3 VARCHAR (10))

INSERT INTO @t...

Obviously the horse is trying to drink from two springs at the same time. Here's...

Hi,

I'm a little confused... :ermm:

your first and your second post both describe a rather large update statement.

However, your third post is regarding an insert statement...

Maybe the misunderstanding is caused by the sample data you provided: they just don't seem to match at all...

Where can the result data for "a2" be found in base table...

Hi,

[sarcasm ON]

please look up "UPDATE" in BOL (Books On Line, which is the help file of SQL Server).

[sarcasm OFF]

More serious:

What do you expect as an answer by providing the amount...

It's hard to make any tested/verified modification to a query without having any table definition or data to test against.

If you'd like us to have a more detailed look at...

Hi,

please check if the following code will help you to get the expected results.

IMPORTANT NOTE:

Since there are no table definitions nor any sample data the code below is completely untested...

Hi,

you might want to have a look at the following article:

http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/.

It describes a fast way to generate a sequence of numbers/dates.

This could be used in an outer join to find...

Hi,

the following part of your code is a little confusing to me:

... 'update '+@TABLE+' set AuditData.TATCallType=''12'', AuditData.TATCallUnit=''1'' ' ...

If I'm reading your code correctly you're referring to @table with the...

Hi Bob,

following please find two options on how to define a view depending on how you'd need to get the results.

Since we don't have any more information regarding table definition...