It would help if you would post the DDL for the table, some sample data for the table, and the expected results based on the sample data.

Please remember that we...

Try this:

create table #Appointment (AppStartDate datetime, AppEndDate datetime);

insert into #Appointment values('1/1/2014 8:30am', '1/1/2014 9:45 am');

select

*,

datediff(minute,AppStartDate,AppEndDate) / 60 hrs,

datediff(minute,AppStartDate,AppEndDate) % 60 mins

from #Appointment;

drop table #Appointment;

Steve Jones - SSC Editor (4/11/2014)

---

You guys are killing me.

This forum isn't for general questions or discussion. It's a call for articles. If you want to write one, please feel...

One thing to note. If you had a server running SQL Server 2012 with SSIS also running, the SSIS packages running on that server can use SQL Server 2008...

Koen Verbeeck (4/11/2014)

---

Some very nice words about some thread people and these forums in general:

http://www.sqlservercentral.com/Forums/Topic1553867-364-1.aspx (at the end of the thread)

The highlight:

In general this board is the most friendly and...

aaron.reese (4/10/2014)

---

+1 from me

Phil, Gail and Koen are some of the most generous and helpful forum members on any board I visit and their opinions and advice have saved...

A guess, they couldn't get the delete of parent data to work even with a trigger in place while the FK constraints were in place. The fix, disable the...

daniel.miller 82924 (4/10/2014)

---

Lynn,

ya, i've seen that, but it doesn't help me understand how the sql log tells me it is...

Hyperthreading does not count toward the count of cores.

To incorporate the code from twin.devil, this is what I wrote:

CREATE TABLE [dbo].[Luke_PS2](

[Ward or Team Name] [nvarchar](255) NULL,

[Date] [datetime] NULL,

[Setting] [nvarchar](255) NULL,

[Service] [nvarchar](255) NULL,

[Updated] [datetime] NULL,

[Count] [float] NULL,

[Audit 1] [nvarchar](255)...

No, no problem with the parallelism. There is a problem with using a cursor. From a quick look at the code all of this could be converted to...

Try this:

DECLARE @period VARCHAR(10)

SET @period = 'current'

select * from t_rbt_data

where

dt >= '2014-01-01' and

dt < '2014-04-01' -- this ensures you get all records...

jhager (4/10/2014)

---

Hi all,

I need to find a (reasonably) simple way to get the lowest value from multiple columns along with several other columns for each row; something like this (virtually;...

Nita Reddy (4/10/2014)

---

I have first column as char and 2nd column as date please see if I am doing right or wrong I am getting conversion string error :Conversion failed...

Jeff Moden (4/9/2014)

---

allaspects (4/9/2014)

---

Lynn is obviously trolling. Sad that on a resource such as this website, someone is out to troll and not help.

That's why the world can't have nice...