stored procedure

Mar 26 2019 2:18 AM

with the help of this query im unable to show states in gridview...so what do i do..?

can you please help me with this?

ALTER PROC[dbo].[Sp_StateFromDT]

@State VARCHAR(20),@FromDT VARCHAR(15)

BEGIN

SELECT User_id AS 'User_id',USERNAME AS'USER_NAME',Date_Of_Visit AS 'Date_Of_Visit',State AS 'State'

FROM DailyAudit WHERE LOWER(ATM_Id) LIKE LOWER(@State)

AND Date_Of_Visit > @FromDT

ORDER BY Date_Of_Visit DESC

END

Answers (1)