Having supported a COBOL application for over 10 years, COBOL is a good language. Yes, it is wordy compared to modern programming languages, but that doesn't mean...

Having supported a COBOL application for over 10 years, COBOL is a good language. Yes, it is wordy compared to modern programming languages, but that doesn't mean it isn't...

Okay you and I will have to agree to disagree on this one. Not that...

Well, Phil Parkin just because a word does not currently exist within any known dictionary does not mean it is not a viable word. In fact, Shakespeare is...

Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:

• <b>....</b>

...

Are you running the install as an administrator?

The error is to do with permissions to write to the registry.

That sounds about right.  The number...

Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:

• Indexing: Proper...

Okay I know enough about Python to know that it is not nearly as fast to use as straight C especially if you are doing it in MS Windows...

SQL would be my first choice for cleaning data, while it's a powerful tool for querying and cleaning data, it may not be the best choice for performing complex language...

Look at the error message: It...

drop table if exists #temp1;
go
SELECT * INTO #temp1
FROM(SELECT  ProductID,Product, SUM(Amount ) AS TotalAmount,CONCAT_WS('__', IssueName,IssueID)[Issue]
FROM aaa_tempSalesData1
GROUP BY ProductID,Product,IssueName,IssueID) temp
PIVOT( SUM(totalAmount) 
FOR [Issue]
IN...

Hi Jonathan AC Roberts and Phil Parkin,

Thanks for your reply but if i create 2 temp tables how to join in query as there is no column mapping columns...

You could create two temporary tables with fewer columns instead of one table, then just join them in a query or view.