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!

Register Log in
  • Congratulations SkipVought 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

hamzam

Technical User
Jan 19, 2020
1
0
0
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.

Similar threads

grnzbra
  • Question
SSIS in SQL Server 2022
Replies
4
Views
137
grnzbra
grnzbra
marydn
  • Locked
  • Question
Send Nicely Formatted SQL Query via Email
Replies
0
Views
113
marydn
marydn
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
105
mark williams
mark williams
Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
66
fredericofonseca
fredericofonseca
arunaramana
  • Locked
  • Question
what are the items in a collection that referred in foreach item type enumerator within foreach loop
Replies
1
Views
70
Igelchen
Igelchen

Part and Inventory Search

Sponsor

Back
Top