Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-11-16 : 09:45:02
|
| Pritesh writes "I am Having One Master Table Call Customer and Detail Table call Citys.My problem is I am having 10000 Records in Customer Table and on save Detail Citys having 16000 Records.I am binding My dataset with DetalTable Customer with Manule created '' as City column..and in "For Loop" i am filling my dataset with citys value comma seprated for Customer records Now is there any way to write query logic so i can get data fast.. write not it is working but to slow please help me..RegardsPritesh" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-16 : 09:55:24
|
| select * from customertable inner join details on details.city = customertable.cityPeter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Detail Table Data