Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Increment a series on sql

Status
Not open for further replies.

hamzam

Technical User
Jan 19, 2020
1
DZ

Hello,
need help on sql server Please, I have 4 fields, I would like to Increment the series of Table1. (__First__) up to (__Last__) in table2 taking into consideration the field names 'Boutique' and 'produit';


Table1
|boutique|produit,| ___First__| ___Last_____|
|Levis__,|__jeans,|__20000010_|__20000012__|
|Bared__,|__parfm,|__20600001_|__20600005__|

Tabl2
|Levis__,|__jeans,|__20000010
|Levis__,|__jeans,|__20000011
|Levis__,|__jeans,|__20000012
|Bared__,|__Bared,|__20600001
|Bared__,|__Bared,|__20600002
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top