Thanks for your suggestions. I guess simple join would work out for this scenario. I would reach out to this forum in case if I face problem on mapping for...

Thanks for your reply. We think passing the datatype along with the parameters in XML format, would be better than hitting the INFORMATION SCHEMA tables.

Thanks,

Nags

Thanks Matt. It was clear on when to choose Output Clause over Trigger.

Nags

Thanks for your replies. I understand Trigger has more benefits than the Output Clause. Only thing I am worried about is the Performance of the Trigger. Is there any performance...

Grant & Jack,

Thanks for your reply. DRI is surely important.

10 to 15 ms for the referential integrity check would not be an issue. Will it be a concern/ suspected to...

Hi,

Thanks for your reply. We are still debating on choosing the Column Vs Extension tables approach.

I understand the constraint on fixing the attributes count to 25. We are in the...

Hi,

Thanks for the reply.

My problem here is the Attributes in the Container are dynamic. Also the Ticket information would be spread across multiple tables. In that case, I need...

Hi,

Thanks for your reply. I understand the Pivot is for generating grouping/ aggregating reports. I will check the link that you have provided.

I am planning to use Multi-Tenant -...

Hi,

I need to convert rows into columns for the following table values.

Attribute_ID Attr_Value

1 'Test'

2...