My guess is that in reality it's the fact that you have a window function that sums transaction_amount that the engine is barking about. Mixing a group by and a...

What's the relationship between the two tables? Are they to be joined, and if yes, on which columns?

@ Michael L John:

Agreed, I like a typed table valued parameter for passing a set of rows to a stored procedure or between a stored procedure and a table function,...

• This reply was modified 2 years, 7 months ago by kaj.

@Ant-Green: There seems to be a mis-match between the row values and the column definitions of the table variable. You have two integers that doesn't match up with the row...

I don't think you can use VALUES quite like that.

This should work:

WITH ctevalues (recp_name, ing_name, qty) AS (
    SELECT v.*
    FROM...

Ant-Green is correct, something is not right.

Are you connected to the correct server? Have you selected the correct database, before firing off the statement? I see no USE statement at...

• This reply was modified 2 years, 7 months ago by kaj. Reason: elaboration

Well, the cast2.png says it clearly. The column name is not found in the Transactions table/view.

So now you have to find out what the column you stated as being named...

• This reply was modified 2 years, 7 months ago by kaj. Reason: typo

You miss a comma after the CONVERT/CAST line - and you still need to change the GROUP BY.

or instead use the ANSI style CAST:

CAST(TransactionDate AS DATE)

I know that some SQL databases support a DATE function, but SQL Server doesn't. You have to use CAST or CONVERT instead.

BTW, there isn't really a need for the outer DATEADD in Scott's query, since you only need to count the distinct number of months since 1900-01-01, which is what the...

• This reply was modified 2 years, 7 months ago by kaj. Reason: "provides" became "returns"

As alternatives to the DATEADD DATEDIFF formula, you can also use the new DATETRUNC function

COUNT(DISTINCT DATETRUNC(Month, UCLogTimeStamp))

or the old conversion to a fixed-lenght char type (ISO style yyyy-mm)

COUNT(DISTINCT CAST(UCLogTimeStamp AS...

Yeah, Excel files can be a lot of fun/pain, because an Excel sheet is essentially a bunch of Variant type cells. That makes mapping them into "normal" sql data types...

Please see my DDL.

I would like to create:

a) Dimensional table that tracks Primary Accounts’ group movements. An account moves to different groups that are associated with levels of commission paid....

Hi Team,

I have a requirement to track any insert/update/Delete operations happened against Database table by any user, catch those changes and send alert.

Please note that there are around 1000+...

This is not a reseed per se, but since a TRUNCATE TABLE will restart the identity seed, you can use a temp table to store a copy of the data,...

• This reply was modified 2 years, 7 months ago by kaj.
• This reply was modified 2 years, 7 months ago by kaj.