| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Auto Serial Number with recordset | SQL Server 2000, SQL Server 7.0 | Intermediate /
Asif Shahzad | 13210 since
8/28/2004 11:24:46 AM |
By 2 Users
|
| |
It is very simple code to view an auto serial number with every recordset. this serial doestnot exist in actual table. I developed it when i felt need a serial number in Reports. I think, any time i will help u. Thank You. for any query u can ask.
|
| |
| |
| |
|
 Avoiding Cursors | SQL Server 2000 | Beginner /
Thivya Prabakaran | 7944 since
12/13/2003 3:11:29 AM |
By 2 Users
|
| |
Some times, in our query, we may use temporary tables and cursor's to get the required result. This implementation in some cases can be avoided using User Defined Functions. |
| |
| |
| |
|
Beginners pack | Oracle | Beginner /
infys systems | 8361 since
1/11/2004 2:11:55 AM |
By 8 Users
3 Excellent Ratings
|
| |
This zip file contains 30+ programs for beginners developed in PL-SQL.please rate it and vote for it if u found something usefull. |
| |
| |
| |
 |
 BuildListFromValues | SQL Server 2000 | Beginner /
TDK | 4793 since
4/19/2006 1:43:18 PM |
By 2 Users
|
| |
This simple SQL query builds a semicolon separated list of values from a table without using any temporary tables or cursors explicitly. |
| |
| |
| |
|
Calculate the statistical mode of a set of values | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 10283 since
8/11/2000 11:11:06 AM | Unrated
|
| |
How to calculate the statistical mode of a set of values using a SELECT statement |
| |
| |
| |
|
Calculating the Mode, Mean and Median of a dataset | SQL Server 7.0 | Intermediate /
James Travis | 9168 since
2/5/2002 8:09:56 PM |
By 7 Users
5 Excellent Ratings
|
| |
To get the mode, mean and median of a queired dataset. |
| |
| |
| |
|
Column Row Transposition without pivot | SQL Server 2000 | Intermediate /
Developer142 | 3650 since
7/3/2009 6:58:39 PM | Unrated
|
| |
Suppose I have a table like the following
Amount GLID
1 2
3 4
5 6
I need to write a query that will show this table like below
1ST_COLUMN 2ND_COLUMN 3RD_COLUMN
2 4 6
1 3 5 |
| |
| |
| |
|
Compare large ntext values. (this can't be done using = or like) | SQL Server 2000 | Advanced /
Keith Henry | 7022 since
6/27/2003 10:57:07 AM | Unrated
|
| |
There are two functions:
ConvertNtext2table turns a large unicode text value into a list of smaller strings.
CompareTexts takes two large unicode text values, converts them and compares them.
Using these to compare large text fields/variables, which you c ...(description truncated) |
| |
| |
| |
|
Compare rows in tables without writing a SELECT CASE | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 17301 since
7/27/2000 9:12:54 PM | Unrated
|
| |
How to compare rows in tables without writing a SELECT with all the conditions. Can be used for simple dirty work & of course if you are lazy to type. |
| |
| |
| |
|
Concatenate values that are grouped by columns using SELECT statement alone | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 10198 since
7/27/2000 9:19:56 PM | Unrated
|
| |
This method has several restrictions but serves to demonstrate some techniques. |
| |
