2- I don't see a good way to organize the SQL code in SSMS in Separate folders (like HR Code, Finance Code, Etc..). I can certainly prefix the solution/project...

You have to be careful when using words like 'never'! In my opinion, there is nothing wrong with using SELECT *...

Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread. Thanks for creating...

If someone...

• This reply was modified 3 years, 4 months ago by Phil Parkin. Reason: Correct typo

Here is another attempt, this time with dynamic column names. As mentioned before, column names must be unique, so I added some suffixes to ensure this.

DECLARE @C0...

WHERE OrderDate >= DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0)
      AND OrderDate < DATEADD(DAY, 15, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0))

Thanks for your reply Phil, Someone suggested PIVOT would do this, so I was trying to figure out how to do that. While this would be the answer if...

Perhaps post a few specific questions in the SSIS forum. You need only a rudimentary knowledge of C# to achieve most of the things you'll need to use a Script...

Exporting to CSV may also solve the problem, because then you have full control over the target datatypes.

The following method is likely to be faster and easier to read than PIVOT:

(Note that column names must be unique)

SELECT PKGId = ct.PC_Pkg_Id
    ...

• This reply was modified 3 years, 4 months ago by Phil Parkin.
• This reply was modified 3 years, 4 months ago by Phil Parkin.
• This reply was modified 3 years, 4 months ago by Phil Parkin.

Try using exactly the same query as your source, but with none of the CONVERTs, and see what happens.

Sounds like you need to pay for a software licence.

So you are flipping the ones to zeros and vice versa?

DECLARE @SomeTable TABLE
(
    SomeId INT IDENTITY(1, 1) NOT NULL
   ,Sex TINYINT NOT...

• This reply was modified 3 years, 4 months ago by Phil Parkin.

You'll find very few cases in T-SQL where...

Did you follow the instructions here when attempting the library install?