Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Convert number to certain value from table

    sajikv2007 - Thursday, January 26, 2017 9:28 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')
    ...

  • RE: Convert number to certain value from table

    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...

  • RE: t-sql 2012 compare datetime fields

    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....

  • RE: Extract Num-Value from String

    Try this :

    DECLARE @String VARCHAR(50) = '#BAVDB#(RowCount=3204)';

    SELECT REPLACE(Right(@String,LEN(@String)-CHARINDEX('=',@String)),')','')

Viewing 4 posts - 1 through 4 (of 4 total)