Sounds to me like global temp tables is not the best approach here. How do you handle multiple users getting different reports at the same time?

To directly answer your question,...

Looking at this again I suspect the OP is doing pass through queries from...

Hi and welcome to SSC! Your post does not have anywhere near enough information for anybody to help. From your description it sounds like you should look at MERGE. http://msdn.microsoft.com/en-us/library/bb510625.aspx

If...

AndrewSQLDBA (6/7/2012)

---

I did find that changing the Windows tooltip color, that is changes the background color of any NULL value in SSMS. A long way around, but I am using...

You can just use simple math to achieve this.

create table #Date(Id int, start_time datetime, End_time datetime)--, time_diff

insert #Date

select 16496, '2012-05-19 06:01:36.767', '2012-05-19 06:01:36.783' union all

select 18496, '2012-05-19 06:01:36.767', '2012-05-21...

What Lynn is saying is that what you posted is not readily consumable (and it is also not insert statements).

The format for this should be something like:

INSERT STG_CAP_HLI

select 'CHJUSDDN', 'App',...

What you are describing is certainly possible. However from what you posted the details are pretty elusive. Can you post some ddl (create table scripts), sample data (insert statements) and...

If you dig around a bit on google you will quickly find that this is the color of your windows tooltip. From the 2 minutes googling it seems that this...

I would suggest that you clean up you joins. You are using the mix of the old style and new style joins.

FROM student

,student_enrollment

,enrollment

LEFT JOIN branch ON enrollment.branch_id = branch.branch_id

LEFT JOIN...

Please don't cross post. It just fragments replies. You will get better answers in a single thread. Please direct all replies to the first one here. http://www.sqlservercentral.com/Forums/Topic1312260-392-1.aspx

balaji.k.ramanar (6/6/2012)

---

i am concatenating the string , date with arabic column

but string and arabic not concatenating

through the below qry

/******************

select convert(nchar,Subject_Name_English,160)+nchar(8207) +

+ convert(nvarchar,Subject_Name_Arabic,160) collate SQL_Latin1_General_CP1_CI_AS

+(Subject_Previous_Name_English) +

(Subject_Previous_Name_Arabic) +

convert(nvarchar,rtrim(ltrim(convert(nvarchar,Subject_Date_of_Registration,101))),130)

as...

Well indexes do not use CPU.

By memory I assume you mean physical storage space? You can...

What defines "Most Costly"?

Even in Access you can't use reserved words. You seem to be short cutting a lot or best practices here. Column names like ID. You should at the very least...

irumman (6/6/2012)

---

I have a database of 50 GB running on quad-core dual processor with 32 GB RAM. The application is running very slow here.

I backed up the database and restore...