You mean like this? This is throwing error. I thought the convert 101 is for T-SQL.

CONVERT(DT_STR,REPLACE(LEFT((DT_WSTR,20)DATEADD("d",-1,DATEADD("m",DATEDIFF("m",(DT_DATE)"1901-01-01",GETDATE()),(DT_DATE)"1901-01-01")),10),"-","/"),101)

• This reply was modified 3 years, 7 months ago by  SQL Server.

Nevermind... I got it...

SELECT ID,
       MIN(CASE AddrType WHEN 'Home' THEN HomeCity END) AS HomeCity,
       MIN(CASE...

I tried =IIf(Round(Fields!Qty1.Value,3) = Round(Fields!Qty2.Value,3),"Red","Black")  and it is not working.  Could it be because we have some NULL values?

• This reply was modified 4 years, 2 months ago by  SQL Server.

It is giving me error on TRIM that 'TRIM' is not a recognized built-in function name.  We are on SQL Server 2016.

I am sorry. I should have been more clear. Actually I would like to DELETE the records which are NOT matching.

select Replace(Reverse(stuff(reverse(@Text),CHARINDEX(reverse('files_'),reverse(@Text)),len(@Text),'')),'.xls','')

Don't know how come I missed that. The BWAvg will be NULL when the data is inserted and will be updated later.

insert into tblData3 Values ('4567','ABC',NULL)
insert into...

It comes in file and then we have SSIS package to insert it into SQL table which has data type of varchar.  Now when we want to use the Amount...

I had tried string_function, but that only output single column.

Thanks