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 1 year, 2 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 1 year, 2 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 1 year, 3 months ago by  kaj.
• This reply was modified 1 year, 3 months ago by  kaj.

SQL Server doesn't support a JSON data type, in contrast to the XML data type which can be employed for storing XML.

When the XML data type is used for storing,...

• This reply was modified 1 year, 3 months ago by  kaj. Reason: Removed direct reference to browsers and inserted SSMS instead

Absolutely, I have done that a few times.

You can use a script task or a script component to consume the web service. Then you can either store the response as...

Not sure if I have got the logic right, but please try this query:

SELECT CONVERT(CHAR(7),EOMONTH(J1.EntryDate)) AS Per, SUM(J1.RunTime) AS TReg, J2.TNQ
FROM Db1.dbo.WipLabJnl J1
OUTER APPLY (
...

Not sure if I have got the logic right, but please try this query:

SELECT CONVERT(CHAR(7),EOMONTH(J1.EntryDate)) AS Per, SUM(J1.RunTime) AS TReg, J2.TNQ
FROM Db1.dbo.WipLabJnl J1
OUTER APPLY (
  ...

Not sure if I have got the logic right, but please try this query:

SELECT CONVERT(CHAR(7),EOMONTH(J1.EntryDate)) AS Per, SUM(J1.RunTime) AS TReg, J2.TNQ
FROM Db1.dbo.WipLabJnl J1
OUTER APPLY (
  ...

That's too broad a question.

Application? What type of application?

Office-based application? Desktop application? Web application? Mobile application? Console application?

Even knowing that, it will be hard to advice, because we don't know...