I agree that restoring from your most recent backup(s) would be the fastest way at this point. Do you have recent backups?

I just need to avoid a 43 point night by Eric Decker and it looks like it will be a good weekend for Prestige Worldwide! 😀

If it makes you feel better I left 15...

I was there and got a D+ on draft score card so things are looking pretty good for me 😀

SQLDCH (8/13/2014)

Yeah, draft order is random...

Less than two weeks to go! Looking forward to it and I have it on the calendar.

Using what Jason mentioned above, does this work:;with cte as (

select

c.Fname + ' ' + c.lname as PersonName

,pt.PatientID

,p.Fname + ' ' + p.Lname as PatientName

,ph.Phone_number

,ROW_NUMBER() over (partition by...

That helps, can you provide the desired output from the sample data?

Thanks for the schema, but to get a faster (and better answer) please provide the create table statements along with some sample code including the issue you are trying to...

Please only post a question in a single forum. Here is a link to the active one: http://www.sqlservercentral.com/Forums/Topic1598758-147-1.aspx

The best way to do this is to add a modified datetime column to the tables and either update your process or use an update trigger to update the column...

Thanks Jason!

The first thing I would run is this:DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGSand post the entire output. Once corruption has been ruled out then we can start investigating from...

I would put the onus on them to say why it isn't preferred and...

What is their reason for not using WAITFOR?