sqlfriends (6/26/2015)

---

Sorry, that is not what I am asking.

I know login is at instance level, user is in the database level.

Let us remove the code about checking exists of the...

sqlfriends (6/26/2015)

---

Thanks,

Yes, I do need to check if the user exists before I create the user for the login.

Even so, I think the create user statement should error out,...

sqlfriends (6/26/2015)

---

I am using a SQL server 2008 database.

I am working on a windows user.

I noticed when I create a user in a database for a login, even that login...

sgmunson (6/26/2015)

---

Time for...

You need to do something like this:

select * from #TABLE1

where ID in (select Item from dbo.DelimitedSplit8K(@newID,',');

The code for dbo.DelimitedSplit8K is attached.

Okay. I can't really help looking at the pictures even though they are pretty.

What would really help is the actual execution plan as a *.sqlplan file instead of pictures of the execution plan.

Used properly dynamic SQL is a viable tool for development. The key here is "used properly."

emmchild (6/25/2015)

---

Check out http://www.meetup.com/pg_atl/. Everyone one is encouraged to contribute. It's really a good mix of newbies and seasoned veterans. A site that encouraged that same sort...

apogoreliy (6/25/2015)

---

There is a way to get back your records from a backup without using any tools. It was useful for me, so i can suggest it. There is an...

mw112009 (6/24/2015)

---

Forgot to tell u but there can be many patients. So I had t modify as follows:

cross apply (select top 1 case_num from #cases c where convert(char(8),c.case_date,112) <= convert(char(8),r.exam_date,112)...

Sean Lange (6/24/2015)

---

mw112009 (6/24/2015)

---

The 2 tables have data for one patient whose registration number ( reg_num ) is = 1

--Has data when the patient came to hospital

create table...

mw112009 (6/23/2015)

---

CREATE TYPE BP_Data_ACRC_427_B

as table

(

AIMS_VALUE_NUMERIC numeric(19,2),

bp_type VARCHAR(4),

Dt datetime ,

ID int IDENTITY(1,1),

MBP numeric(19,2),

MPOG_PHYSIOLOGIC_CONCEPT_ID VARCHAR(10)

UNIQUE CLUSTERED (MPOG_PHYSIOLOGIC_CONCEPT_ID,Dt)

)

IT works in SQL Sevrer...

emmchild (6/23/2015)

---

Your sales and marketing folks would have a better idea than I would in terms of the market opportunity for a PGSQL schema compare or a data compare. ...

chrisn-585491 (6/23/2015)

---

This isn't about RavenDB over SQL Server. It's about choosing any technology based on the staff and skills you have, or can get. Every technology has some based of...