This example demonstrates how to perform a pivot using dynamic headers based on the row values of a table. The article also shows how to pass a temp table variable to a Dynamic SQL call.
2017-08-04 (first published: 2015-10-22)
13,179 reads
Knowing the various types of joins can greatly expand your T-SQL skills. Jambu Krishnamurthy brings us a refresher article on the various types of joins and how to write them.
2008-03-26 (first published: 2007-04-24)
19,121 reads
Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.
2008-03-25 (first published: 2007-04-12)
9,932 reads
SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server
2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment.
2008-02-08 (first published: 2007-03-22)
17,635 reads
While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.
2007-12-14 (first published: 2006-12-19)
9,311 reads
Using data modeling tools should be something that all SQL Server DBAs involved in development use, but most of us cannot afford the tools or have the expertise to use them. Jambu Krishnamurthy brings us a new article that shows how you can use Erwin to work with your data model.
2007-12-06 (first published: 2006-12-12)
13,280 reads
New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000.
2006-11-21
16,936 reads
Gathering performance data on your servers can be a cumbersome task without paying for an expensive tool. New author Jambu Krishnamurthy brings us a short tutorial on how you can gather this data from Perfmon and import it into SQL Server for reporting.
2006-10-30
11,321 reads
In this article I will try to justify why Table variables are superior to temporary tables.
2006-10-10
1,048 reads
A table Users contains a Create date column.A table AccessLog contains StartTime column.Both are date time fields.Users table contains one row per user and AccesLog contains as many rows as the number oftimes the user Logged into the system.The requirement is:to produce a single table that has two different COUNTs... one column will have the […]
2005-10-06 (first published: 2005-09-16)
1,562 reads
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
By Steve Jones
As I use containers more and more to run various things, I decided I...
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
I maintain an application written years ago, where the database is on a Windows...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Comments posted to this topic are about the item The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers