Database

vanikanc wrote:

It is also ok, to write them to the database tables if possible.

BEGIN TRY
-- Write code that can throw error
END TRY
BEGIN CATCH
-- Catch error
END CATCH

vanikanc wrote:

I know I can google this as well but some times it takes a longer amount of time to find the correct link/article.

declare @sql1 varchar(2000)
Set @sql1 = '
    SELECT distinct
    sd.storeno storeno,
    sd.storename storename
    FROM
    test_table sd
    where sd.status=''''N''''
    ORDER by'
 
print @sql1

Set @sql1 = ' 
SELECT distinct 
sd.storeno storeno, 
sd.storename storename
FROM 
test_table sd
where sd.status=''N''
ORDER by'
 
set @sql1 = @sql1 + ' ' + @sort

'abc'

'a''bc'

SELECT TOP 2 C.CustomerName, Co.CustomerType, E.Email, E.Designation
FROM Customer C
INNER JOIN CustomerEmailBridge B ON C.CustomerType = B.CustomerType
INNER JOIN Email E ON B.EmailDesignation = E.EmailDesignation
INNER JOIN EmailPriority P ON E.EmailDesignation = P.EmailDesignation AND B.CustomerType = P.CustomerType
WHERE (C.CustomerID = @CustomerID)
ORDER BY P.Priority