Phil, thank you very much for taking the time to write these queries and I apologize for the delay in replying (works gets in the way of my fun...

I did try to research workaround but to no avail. Some of the examples...

A quick Google search brought me here, which explains how to work round this.

Note that the following is vulnerable to SQL Injection. If your business rules table is at any risk of being compromised, don't use this code.

DROP TABLE IF...

You'll be needing to use dynamic SQL to make that happen.

But if all of your business rules are like that, why not just join on (Name, Country)?

Just hit the Unsubscribe...

Hi,

Below is expected result. i want to compare each with next row on datetimefield and fetch the difference between two. Again comparision is ID wise. If next row contains...

Your expression works fine for me:

That is weird, but if time is pressing and you want to get round it, you could do something like this:

SELECT ClientPhone = @x.value('(/Data/Client_x0020_Phone_x0020_Number)[1]', 'varchar(30)')
  ...

Given that this works:

DECLARE @x AS TIME = '2020-06-22T09:00:00-04:00'

SELECT @x

you are very close.

Can you provide a full example XML string for us to test with?

Here is an alternative which avoids the use of IsNull() and does not require 'conversion to a known value':

DECLARE @Var1 DATETIME = NULL;
DECLARE @Var2 DATETIME = NULL;

SELECT...

• This reply was modified 6 years ago by Phil Parkin.
• This reply was modified 6 years ago by Phil Parkin.

I have not tried doing this, but as far as I can see, the OData connection gives you access to the data in SharePoint lists, not to the data stored...

I don't see any code that was uploaded - it looks like one of your posts was marked as spam.

I have no idea what

It won't load all of...

If you were to add a unique filtered index on the CompanyName column, this would prevent the insertion of duplicate non-NULL company names, while allowing multiple NULLs:

CREATE...

As the numbers you are summing exist in a form where they are not broken down by LC, you cannot retrospectively...