flebber.crue (4/24/2012)

---

My tables that I have setup are already very close to the layout you have described.

Importantly the intersection table looks like it would resolve a lot of the...

Can you replace the "SomeText" in the tables with the actual text.....so that we get to have a look at what you are actually looking at.

This would help us provide...

shani19831 (4/24/2012)

---

Sorry Guys i got it right

Here is the query

selectorig_branch_no,

acct_no,

amt,

description,

create_dt,

charge_code,

tran_code, (select t2.tran_code from history as t2

where t2.tran_code in (157)

and t2.description like '%DDAC%'

and t2.create_dt = '20110802'

and t2.acct_no = t1.acct_no) as 'Charge...

What is 'SomeText'?....Is it literally the String 'Sometext' or is it just a hypothetical representation of "some text that you have in your tables"??

I assume that you are talking about...

vahid.arr (4/24/2012)

---

vinu512 (4/24/2012)

---

One table for User Details is fine. You just need to check if the data that the table houses is in Normalized Form.

From what I understand you should...

These might help you to learn Encryption:

SQL Server Encryption

SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script[/url]

You could even do it from the client...

+1 seems like pure ETL. DTS Wizard would do this for you.

When I start designing a database I divide everything in terms of entities.

And then start designing master tables for every uniquely identifiable group of identities.

Then I create other tables and...

lol....that's a really good way of doing it.

Nice 1 Eugine.

Please post DDL of the tables and some readily consumable Sample Data.

I don't have a query for this but in normal circumstances nvarchar takes double the size as varchar.

Storage Size

Varchar - Actual Length (in bytes)

NVarchar - 2 times Actual Length...

Wouldn't a trace to check which query is doing what on which table help?

One table for User Details is fine. You just need to check if the data that the table houses is in Normalized Form.

From what I understand you should have another...

Yea. the OP is not elaborate enough for us to know what the requirement actually is