sharonmtowler (8/5/2015)

---

no i did not. i posted the same information.

i was given this by someone

ROW_NUMBER() OVER (PARTITION BY patient_id ORDER BY enter_time) AS

i know enough that i need to...

Ed Wagner (8/5/2015)

---

SQLRNNR (8/5/2015)

---

Sean Lange (8/5/2015)

---

Ed Wagner (8/5/2015)

---

Jack Corbett (8/5/2015)

---

I couldn't answer all the questions, but I don't expect to be able to answer every question in an...

Ed Wagner (8/5/2015)

---

Jack Corbett (8/5/2015)

---

I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I would think...

This doesn't take into account matches (when there are ties in position 10 for the number of patients). If you are ok with that then you should also add a...

The point he was making is that in your post you never said anything about sessionid. Obviously...

New persopn (8/5/2015)

---

Hi All,

I am unable to connect to server using windows and SA logins as well we tried with multiple logins still wont work getting below error.

Login failed...

sharonmtowler (8/5/2015)

---

I want to know if it is possible to do the following;

I have patients that may have been transferred to different locations(see below)

location_name enter_time

4D04 2/9/15 2:35

4D14 2/9/15 8:44

RECOVERY 3...

WayneS (8/5/2015)

---

Eirikur Eiriksson (8/5/2015)

---

Koen Verbeeck (8/5/2015)

---

I have been nominated again for Author of the Year at MSSQLTips.com. For some reason they already started the voting process, which runs until the...

Ed Wagner (8/5/2015)

---

Sean Lange (8/4/2015)

---

Except that...

Easy question but not really sure what the point of the question was.

Except that NOLOCK can also be...

Since Lynn is unable to post code I took the liberty of tossing together an example of how you could do as an itvf. This is certainly a lot easier...

Here is Lynn's code in case anybody wants to see it.

SET ANSI_NULLS ON;

SET QUOTED_IDENTIFIER ON;

GO

CREATE PROCEDURE [dbo].[sp_ViewCreate]

@TableName varchar(100),

@Dist varchar(20)

AS

set nocount on;

declare...

yb751 (8/4/2015)

---

Raise your hands if you like Entity Framework...then I'll know who to shoot!

Sorry just needed two seconds to vent. :crazy:

I'm sure like anything else it can be fine when...

blossom_suki (8/4/2015)

---

Actually, I need to create 20 views for each database, in the system we have more than 90 databases.

Thus, I was wondering if there is an automated way of...