You're welcome. Glad that worked for you.

jbalbo (5/28/2014)

---

Hi

trying to add a case statement to below so when enddate is null then use getdate()

Thanks

Joe

DECLARE @startdate datetime2 = '2007-05-05 12:10:09.3312722';

DECLARE @enddate datetime2 = '2009-05-04 12:10:09.3312722';

SELECT DATEDIFF(day,...

josetur12 (5/28/2014)

---

Hi this is my DDL

DROP TABLE [dbo].[Order]

GO

CREATE TABLE [dbo].[Order](

[OrderID] [int] NOT NULL)

Insert into [dbo].[Order]

(OrderID)

SELECT 100 UNION ALL

SELECT 101 UNION ALL

SELECT 102

DROP TABLE [dbo].[OrderDetail]

GO

CREATE TABLE [dbo].[OrderDetail](

[OrderID] [int] NOT...

Any chance you can turn that into insert statements? Also, need at least a row or two for Orders (that is in your select statement ). 😀

I am still rather...

Marriage

Is there an echo in...

How about the Order table and a few rows of sample data? I think I see where you are trying to go but want to be sure and with tables...

MMartin1 (5/28/2014)

---

You could try

WITH Ordered AS

(

SELECT*, ROW_NUMBER() OVER ( PARTITION BY name ORDER BY Id) AS RN

FROM #mytable where ID

in ('TIX123','TIX999')

)

select * from ordered

where RN=1

to move the...

jamie 35248 (5/28/2014)

---

I want to insert many rows at a time into two tables - I have a ValidationMessage Table with the ValidationMessageID and the message, and then an OrderValidationMessages...

sqlnaive (5/28/2014)

---

Thanks Jeff. I compared the two execution plans and saw that with where clause it was considering clustered index scan for one of the table while without where clause...

One other point of concern. I noticed you are using the REAL datatype. This is not an exact numeric type, it is an approximate datatype so if accuracy is important...

mrmnew (5/28/2014)

---

I am needing to get average and total downtime hours from a table. I have two source tables, DOWN (records with recorded downtime hours) and PROD (records with production...

prepaess (5/28/2014)

---

Hi Sean Lange thanks for replying

in fact i am too pressed i should finish this part now 🙁

as i modified above it is the date of buying the...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Remove the other select statements?