I concur with Pietlinden as that is how I teach as well -- show me what you tried and talk me through your thought pattern so that I can help...

P.S. Emperor100 I do applaud you for the effort so please do not get me wrong on that part. Trying to help is a good thing, but understanding the problem...

Okay Emperor100 so it seems that you have changed the fundamental request of the OP by assuming that their formula must have been meant to calculate the Average Lag but...

Ghads I cannot still believe -- they negate a post as spam for a single edit -- that is just totally ludicrous.....  At least I can get back to the...

Hey Bruin I have to ask are you trying not to get help?  I mean several individuals posted items that your initial post was lacking and you have made no...

Yeah and it should be noted to -- absolutely only use VARCHAR(MAX) when VARCHAR(8000) is to small -- otherwise you take a nasty performance hit.  Further I concur with Mr....

Your choice Phil Parkin but negativity does what negativity does whether you notice it our not. In fact, it is more like putting a frog in cool water and slowly...

• This reply was modified 1 year, 7 months ago by  Dennis Jensen.

Phil Parkin please do not get me wrong, I fully understand your position but again negative comments rarely ever help, tweaking the comment to make it positively reinforce doing what...

Arrgh! That so stupid you editted your document too many times is sooo annoying.  Okay here it is again.

Okay Phil Parkin criticizing a questioner is poor etiquete. Instead if you...

• This reply was modified 1 year, 7 months ago by  Dennis Jensen.

Okay cleaning that up a bit I have the following:

DECLARE @Jsondata AS NVARCHAR(MAX)

SET @Jsondata = '{ "Transaction": [ { "Id": 43358
      ...

• This reply was modified 1 year, 7 months ago by  Dennis Jensen.
• This reply was modified 1 year, 7 months ago by  Dennis Jensen.

Yeah -- the old adage I share with folks in any industry is -- if you are not constantly learning then you are stuck in a rut and the only...

Hey don075 do you mind me asking why you could not figure out how to write that basic query?  I am asking because...

Personally I just enoy playing or plarking either is fine by me and there is nothing more fun to play with than code that is solving a problem.

At first I...