<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
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tag
Advanced Querying
Refine your search with one of the following additional tags (with number of items):
T-SQL
(11)
tally
(8)
String Manipulation
(5)
Extract, Transform, Load (ETL)
(1)
Development
(8)
T-SQL Aids
(8)
Miscellaneous
(4)
games
(1)
nums
(8)
counter
(7)
SQL Server 7, 2000
(4)
prime
(1)
SQL Server 2005
(8)
Arrays
(5)
2-Dimensional Arrays
(2)
prime number
(1)
SQLInsider Scripts
(8)
Delimited Strings
(5)
Table
(2)
Puzzle
(1)
Table of Numbers
(8)
parse
(5)
Common Table Expression (CTE)
(1)
sieve
(1)
Search for
any
content tagged
Advanced Querying
Add a script
Items 1 to 11 of 11
Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)
Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.
Read more...
By
Jesse Roberge
2009/07/15
|
Source:
SQLServerCentral.com
|
Category:
Advanced Querying
Rating:
|
Discuss
|
Briefcase
|
833 reads
Comparing Stored Procedures, Part 6
Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
Read more...
By
Jesse McLain
2009/04/15
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,027 reads
Delimited String Parsing Functions - TwoCol set
Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.
Read more...
By
Jesse Roberge
2008/11/03
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
1,758 reads
Delimited String Parsing Functions - Big2D set
Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.
Read more...
By
Jesse Roberge
2008/10/22
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
831 reads
Delimited String Parsing Functions - 2D set
Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.
Read more...
By
Jesse Roberge
2008/10/14
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
869 reads
Delimited String Parsing Functions - Big Set
Feed it large strings of delimited horizontal data and it returns it back as a vertical table.
Read more...
By
Jesse Roberge
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
642 reads
Delimited String Parsing Functions - Basic Set
Feed it delimited horizontal data and it returns it back as a vertical table.
Read more...
By
Jesse Roberge
2008/10/20
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
2,091 reads
Counter Table (table of numbers) Setter-Upper for SQL Server 2005
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.
Read more...
By
Jesse Roberge
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
702 reads
Counter Table (table of numbers) Setter-Upper for SQL Server 2000
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.
Read more...
By
Jesse Roberge
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
357 reads
A Sudoku solution with set based T-SQL utilizing binary operators.
A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.
Read more...
By
Kevin Duan
2008/06/09
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
2,287 reads
Identify Unique Columns
Tool to automatically query combinations of columns in your table to determine candidate for unique key.
Read more...
By
Jesse McLain
2008/04/16
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
798 reads
Items 1 to 11 of 11
Most popular
A Sudoku solution with set based T-SQL utilizing binary operators.
A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.
Read more...
By
Kevin Duan
2008/06/09
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
2,287 reads
Delimited String Parsing Functions - Big Set
Feed it large strings of delimited horizontal data and it returns it back as a vertical table.
Read more...
By
Jesse Roberge
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
642 reads
Comparing Stored Procedures, Part 6
Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
Read more...
By
Jesse McLain
2009/04/15
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,027 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
