Cannot consider bit to be an integer datatype, more like a flag, kind of "fingers or no fingers" instead of "how many fingers".

😎

DECLARE @FIRST_BIT BIT = 1;

DECLARE @NEXT_BIT ...

Almost there, just missing...

First a quick question, why the dirty read (READ UNCOMMITTED)?

Without more information such as execution plans, view code, schema structure etc., it is hard to tell what the problem is.

😎

Thank you for this William, very useful!

😎

Take a look at this article, Script to create dynamic PIVOT queries in SQL Server[/url]. It should have what you need.

😎

Good question, thanks!

Did think a bit for a second:-D

Very good, thanks!

😎

I ponder on these things every day, WYPIWYG (what you pay is what you get), ROI, TCO.....and far too often the cheap option is the first option. Cutting corners to...

Good question, thanks!

Made me think a bit 😀

ScottPletcher (5/5/2014)

---

I would never use a table variable for this -- if something goes wrong after the DELETEs, but before the output has been processed, the data is gone, with...

I´m not certain that you are on the right track here with the Execute SQL Task, it has no means of accessing the Excel spreadsheet other than OPENROWSET or such....

Further on what Koen said, you will have to test explicitly for the existence of the config file, common method is to have a variable with lets say 0 value...

Good stuff!

IIF is supported in Sql Server 2012 and later, my guess to aid portability from Access:-D

Good luck

😎

Around here you only need to speak some SQL, post some example data and we will help you!

😎

jdasilva (5/5/2014)

---

Hello all,

I've played around with Access and SQL statements for some time, not a master by any means, but the data I am storing has gotten to the point...