Declare @Results Table (ProductName varchar(50) primary key, TotalPaidAmount decimal(22,2), TransactionCount int, Customers int)

INSERT INTO @Results

SELECT ProductName, SUM(paid_amount) AS TotalPaidAmount, count(*) as TransactionCount, distinct(customer_ID) as Customers

FROM transactions tr1

WHERE date_of_sale >= '2010-01-01'...

To import your file into a table:

From SSMS, make sure you have the object explorer open and your database name displayed on the left hand side.

Right click on...

First things first. You need to get your file of numbers into SQL. If there are a huge number of them, they will need...

Ninja is wise.

With a calendar table you can also do things like add columns for each country you might be working with, so you can define...

Although I feel certain this comes too late, I feel...

You might also look at full-text searches and full-text indexing.

Define a CTE for the PUMA table which eliminates rows containing any characters other than 0-9. Then join to that CTE as shown below. ...

Try this:

select *

from Masada...

Jason,

Although we often use hate language when we joke about cursors, blind hatred is not our motivation. The simple fact is they are far too often used...

I wouldn't expect padding to add two seconds unless millions of rows were involved.

Could you possibly publish the actual code you are running, the schema of the tables, and the...

WHILE loops are not necessarily faster than cursors and in fact may be slower than some cursors.

The problem with both WHILE loops and cursors is that they retrieve...

I may have to set up a test tonight. I'm curious about how the sorts play out as the volume ramps up.

Yes, it does.

Please do check again ... I changed my data slightly and am seeing unexpected results with the new WHERE clause. But you are definitely on the right...

Paul, I tried your code against the data from my example and no rows were returned. I think the proper WHERE clause should be

WHERE...