Pandu_age40 Posted August 31, 2015 Report Posted August 31, 2015 Example . Let's say I have a cricket table and it has cricket player individual score column. if cricketer scores 50 last month and 60 this month I need to put it as 50+60 = 110 to the current month scor column ... Gimme some ideas bros... My table has some 5000 rows and no primary keys. The only way I can get unique key is by combining 4 columns. Need some thoughts
Raja123 Posted August 31, 2015 Report Posted August 31, 2015 Example . Let's say I have a cricket table and it has cricket player individual score column. if cricketer scores 50 last month and 60 this month I need to put it as 50+60 = 110 to the current month scor column ... Gimme some ideas bros... My table has some 5000 rows and no primary keys. The only way I can get unique key is by combining 4 columns. Need some thoughts good
Pandu_age40 Posted August 31, 2015 Author Report Posted August 31, 2015 good Ade ga torture no primary keys
mtkr Posted August 31, 2015 Report Posted August 31, 2015 good neelaantode DB n tbl design chesinoduu
sqladdict Posted August 31, 2015 Report Posted August 31, 2015 Use temp variable table Declare @vartable table (col1 , col2 col3) Put the summary data from source table to this table...
tables Posted August 31, 2015 Report Posted August 31, 2015 give source and destination table structure man, then query build cheddam
Recommended Posts