Eirikur Eiriksson (12/5/2016)

---

BOR15K (12/5/2016)

---

I have a table of several millions of records for flight ticket. One of the indices is Flight Ticket, so when user searches for ticket 1234567 or...

Well done. I compared execution plans and my version seems to have the edge. Especially if you add an index on (requestid, eventdate, eventname). Might be worth testing both on...

I have an inelegant solution to this inelegant problem 🙂 There will be better ways, but this seems to work, at least for the test data provided:

SELECT

...

If a RequestId has been 'Closed', shouldn't the next RequestId have a different value? If they're all 46444, what's the point of this number?

Please post your data in a consumable...

OK. So you want SSIS to 'interrogate' a particular file, which has already been produced by another process, get the row count and then act according to result?

If so, your...

You have more than one problem going on here. One is regarding access to an Excel spreadsheet...

kpmandani (12/2/2016)

---

I want to send a csv file using SQL Server only when it has more than 1 record present in it. Daily this file is getting cleared and updated...

drew.allen (12/2/2016)

---

Phil Parkin (12/2/2016)

---

Just having a mind warp on how to insert into the address table and get that unique int value and put it into the correct master row...

This...

You need to return inv.Active to the outer query, if you need it there.

SELECT

StationName

, AiredDateTime

, AiredISCI

, OrderNumber

, Line

,...

This question is clearly puzzling us all. Can I suggest that you create a 'dumbed-down' version, exemplifying the issue in consumable code, which we can run for ourselves? I think...

On which table is the column 'Active'?

For readability, please use IFCode formatting in future. Here is that code again:

SELECT

StationName

, AiredDateTime

, AiredISCI

, OrderNumber

, Line

, ...

What versions of SQL Server are you migrating from/to?

r5d4 (11/25/2016)

---

I’m running SSMS 2016 on the server itself via RDP.

When I open a script from the solution explorer or script a table as a SELECT, the query window opens...