Hi Gaurav

You are converting date into Varchar hence it is ordering how it will order a string. If you want  order as date may be do not convert it to...

It does have a bunch of meta data and audit tables that stores this data including any failures etc. so you can use those to build a report.You will find...

Hi Jordon

You should be able to use JSON_VALUE to read just the id field.

The way I have done something like this is to bring json string in a table -...

Yes I have used Wherescape in my  previous place - kind of have mixed feelings about it. Basically you use GUI to create procedures / ETL process/ run jobs  and...

Hello Everyone

I know this is an old post - but  I am facing the same issue - DT_TEXT truncates data after 8388608 characters whereas it should  hold upto  2,147,483,647 characters....

For Case 1 - I am guessing since the error is primary key violation srcdb.dbo.stg_tbl either has more than one record with same id or it has a record with...

Couple of things I can say  -

UNION removes duplicate - you may want to use UNION ALL if you want to see the error for CASE 2

TOP 1000 rows in...

This is so cool !

Thanks for sharing

Thanks Chris and Drew for your detailed explanation - it does make sense.

I guess I was just so hung up with the idea of some strange grouping - I did...

Pretty sure there will be a much elegant way to this - I came up with below. This will work if you a calendar table with all dates or you...

Thanks Jonathan - your script solves my problem!

Joe - appreciate your inputs and your link about transition looks like something I can use in future

The example I produced was just...

Very sorry guys  I just realized I made a mistake in the output - I have edited the example in my question above

The 'rownum' column is just to show the...

You can use something like below

SELECT studentid   , 
REPLACE(REPLACE(sm.StudentMessage , '<FineAmount>' , ISNULL(sm.FineAmount, '') ) ,
 '<AbsentDays>' , ISNULL(sm.AbsentDays , ''))
FROM #StudentMessages AS sm

I don't think you can using current partition - you will have to add some other the condition in partition -  basically  how do you determine row 18 should reset

for...

Agree with Pietlinden - only thing to add if you are in SQL Server 2017 you may use String_Agg  function

Thanks