Your above explanation is totally unclear. Before anybody...

I agree with Chris. There is no need for dynamic sql for this at all. In fact, you should run away from the implementation you put together quickly. It is...

No offense harri but how do you...

sql1411 (8/30/2012)

---

Thanks for trying to answer my queries. To Seans' questions...

You have two rows here and one of them is the OriginalAircraftNumber and one becomes the FinalAircraftNumber. What can you...

XMLSQLNinja (8/30/2012)

---

Based on your sample data and DLL this should work:

SELECTFlightDate,

FlightNumber,

ScheduleOrder,

MIN(AircraftNumber) OriginalAircraftNumber,

MAX(AircraftNumber) FinalAircraftNumber,

ChangeOfAircraftIndicator=

CASE

WHEN COUNT(ScheduleOrder)=1 THEN 'N' ELSE 'Y'

END

FROM [dbo].[DailySchedule]

GROUP BY FlightDate, FlightNumber, ScheduleOrder

ORDER BY FlightDate, FlightNumber, ScheduleOrder

This...

christina.honnert (8/30/2012)

---

Awesome - thank you! I did an 'open with Excel' and I can view it much better than a text file. I'll see if this will work for...

christina.honnert (8/30/2012)

---

Sorry I had no clue how that worked. OK, that did create a file. Is there a way to change the default file format? It saves...

david.holley (8/30/2012)

---

So basically a single transaction and then check @@Error after each statement as in...

BEGIN TRAN

UPDATE

IF @@ERROR <> 0 GOTO ERR_HANDLER

DELETE

IF @@ERROR <> 0 GOTO ERR_HANDLER

DESTROY WORLD

IF @@ERROR <> 0...

Did you run your query after changing that setting? It does not just save what is currently...

To add to what Gail is saying not only do they not really exist the appearance of nested transactions can seem to work when everything goes smoothly but will cause...

christina.honnert (8/30/2012)

---

I have a very complicated SQL statement that creates 3 separate groups of results for Hospital Meaningful Use Attestation.

1. Summarized Data

2. Detailed Data

3. Link...

nice job posting ddl and sample data in a readily consumable format. It make a lot of difference for those of us willing to work on your issue. I think...

Jo Pattyn (8/29/2012)

---

How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?

*edit* Not an...

You are not too likely to find a lot of Oracle people around here since this is sql server forum. Even if you do, they will ask you for the...

suman.mullapudi (8/29/2012)

---

Hi All,

I need to export some data from SQL Server (2008 R2) table to a text file. There are a few datatime data type columns in the sql table.

Here's...