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

You can't "fix" that with properties. You have to fix the underlying tables. Either make the source smaller...

I believe the article from Jeff Moden http://www.sqlservercentral.com/articles/T-SQL/71550/%5B/url%5D is exactly what you are looking for.

harri.reddy (8/29/2012)

---

guys,

i want to know when i place my cursor over , OLEDB destination, there is an error symbol.

and the message is "truncate may occur due to column ."

how can...

Actually I don't think your works Luis.

I added some more data and it doesn't do what the OP asked for originally.

;with MyRank (col1)

as

(

select 6 union all

select 5 union all

select 5...