Jeff Moden (11/13/2015)

---

Sean Lange (11/13/2015)

---

Ed Wagner (11/13/2015)

---

Sean Lange (11/13/2015)

---

Instead of a PIVOT I would recommend using a crosstab. The syntax is far less obtuse to me and it even has...

sqlizer (11/13/2015)

---

I did remove try/squelch block, and I did catch "C:/Linesheet/" error to. But Now I'm getting conversion error. First StyleID is "01511 bubble dress.JPG".

Here's the error:

Msg 102, Level 15,...

Ed Wagner (11/13/2015)

---

Sean Lange (11/13/2015)

---

Instead of a PIVOT I would recommend using a crosstab. The syntax is far less obtuse to me and it even has a slight performance benefit...

Ed Wagner (11/13/2015)

---

Eirikur Eiriksson (11/13/2015)

---

Sean Lange (11/13/2015)

---

Eirikur Eiriksson (11/13/2015)

---

Sean Lange (11/13/2015)

---

I will disagree slightly with Eirikur here. The values in ROW_NUMBER will always be the same but the order of...

drew.allen (11/13/2015)

---

You're executing your sql command in a TRY/CATCH block, but you're discarding any errors that you receive. How do you expect to troubleshoot your code if you're discarding all...

Eirikur Eiriksson (11/13/2015)

---

Sean Lange (11/13/2015)

---

I will disagree slightly with Eirikur here. The values in ROW_NUMBER will always be the same but the order of rows in the select statement are...

Eirikur Eiriksson (11/13/2015)

---

Sean Lange (11/13/2015)

---

TomThomson (11/13/2015)

---

Jack Corbett (11/12/2015)

---

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function,...

I will disagree slightly with Eirikur here. The values in ROW_NUMBER will always be the same but the order of rows in the select statement are not guaranteed to be...

Instead of a PIVOT I would recommend using a crosstab. The syntax is far less obtuse to me and it even has a slight performance benefit over PIVOT. You can...

TomThomson (11/13/2015)

---

Jack Corbett (11/12/2015)

---

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function, use the same table...

caojunhe24 (11/12/2015)

---

I have one script task at top of the package to check if there are any excel file exist in two different folders . If no file exist i...

Jack Corbett (11/12/2015)

---

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function, use the same table aliases...

caojunhe24 (11/12/2015)

---

I using below code to check if the excel file is opened or not

public void Main()

{

Boolean mFileLocked = true;

while (mFileLocked)

...

Nice question Steve. I knew the answer without thinking about it and realized as the button was being clicked I had the wrong one selected.

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function, use the same table aliases over and over, don't format the...