Dinesh,

Jeff posted more clear and effective solution just 1 post above.

Actually he has to post this solution twice a week, because people don't bother to read previous postings.

CASE WHEN...

Dinesh, replace "1dd" with "1d3" int your data set and rerun your query.

See what happens.

You may copy data from static table, not from DELETED.

INSERT INTO dbo.AuditTable (ID, Col1, TextCol)

SELECT d.ID, D.Col1, T.TextCol

FROM deleted D

INNER JOIN dbo.MyTable T ON D.ID = T.ID

But it must be...

Read BOL about decimal data type.

DECLARE @Amount decimal

SET @Amount = 1000.49

SELECT @Amount

I cannot put the code within a stored procedure and pass the table name through.

No, you can.

Just use dynamic SQL.

Put @TABLENAME@ in your script instead of actual table...

No, it won't help.

Not using dynamic SQL and avoiding ad-hoc queries will.

Same result may be achieved with a little bit simpler query:

select t1.id, COALESCE (t3.[Name], t2.[Name], t1.[Name]) as Name

from Table1 t1

left join Table2 t2 on t1.id = t2.id

left join Table3...

Did you read the error message?

MSDTC on server 'SecondServer' is unavailable.

It's not a clue. It's a big fat point.

Zoran, are you a part of the system?

When they will install the system will they install you next to the server?

If yes then it's OK to use you knowledge as...

What tell there that 10 is input but 3 is output?

NULLIF(ColName, )

Replace default values with NULL. As it should always be.

COUNT does not take NULLs.

Where and when "select dbo.getDate()" works fine?

It does not work in my SQL2000.

Searching for '%company%' you'll get all records having 'accompany', 'accompanying', etc.

Is it what are you ready to accept?

Spaces before and after would not help because you probably need options '"Company"',...

What happens if you do it proper way?

DECLARE @EndDay datetime

SET @EndDay = dbo.fn_EQL_MakeDate(@EndDate, @InActPeriod)

SELECT field1, field2, CASE WHEN SalesOrder.SOM_SalesOrderDate BETWEEN @StartDate AND @EndDay THEN SalesOrder.SOM_OrderValAmt ELSE 0 END AS ActiveVal