It apparently cannot make the distinction between "temp tables" and "temporary tables".  It's seriously incorrect for what most of us refer to as "temp tables" and seriously correct for...

Sorry, but that's not valid JSON.

Generally, what most people do, is to flatten the structured JSON into one table, which can later be queried and grouped.

Alternatively you can also use...

Dear All,

My one condition is working like if data exist than it should fail only one condition is pending that is "if data exists without qty, than qty should...

• This reply was modified 3 years ago by kaj.
• This reply was modified 3 years ago by kaj.
• This reply was modified 3 years ago by kaj. Reason: typos, typos and yet another typo, sorry!
• This reply was modified 3 years ago by kaj. Reason: changed/improved the first IF NOT EXISTS query slightly

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 3 years 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 3 years 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 3 years 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 3 years 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...