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 3 years ago by kaj.
• This reply was modified 3 years 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 3 years 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...

It's valid JSON.  You could try either with two OPENJSON's or one OPENJSON and 2 JSON functions

/* two OPENJSON's */select SerialNumber, ojc.[value] as ChannelID
from openjson(@json) with...

Working with a combination of local and remote tables can be tricky.

You can try a few easy modifications and see if that helps:

1. Switch the joins (which by itselft shouldn't...

• This reply was modified 3 years, 1 months ago by kaj. Reason: elaboration
• This reply was modified 3 years, 1 months ago by kaj. Reason: typo
• This reply was modified 3 years, 1 months ago by kaj. Reason: Typo

I'd say it's because the CDbl function only expects one parameter value and you supply two.

I have no answer, but apparently you're not alone with that issue... 😐

SQL Server 2019 External Scripts Network Drive Access Denied

Is this what you're looking for?

DECLARE @MailMessage TABLE (
    "to" VARCHAR(100),
    "from" VARCHAR(100),
    "heading" VARCHAR(100),
   ...

• This reply was modified 3 years, 3 months ago by kaj.
• This reply was modified 3 years, 3 months ago by kaj. Reason: Added root element and XML output
• This reply was modified 3 years, 3 months ago by kaj. Reason: Changed output format type from XML to Plain, because the "pretty print" was otherwise lost

You are partioning on the same column that you do MIN/MAX on. This will not work. As I understand your requirements, you shouldn't do a PARTITION BY, since you want...

• This reply was modified 3 years, 3 months ago by kaj. Reason: Removed ORDER BY in the window function, since it's not necessary