SQLServerCentral » Latest topics
Generate a unique number for a combination
How do you generate unique number based on a Loannumber , Date columns
Example
Declare @loannumber Int = 1234565
,@date Date = '12-01-2017'
Declare @test table
(
LOannumber int
,Startdate date
-
Example
Declare @loannumber Int = 1234565
,@date Date = '12-01-2017'
Declare @test table
(
LOannumber int
,Startdate date
-
No comments:
Post a Comment