<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Ira Whiteside
»
Kimball ETL (subsystem 1) – Data Profiling...
Kimball ETL (subsystem 1) – Data Profiling via TSQL
Rate Topic
Display Mode
Topic Options
Author
Message
Ira Warren Whiteside
Ira Warren Whiteside
Posted Tuesday, May 22, 2012 1:08 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42,
Visits: 272
Comments posted to this topic are about the item
Kimball ETL (subsystem 1) – Data Profiling via TSQL
Ira Warren Whiteside
Post #1304439
UKGav
UKGav
Posted Monday, June 11, 2012 5:08 AM
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:54 AM
Points: 34,
Visits: 151
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
Ira Warren Whiteside
Ira Warren Whiteside
Posted Monday, June 11, 2012 5:13 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42,
Visits: 272
Thanks for the comment, the script as is will do all multiple columns in a tables based on filter.
Ira Warren Whiteside
Post #1313778
Ira Warren Whiteside
Ira Warren Whiteside
Posted Monday, June 11, 2012 5:16 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42,
Visits: 272
Sorry I should have noted the filters support wildcard, just put in a % character.
SET @columnname ='%'
Ira Warren Whiteside
Post #1313780
UKGav
UKGav
Posted Monday, June 11, 2012 5:21 AM
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:54 AM
Points: 34,
Visits: 151
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
Ira Warren Whiteside
Ira Warren Whiteside
Posted Monday, June 11, 2012 5:37 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42,
Visits: 272
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
