Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Kimball ETL (subsystem 1) – Data Profiling via TSQL Expand / Collapse
Author
Message
Posted Tuesday, May 22, 2012 1:08 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Comments posted to this topic are about the item Kimball ETL (subsystem 1) – Data Profiling via TSQL

Ira Warren Whiteside
Post #1304439
Posted Monday, June 11, 2012 5:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 25, 2014 10:08 AM
Points: 34, Visits: 186
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?

~ UKGav
Post #1313776
Posted Monday, June 11, 2012 5:13 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Thanks for the comment, the script as is will do all multiple columns in a tables based on filter.

Ira Warren Whiteside
Post #1313778
Posted Monday, June 11, 2012 5:16 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Sorry I should have noted the filters support wildcard, just put in a % character.

SET @columnname ='%'


Ira Warren Whiteside
Post #1313780
Posted Monday, June 11, 2012 5:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 25, 2014 10:08 AM
Points: 34, Visits: 186
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?

- UKGav
Post #1313784
Posted Monday, June 11, 2012 5:37 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Sorry, too many scripts, you are right, send me an email iwhiteside@iwhiteside.com and I will send you the multi column version.

Ira Warren Whiteside
Post #1313792
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse