- Joined
- Jul 8, 2005
- Messages
- 22,492
- Likes received
- 999
- Thanks received
- 191
- Location
- Castle Saburac
sql server 2005
I have two tables
table A has columns id, stepvalue, status
table B has many columns id, 'F' & stepvalue ,,,,,,,,,
I want to put A.status into B.F??
I tried this using two SP's , a wrapper with a cursor plus one that executed each stepvalue but it was way too slow
A has 6k rows
B has 100
I have two tables
table A has columns id, stepvalue, status
table B has many columns id, 'F' & stepvalue ,,,,,,,,,
I want to put A.status into B.F??
I tried this using two SP's , a wrapper with a cursor plus one that executed each stepvalue but it was way too slow
A has 6k rows
B has 100

