Ron Kunce (3/5/2015)

---

I am fairly new to SSIS and don't know a whole lot about it. I have been trying to follow an article on using SQL Server 2012...

Can you post what you would want the query output to look like?

To me. your 'Tuesday or Friday' thing is a bit unclear. I mean, you could say,...

Short answer, yes its possible.

But to actually do it we'd probably need a detailed example. Ideally DDL for the affected tables, some sample data and expected output.

Your outer...

The CHARINDEX gives you a 0 if there is no --

When you use 0 as the start position for substring it messes it up. Here is the MSDN page...

Thanks!

Started doing it with a CTE for the max(case) and then it just occurred to me that I really didn't need it to be in a CTE just to apply...

For starters:

SELECT PERSID,

CASE MAX(CASE DUESTATUS

WHEN 'Overdue' THEN 2

WHEN 'DUE' THEN 1

ELSE 0

END)

WHEN 2 THEN 'Overdue'

WHEN 1 THEN 'Due'

ELSE 'Unknown'

END DUESTATUS,

CASE MAX(CASE COMPSTATUS

WHEN...

Being that you only want to give us 7 sample rows, maybe just copy and paste the insert statement for us together?

We can keep playing null detective instead, but if...

yep, my bad, forgot the quotes.

Try

SELECT 'SELECT '

+ COALESCE(QUOTENAME(user_name,''''),NULL)+','

+ COALESCE(QUOTENAME(date_of_change,''''),NULL)+','

+ COALESCE(QUOTENAME(time_of_change,''''),NULL)+','

+...

I'm glad it worked for you.

Ok, so lets add in a condition to ignore the last 5 columns. If these are always the last 5 it should work.

DECLARE @Query nvarchar(max),

@tablename nvarchar(50)=N'Rheumatology'

;

-- First we build...

Does this mean that these will be the last five columns in every table always, or just this table always?

The problem is here:

[Composite Score Eligible ] [nvarchar](255) NULL,

[Composite Score] [nvarchar](255) NULL,

[Composite Score PGS Percentage] [nvarchar](255) NULL,

[coremeasure] [bit] NULL,

[pediatric] [bit] NULL

These 5 fields at the end do not fit the...

Lol, ignore the enough for 12 years. Instead of retyping the inline tally code, I stole it from another solution (one of Luis')

Missed that comment and left it in.

Please do...

This is one of many problems you can solve pretty easily with a calendar table.

You can read about them here[/url].

I will use Dwain's generate calendar function for my sample solution...