ASPSnippets: Questions

BugHunte...

Query to update entire Column in SQL Server

snehalp

Calculate Date difference in Days and Hours in SQL Server

smile

Show Hide Column using dynamic Pivot query in SQL Server

PRA

Eliminate duplicate Rows in Select statement in SQL Server

PRA

Query to select multiple columns based on CASE statement in SQL Server

smile

Query to combine multiple Select statements into single result set in SQL Server

smile

Calculate student Grade based on Mark in SQL Server

smile

Query to find Max and Min value from database Table in SQL Server

chetan

Case statement with multiple conditions in SQL Server

PRA

Select MAX value for each Group in SQL Server

satabeac...

Implement First Expiry First Out (FEFO) in SQL Server

smile

Calculate SUM and Total count of each Group in SQL Server

PRA

Query to add Year to DateTime in SQL Server

ashraft1

Filter Multiple Columns based on multiple search criteria in SQL Server

SUJAYS

Swap two Column values of two tables in SQL Server

anirudhp

Encrypt Stored Procedures in SQL Server

smile

Get Day Name along with Date in dynamic Pivot Query in SQL Server

skp

Stored Procedure to return record based on parameters in SQL Server

irshad12...

Stored Procedure to return record from multiple Database Table in SQL Server

iammann

Query to get all records of Previous Month from specified Date in SQL Server

Questions

Query to update entire Column in SQL Server

Calculate Date difference in Days and Hours in SQL Server

Show Hide Column using dynamic Pivot query in SQL Server

Eliminate duplicate Rows in Select statement in SQL Server

Query to select multiple columns based on CASE statement in SQL Server

Query to combine multiple Select statements into single result set in SQL Server

Calculate student Grade based on Mark in SQL Server

Query to find Max and Min value from database Table in SQL Server

Case statement with multiple conditions in SQL Server

Select MAX value for each Group in SQL Server

Implement First Expiry First Out (FEFO) in SQL Server

Calculate SUM and Total count of each Group in SQL Server

Query to add Year to DateTime in SQL Server

Filter Multiple Columns based on multiple search criteria in SQL Server

Swap two Column values of two tables in SQL Server

Encrypt Stored Procedures in SQL Server

Get Day Name along with Date in dynamic Pivot Query in SQL Server

Stored Procedure to return record based on parameters in SQL Server

Stored Procedure to return record from multiple Database Table in SQL Server

Query to get all records of Previous Month from specified Date in SQL Server