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 ««1234»»»

Extract first numeric value from a string Expand / Collapse
Author
Message
Posted Monday, July 01, 2013 8:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 7:51 AM
Points: 141, Visits: 275
Sean, I hate to look stupid - but this is a quality not easy to hide ...
I was not able to use iTVF in my query ... alas ...
Post #1469081
Posted Monday, July 01, 2013 8:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:10 PM
Points: 2,763, Visits: 5,909
Please post your query and the problem you had so we can help you.


Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1469084
Posted Monday, July 01, 2013 8:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, April 17, 2014 9:33 AM
Points: 6,754, Visits: 12,854
valeryk2000 (7/1/2013)
Sean, I hate to look stupid - but this is a quality not easy to hide ...
I was not able to use iTVF in my query ... alas ...


I'm sure we can change that...


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1469085
Posted Monday, July 01, 2013 8:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 7:51 AM
Points: 141, Visits: 275
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!
Post #1469088
Posted Monday, July 01, 2013 8:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:24 PM
Points: 11,990, Visits: 11,007
valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


ROFL. Glad you got it working.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1469089
Posted Monday, July 01, 2013 8:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, April 17, 2014 9:33 AM
Points: 6,754, Visits: 12,854
Sean Lange (7/1/2013)
valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


ROFL. Glad you got it working.


valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


Limping!


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1469091
Posted Monday, July 01, 2013 10:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:24 PM
Points: 11,990, Visits: 11,007
ChrisM@Work (7/1/2013)
Sean Lange (7/1/2013)
valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


ROFL. Glad you got it working.


valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


Limping!


True dat!!!

The point we are making here is that 1:08 seems pretty slow for whatever you are doing unless the row count is in the millions.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1469139
Posted Monday, July 01, 2013 12:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 7:51 AM
Points: 141, Visits: 275
This table has about 9,000,000 recs.
However, when I added clustered index the time dropped to 0:32
Is it still limping?
Post #1469194
Posted Monday, July 01, 2013 12:47 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:24 PM
Points: 11,990, Visits: 11,007
valeryk2000 (7/1/2013)
This table has about 9,000,000 recs.
However, when I added clustered index the time dropped to 0:32
Is it still limping?


Depending on what your actual query looks like that doesn't sound horrible to select 9 million rows.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1469195
Posted Monday, July 01, 2013 12:50 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 7:51 AM
Points: 141, Visits: 275
Take me right: the result is 15,547 rows from 9 mln rows
Post #1469197
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse