Get Previous Day Distinct Records in SQL Server

bhadriau

SOLVED CLOSED ACTIVE ANSWERED
User: bhadriau
Posted: on Jun 27, 2016 03:36 AM
Forum: SQL Server
Answer: 2
Views: 3374

Dear All,

Could you please let me know How do I get the result for " Report contains all users added the previous day"

Here I want to know make the where condition on "Createddate" column on yesterday date i.e DD:MM:YYYY:00:01:00 (AM) and DD:MM:YYYY:11:59:00 (PM)

I am new to teh SQL , please help me

Table1

FName   LName             Createddate
HGHG      A                    25:06:2016:00:10:000
JHGJ        B                   25:06:2016:01:18:000
JHGJ         C                  25:06:2016:06:10:000

Download FREE API for Word, Excel and PDF in ASP.Net

Shashika...

0 1

Reply
User: Shashikant
Replied: on Jun 27, 2016 03:37 AM
Report

Please refer below code

SQL

DECLARE @Table1 AS TABLE(FName VARCHAR(50),LName VARCHAR(50),Createddate VARCHAR(50))

INSERT INTO  @Table1 VALUES('HGHG','A','24:06:2016:00:10:000')
INSERT INTO  @Table1 VALUES('HGHG','B','25:06:2016:00:10:000')
INSERT INTO  @Table1 VALUES('JHGJ','C','25:06:2016:01:18:000')
INSERT INTO  @Table1 VALUES('JHGJ','CD','25:06:2016:06:10:000')
INSERT INTO  @Table1 VALUES('JHGJ','E','26:06:2016:06:10:000')

DECLARE @Date VARCHAR(10)= '25:06:2016' 

SELECT *
FROM @Table1
WHERE  SUBSTRING(Createddate,1,DATALENGTH(Createddate)-10) = @Date

I hope this will help you out.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Get Previous Day Distinct Records in SQL Server

Company

Explore

Follow us

Contact Us