Using Cursors to Update Records in SQL Server
In SQL Server, cursors provide a powerful but often misused way to process records one at a time. While it’s generally recommended to use set-based...
How to Get Current Date Without Time in SQL Server
In SQL Server, retrieving the current date without the time component is a common requirement, especially when working with date-based operations or reporting. This blog...
How to Display Two Digits After Decimal Points in SQL Server
In SQL Server, you can use the FORMAT function or the CAST or CONVERT functions to display a specific number of digits after the decimal...
Unleashing the Power: Proven Tips to Supercharge Your MS SQL Server Query Performance
Introduction: In the realm of database management, the performance of your SQL Server queries can make or break your application’s responsiveness. Optimizing query performance is...
How To Run Query in One SQL Server from Another SQL Server
Introduction: In the interconnected world of databases, the ability to run a query on one SQL Server from another opens doors to seamless data manipulation...
Pivoting in MS SQL Server
SELECT * FROM ( SELECT p.product_name, g.tx_id, g.transmonth FROM [DataAnalytics].[dbo].[tbla_hst_gross_add_policy] g INNER JOIN [DataAnalytics].[dbo].[tbld_product] p ON g.product_code = p.product_code and transmonth>='202101' ) t PIVOT (...