Do it right way:

Select

 dbo.OffsetCalc(entered_offset,offset1) as Date1,

 dbo.OffsetCalc(entered_offset,offset2) as date2,

 dateadd(ss,Entered_offset+offset1,'1980-03-01') as realDate1,

  dateadd(ss,Entered_offset+offset2,'1980-03-01')as RealDate2,

 Sum(dcount) as test_count

from tbl_dummy1

Group by 

entered_offset,offset1,offset2

and don't create problems for yourself.

It's better to have proper database design.

If you don't know in which column to search for a value then you don't have a database, just some mess without any order.

It...

Can you explain in plain English the logic behind effectivedate and expirydate?

Yes. You may forget it's a view and treat it as a table.

The only thing you cannot do is modifying data in view.

View is precompiled set of joins.

You may use in your query any subset of column list from the view.

You may apply your parameters in WHERE clause. If there are appropriate indexes on...

If it's gonna be "SELECT with joins" you must put it into view.

View is much more effective and much more flexible.

Consider using a view instead of SP.

That's right.

Look at the data in DHB_service in both tables.

UPDATE Table1

SET Col1 = Col3, Col2 = Col4

FROM Table2

WHERE Table2.ColumnX="xx" AND Table1.columnY="yy"

Select ISNULL(T1.Date, T2.Date), ISNULL(T1.Biller, T2.Biller), ISNULL(T1.Amount, 0), ISNULL(T2.Lines, 0)

FROM Table1 T1

FULL OUTER JOIN Table2 T2 ON T1.Date = T2.Date and T1.Biller = T2.Biller

Raymond, what do you mean when you say "join"?

You can create a job scheduled for the next second which will delete itself after it's completed.

What are the datatypes of the clumns:

Trans_Header.CompanyID;

Trans_Header.Finyear;

Journal.JrlID=@JrlID

"Varchar" is not an answer.

Have you looked at your code???

SET @Counter = CHARINDEX('QUOTATION', @UserText) + 16

If there is no word 'QUOTATION' then CHARINDEX = 0,...

Vijay, you don't know what you are talking about.

Text field takes 16 bytes in every row.

Text itself is not stored in the table pages. There is only pointer to...