PaulB-TheOneAndOnly (10/9/2009)

---

Two solutions...

1) Application in database A knows when a row is ready to be "moved" to database B, isn't it?... so, let application in database A connect to database...

Alright I will try create table script with sample data in it. I just want to know about the possible strategies in doing such scenario and I think the script...

Hi All:

Thanks for your prompt response. The current scheme is an existing one before I came into this company and the reason that they this kind of design is they...

Florian Reischl (4/16/2009)

---

There are some things I don't understand:

* Why is the "Region" only shown for the first region?

* Why are the "District Four" without a "Region"?

* Why is "District...

Please see code below for the object create scripts and sample data, sorry bout this:

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Definition]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

BEGIN

CREATE...

Andrew,

Yes it is okay now. Thanks for the great script, it is working...I really appreciate it.

One thing I have been working on though (which was an added functionality lately) is...

andrewd.smith (4/7/2009)

---

What XML do you want to be...

Actually I have those data that you need by the time I generate the hierarchical data from the mapping table. I apologize...

Thanks for your prompt response andrewd.smith.

Actually I have those data that you need by the time I generate the hierarchical data from the mapping table. I apologize for not making...

Bruce W Cassidy (3/12/2009)

---

[font="Verdana"]Reading over what you were proposing, I'm not sure it actually would add any value to load the XML into SQL Server. Processing it with your...

Bruce W Cassidy (3/12/2009)

---

[font="Verdana"]You should be able to bulk insert the header file into an XML column, and read it out from there. The second part just use normal...

Hello guys,

There has been a changes with our design and i think it is good. Instead of having one internal file with multiple tables, the service beforehand created one file...

Thank you Lutz and jcrawf02, for supplying me this helpful information. I really appreciate it! it works!

Best regards,

James

Lutz,

Thank you for this sample code, though I was just wondering about the tally table, can you show the details inside this table? I couldn't find one even on the...

Oh okay. Thanks for the informative input Adi. I will try this and will let you know on my progress.

Thanks so much.