Month: June 2019

TSQL Filtering by a Date

"the real stevenkjames"Leave a comment

Here is a snippet of TSQL code that looks at a database and returns just by date and ordered by date.

By a Specific Date…

  SELECT  *
  FROM [DatabaseName].[Schema].[TableName]
  where Cast(LogDate as date) = '2019-06-19'
  order by LogDate desc

By Todays Date…

  SELECT  *
  FROM [DatabaseName].[Schema].[TableName]
  where Cast(LogDate as date) = Cast(GetDate() as date)
  order by LogDate desc

TypeScript “Gotchas” Part 2 DocumentReady

"the real stevenkjames"Leave a comment

DocumentReady

When you want to use the jQuery Document ready in a TypeScript file you need to use the following format…

//TypeScript Document Ready Example... 
//===========================================================
$(() => {
                  console.log("New version of Document ready");
                  //Document Ready code goes here…
}); //End of Document Ready ====================================================================