Viewing 15 posts - 1,666 through 1,680 (of 8,760 total)
Jo Pattyn - Thursday, January 25, 2018 5:21 AMTesting spring cleanup subscriptions. We're getting 10+°C in wintertime
That's what is called being timely...
January 25, 2018 at 6:20 am
Use minOccurs
😎
January 25, 2018 at 5:16 am
January 25, 2018 at 4:22 am
Quick suggestion, use JSON_QUERY to extract the Order array, here is an example
😎
DECLARE @json AS NVARCHAR(MAX) = N'
[
{
"Customer":{
January 25, 2018 at 4:06 am
Please help me to understand the below
SQL Licensing:
20 X SQL...
January 25, 2018 at 1:30 am
Good Morning Experts,
We had a database on SQL Server 2012. INSERTS were running fine....
January 25, 2018 at 12:11 am
You are welcome!
😎
Alastair Aitchison has written some books on the subject, worth the reading.
January 24, 2018 at 8:14 am
I have a valid...
January 24, 2018 at 5:14 am
Quick thought, add the schema name to the code to make the object references unambiguous.
😎
January 21, 2018 at 2:20 am
This should get you started
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @pString VARCHAR(8000) = 'This Is My Camel Case Stuff With 12345678 Numbers...
January 19, 2018 at 8:04 am
January 19, 2018 at 6:54 am
ColumnName , need to extract the names For NAME="Table2 Col1" not the local-name(.)'
<C0 NAME="Table1...
January 19, 2018 at 4:07 am
Quick thought, you can extract the data in an EAV format and then pivot it, here is a query for the EAV
😎
USE TEEST;
GO
January 19, 2018 at 12:48 am
We are creating an archival plan for one of our table which stores json...
January 18, 2018 at 12:47 am
Viewing 15 posts - 1,666 through 1,680 (of 8,760 total)