| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Age in years and months. | SQL Server 2000, Other | Advanced /
Dinesh Mishra | 3085 since
1/2/2013 2:30:45 PM | Unrated
|
| |
May a times were are faced with situation to find the age of person.
Below mentioned code finds the age of person in years and months.
|
| |
| |
| |
|
 Calculating Compounded Value | SQL Server 2000 | Advanced /
Dinesh Mishra | 1794 since
11/4/2011 4:34:30 PM | Unrated
|
| |
Code to calculate the compounded Value
===================================
Often we are faced with situations wherein we want to calculate the compounded value of an invested amount at some specific rate of interest per year for some specific number of ye ...(description truncated) (ScreenShot) |
| |
| |
| |
|
 Difference in 'Days' since last event.txt | SQL Server 2000 | Advanced /
Dinesh Mishra | 3883 since
8/3/2010 9:25:43 AM | Unrated
|
| |
This piece of code checks the difference in 'number of days' since the last event occured. |
| |
| |
| |
|
Factorial Calculator. | SQL Server 2000 | Intermediate /
Dinesh Mishra | 4805 since
6/11/2010 8:06:11 AM | Unrated
|
| |
For calculating Factorial. |
| |
| |
| |
|
KNOWING PHYSICAL AND LOGICAL CPU COUNT OF YOUR PC. | SQL Server 2000 | Advanced /
Dinesh Mishra | 9371 since
11/14/2011 2:26:44 PM | Unrated
|
| |
This piece of query in SQL SERVER 2005 just answers back the number of physical and logical cpu count of your computer. |
| |
| |
| |
|
No Of Seconds Elapsed Since Midnight | SQL Server 2000 | Advanced /
Dinesh Mishra | 4813 since
8/3/2010 9:25:57 AM | Unrated
|
| |
This piece of code checks the number of seconds elapsed since midnight.We are assuming that today is 31st july 2010 and number of seconds are counted from 00:00:00 of 31st July 2010 midnight. |
| |
| |
| |
|
Pivot Table Creation in SQL SERVER 2005. | SQL Server 2000 | Advanced /
Dinesh Mishra | 6096 since
7/25/2010 9:14:23 AM | Unrated
|
| |
Creation of Pivot always makes it easy to read data and make conclusions fast. It is one of strong points of Microsoft Excel Spreadsheet. It is easily understood by everyone and needed frequently in various scenarios. Eveb Sql Server 2005 is capable of cr ...(description truncated) |
| |
| |
| |
|
Reverse of String | SQL Server 2000 | Advanced /
Dinesh Mishra | 4291 since
8/3/2010 9:24:44 AM | Unrated
|
| |
The 'Reverse' function reverses the string for you. |
| |
| |
| |
|
Stored procedure to know vital SQL Server statistics | SQL Server 2000, Other | Advanced /
Dinesh Mishra | 1890 since
11/15/2012 1:42:59 PM | Unrated
|
| |
SP_Monitor:
SQL Server itself tracks how much and what work it has done through series of functions. Here is the stored procedure showing the same. The numbers are displayed in form number(number)-number%. The first number shows number of seconds since sq ...(description truncated) |
| |
| |
| |
|
Summarizing data type/propertywise with SQL. | SQL Server 2000, Other | Advanced /
Dinesh Mishra | 1602 since
6/4/2012 3:27:05 PM | Unrated
|
| |
Summary of records with 'WITH CUBE':
----------------------------------------------------------
We are always faced with situations wherein we have to summarize the data to be presented. Suppose you have item of different types and different colours and y ...(description truncated) |
| |
| |
| |
|
Time Taken In Milliseconds To Insert 1000 Records | SQL Server 2000 | Advanced /
Dinesh Mishra | 5083 since
8/3/2010 9:26:12 AM | Unrated
|
| |
This piece of code checks the number of milliseconds taken to insert say 1000 records in a table. This all happens in computer within a second which we cannot notice and hence I have calculated the time lag in seconds. It speaks for the power or SQL Serve ...(description truncated) |
| |
| |
| |
|
To know the version and edition of SQL SERVER 2005. | SQL Server 2000 | Advanced /
Dinesh Mishra | 7811 since
7/16/2011 9:07:06 AM | Unrated
|
| |
This article lets you know which version and which edition of SQL SERVER 2005 you are working on. |
| |
| |
| |
|
To Re-index all tables in a database | SQL Server 2000, Other | Advanced /
Dinesh Mishra | 5592 since
9/19/2010 8:32:56 PM | Unrated
|
| |
In SQL SERVER 2005 due to continuous inserts and deletes in a table the index of tables gets slow (it gets fragmented). So to keep up the performance of index ok one needs to reindex all the tables in the database periodically. Here is the simple way. You ...(description truncated) |
| |
| |
| |
|
Top Clause - Simplified | Other | Advanced /
Dinesh Mishra | 6708 since
8/1/2012 4:29:34 PM | Unrated
|
| |
Use of 'Top' Clause:
================
Many a times we are faced with situation wherein we want the say top 2 or top 5 of values in ascending or descending format from a table. An example of it is requirement from sales department wherein the top 2 sales i ...(description truncated) |
| |
(ScreenShot)
