Ira Warren Whiteside
May 22, 2012 at 1:08 pm
Comments posted to this topic are about the item Kimball ETL (subsystem 1) – Data Profiling via TSQL
[font="Comic Sans MS"]Ira Warren Whiteside[/font]
Say Hey Kid
June 11, 2012 at 5:08 am
Ok so this is cool to profile a column, but... 🙂
How could this be run/changed to return multiple rows for each column in a table?
June 11, 2012 at 5:13 am
Thanks for the comment, the script as is will do all multiple columns in a tables based on filter.
June 11, 2012 at 5:16 am
Sorry I should have noted the filters support wildcard, just put in a % character.
SET @columnname ='%'
June 11, 2012 at 5:21 am
I tried that and it didn't work.
I didn't expect it to work either as = '%' is not valid SQL, it would need to be LIKE '%' but that isn't valid in a SET statement.
Or am I missing something?
June 11, 2012 at 5:37 am
Sorry, too many scripts, you are right, send me an email firstname.lastname@example.org and I will send you the multi column version.
May 10, 2016 at 9:28 am
Thanks for the script.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply