Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Selecting Unique record from a table RE: Selecting Unique record from a table
DataGuy
SSCrazy
Points: 2029
More actions
February 10, 2014 at 2:50 pm
#1687703
declare @StartDt DATE
declare @EndDtDATE
SET @StartDt = '2/1/2014'
SET @EndDt = '2/28/2014'
SELECT DISTINCT YOURCUSTOMERID
,YOURCUSTOMERNAME
FROMYOURTABLE
WHEREYOURDATECOLUMN BETWEEN @StartDt AND @EndDt