davidsheardown

// Uses NewtonSoft.Json
XDocument doc = XDocument.Parse(xmlData); //or XDocument.Load(path)
string jsonText = JsonConvert.SerializeXNode(doc);
dynamic dyn = JsonConvert.DeserializeObject<ExpandoObject>(jsonText);

davidsheardown

-- Allows you to pass in option params and select based on the combination
-- The trick is the WHERE (condition in brackets) AND combination below

ALTER PROCEDURE [dbo].[FetchTaskHistoryByClientId] 
	@ClientId		int,
	@TaskId			int = 0,
	@TaskCompleted	bit = 0,
	@TaskFailed		bit = 0
AS
BEGIN

davidsheardown

		declare @Sku varchar(100) = 'xyz123456'

		;WITH CTE (Sku,StockItemId) AS
		(
			SELECT
				Sku, 
				StockItemId
			FROM 
				table_products
			WHERE

davidsheardown

-- Using MS SQL 2008 and above..

-- Create a test table first
CREATE TABLE dbo.DataType
(
    ID             int IDENTITY(1,1),
    TypeName       nvarchar(255),
    [TypeProperty] nvarchar(255),
    CONSTRAINT PK_DataType PRIMARY KEY (ID)
);

davidsheardown

/*
  Increments an INT column in MS SQL
*/

Update MyTable
  set testCount= ISNULL(testCount, 0) + 1 
 where MyTableId = 1

davidsheardown

// Always remember to escape "." or special characters, otherwise you cannot select/refer to the selector etc.

$( "#myID\\.entry\\[1\\]" ).css( "border", "3px solid red" );

davidsheardown

//
// I had a recent issue where I needed to escape carriage returns within a JSON object, or correctly, the JSON string itself.
// You can of course use the JSON stringify function to get a string representation and then you need to do the following
// to escape the "\n" carriage return sequence..
//
var stringifiedJSON = JSON.stringify(jsonData).replace(/\\n/g, "\\\\n");
//
// The above will globally (within the string) replace all \n with \\n which allows JS to store the carriage return.

davidsheardown

// If we have a JSON object as such..
var data = [
    {id:0, name: Name1, type: Error},
    {id:1, name: Name2, type: Error},
    {id:2, name: Name1, type: Error},
    {id:3, name: Name1, type: Error},
    {id:4, name: Name3, type: Error}
]

// Using underscore, we can get the top occurrences, in this case the top 5 (slice)

davidsheardown

<!--
  Bootstrap 4 doesn't have the "remote" option anymore.  Little jQuery will get you an external URL in a modal
  *Note: The "data-remote" attribute specifies the URL to open within the modal
-->

<button id='abutton' class='buttonopen' data-remote='http://your-url.com'>Click Me</button>

<script>
$('buttonopen').on('click', '[data-toggle="modal"]', function(){
  $($(this).data("target")+' .modal-body').load($(this).data("remote"));

davidsheardown

;WITH CTE AS(
   SELECT field_to_identify_duplicate,
       RN = ROW_NUMBER()OVER(PARTITION BY field_to_identify_duplicate ORDER BY field_to_identify_duplicate)
   FROM table_with_duplicates
)
DELETE FROM CTE WHERE RN > 1