Are you hosting any website?

There were somany suggestion to the question :). Which one you are planning to choose!!!

GSquared (4/9/2009)

SELECT

consultant_key,

fiscal_period_key,

sort_seq,

item_type,

item_desc,

item_id,

reservation_ind,

...

To trim the spaces on both the sides of the string we need to use LTRIM and RTRIM. Instead of we have one function from SQL Server to do both...

Hi can u post your SP source code and how are you calling this to get more insight on your process.

Hi

Check out the below link

http://support.microsoft.com/default.aspx/kb/306125

It looks like there is another thread on the same question:

http://www.sqlservercentral.com/Forums/Topic694194-338-1.aspx

Normally all this kind of Summing along with the details comes from Reports or Front-End application. If this is the case then it is best to do at those layers...

Hi

Append the below query:

union all

select null, null, null, null, count(*) from #temp

Select SocialSecurityNumber, ClearedDate, [Type], DDS, Count(*) As TotalCleared

from #temp

Group by SocialSecurityNumber, ClearedDate, [Type], DDS

Order BY ISNULL( ClearedDate, '31-Dec-2090')

You can have one Union All with the above query to count teh...

All the best....

This forum will always help to clarify your technical doubts or any concepts related questions.

Best Practicse is always have list of columns INSERT and SELECT statement to avoid any confusion when you are copying the data.

Check out the below link

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1063700_mem1,00.html

You Can even try out with "INSTEAD OF TRIGGER" to avoid anu updates/inserts thru views.

You can't cache a database..Caching is at the table level.

Check out the below link