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...

Agreed that the formatting was a bit challenging but a great question. Thanks Lynn!!!

villanueva.jonel (6/5/2012)

---

Thank you guys for the reply.

I have to clear my requirements.

I want to pullout records based on date and time(hour).

In my samples i have date range from 2012/06/04 and...

Tripz (6/5/2012)

---

Hi,

I removed all the 3 functions and updated the query accordingly and executed it. it is taking 10 sec to execute now.

Thank you for all the help

I am trying...

My buddies and I have tickets to the Victory Suite for tonight's Open Cup match at Livestrong Park. The Victory Suite is usually reserved for cancer survivors (and thankfully their...