Correct. To be honest, I just assumed that the OP had worded their question...

Your procedure contains at least 1 syntax error. Why do you refuse to format your code?

The process is described in detail here. Which part are you having trouble with?

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 5 years, 8 months ago by Phil Parkin.
• This reply was modified 5 years, 8 months 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...