WITH CTE_NA AS
(
SELECT
 ContractNum
, Name
, ROW_NUMBER()OVER(PARTITION BY ContractNum Order BY CASE WHEN Name='N/A' THEN 1 ELSE 2 END) AS seq
FROM #USER
)

Hi All,
I am very bad at formatting,please dont mine.Let me know if it works for you!!
SELECT
                          QL.USERAccounts
                         , QL.Accounttype
                         , QL.Billingcode

I have tried with getdate please change it to the date you need and I have convereted into a string..
UPDATE  [EC_StoreAttributes]

SET Left(AttributeValue, 2)...