Hi,

If i've multiple rows, then Header and Footer values are repeating for each Report row. I dont want to repeat them, I just need them as seperate attributes.

Hi,

When i executed this with my query, It is giving me the following output:

<Reports>

<Report>

<Header>

<PrintedDate></PrintedDate>

...

Hi,

How can i get the below format, I need to add a Header, Footer to the existing XML .

<Reports>

<Header>

<PrintedDate>23/01/2001</PrintedDate>

<PrintedBy>XYZ </PrintedBy>

</Header>

<Footer>

<DocumentPreparedBy>ABC</DocumentPreparedBy>

</Footer>

<Report>

<Name>123</Name>

...

Hi,

How can i get null row values in the below format? When i tried, I'm not getting the NULL value rows in the XML, they are being sipped.. I need...

The above solution works, I've replaced the sample data with my own query to get the desired result.. I actually want to construct XSL FO with this XML and create...

Hi,

Thanks for the reply, I cannot provide the table schema due to some VM problems here. Can you please join 2 tables with sample data to get results in the...

The select query worked, i've deleted the unmatching records earlier and when i ran this query it didnt return any rows..

Thanks alot!

Any Update on this?

Hello,

Thanks for the comeback, I really apologize for not being able to write down DDL queries, Now I've a question on my database design and below are the assumed requirements....

Hi,

The query logic is exactly what i'm looking out for, But when i ran the query the MERGE statement is throwing below error,

The MERGE statement attempted to UPDATE or DELETE...

I need to write both the cases,

If match found in table A and table B, Then i need to write the output like

Table A ProjNumber Table B ProjNumber...

thermanson (8/27/2012)

---

I haven't tested this since there was no test data supplied, but I think this should work.

Insert into MergeTable (Project number, IsProjNumConverted)

Select Coalesce(x.proj_id,i.proj_id) as projID,

...

We are not using SQL Authentication rather client asked us to connect using windows mode authentication as the database, our user accounts are in one domain (LDAP).. Everything is based...

Any solution for this?

The above query is also allowing to insert duplicate records..

ChrisM@Work (9/6/2011)

---

The image columns aren't required for this exercise, take up an inordinate amount of...