Jump to content

Recommended Posts

Posted

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

Posted

Antey group by aa

Posted

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

Posted

Use temp variable table
Declare @vartable table (col1 , col2 col3)
Put the summary data from source table to this table...

Posted

give source and destination table structure man,

then query build cheddam

×
×
  • Create New...