Viewing 4 posts - 1 through 4 (of 4 total)
January 26, 2017 at 9:30 am
Check this logic.
DECLARE @tbl_value TABLE (Code INT NOT NULL,Name VARCHAR(10) NOT NULL);
INSERT INTO @tbl_value(Code,Name)
VALUES (1,'A')
,(2,'B')
,(3,'C')
,(4,'D')
DECLARE @User_val...
January 26, 2017 at 9:28 am
It depends on how you want to compare both the fields. If you want to compare only the date then you will have to convert or format the datetime fields....
January 16, 2017 at 3:14 am
Try this :
DECLARE @String VARCHAR(50) = '#BAVDB#(RowCount=3204)';
SELECT REPLACE(Right(@String,LEN(@String)-CHARINDEX('=',@String)),')','')
January 16, 2017 at 1:51 am
Viewing 4 posts - 1 through 4 (of 4 total)