we are not sure the query as it is getting my tool  , may i know what are the reasons of getting this error and any idea to resolve...

Based on my previous misgivings about the problem definition, here's one that returns "Appointments" that are returned if they immediately precede or are followed by a "Discharge".  It returns all...

I may be getting this wrong... This only finds the last appointment before a discharge and all discharges.  Please mark your sample data for what is expected in the return...

• This reply was modified 5 years, 4 months ago by Jeff Moden. Reason: Added "PARTITION BY MTMRN" to handle more than one MTMRN
• This reply was modified 5 years, 4 months ago by Jeff Moden. Reason: Ask for clarification on the requirements

You should at least post what the datatype are for the columns.  You'll also find that most people want to see what you've tried in the form of code.  We're...

I'm not a PowerShell affection ado but it seems like the script at the following URL would be of help rather than using Option #2 above.  I recommend making a...

At first, I thought this was more of a "did you actually read the code question" than anything else.   I no longer think that because at least one person said...

Check the resulting table.  You may find that all but that last row has been bulk loaded.  Both BCP and BULK INSERT default to allowing up to 10 errors without...

I should have asked the same question that Michael asked about total disk size and...

That's nice but it won't help solve the problem the OP posted.  Also, while OLA's good scripts are the "gold standard"...

Sorry... wrong person...

@ andre1992 ... Please answer the questions from my first post on this thread so that I can help you solve this problem.

Please answer my questions in my previous post so I can help you fix your problem. 😉

Hi everyone,

I'm trying to figure out how to manage the maintenance of the indexes I just created in some tables of my database.

Once I run the Rebuild, the size...

That's another good way (IMHO).

I guess I don't understand all the gyrations with separating parts and concatenating them back together for this task in SQL Server.  Is there a reason for it?  If not,...

First of all, I recommend NOT formatting data for storage.  It's just wrong for so many reasons.

If the data is ultimately bound for storage in a table, then do the...