DESCRIPTION:This procedure will allow you to display results vertically (down) instead of across the screen. It's great when you are dealing with a query that has 50 columns and just a couple of records. LIMITATIONS: * It will be very slow if you are trying to return a lot of records. Works best for queries […]
2007-05-23 (first published: 2007-05-19)
2,852 reads
DESCRIPTION:This procedure produces a SELECT statement which explicitly lists all fields for 'tablename' with fieldname and alias as the column name. The SELECT it produces is ready to run or if you need to join several tables just copy the column names off the SELECT it generates. I use this a lot when I create […]
2007-05-22 (first published: 2007-05-19)
173 reads
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Hello, I'm trying to remove results from this sql statement where the custid like...
Hi friends. how can i fix that? ;with cte as (select distinct(e.Id ) from...
Hello everyone, First of all, thank you very much for this great community. I...
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers