Ah yes, that's probably why in the link I posted, they recommend not to make user-defined roles members of fixed roles!

John

Johan

Yes, it is.  The first result when I typed "SQL linked server" into a search engine provided confirmation.

John

• This reply was modified 5 years, 8 months ago by John Mitchell-245523.

Is this a homework question?  What have you already tried?  It seems to me that you need a simple GROUP BY query.

John

One disadvantage of using Developer Edition in a testing environment is if whatever you are testing or developing happens to use an Enterprise-only feature.  You could get a nasty surprise...

Sounds right to me.  From the documentation:

Fixed-database roles are defined at the database level and exist in each database. Members of the db_owner database role can manage fixed-database role membership.

John

If @EndStation is always greater than @BeginStation, then you can simplify like this.  Note that I've also removed the NOTs and changed ANDs to ORs and >= to < and...

I think you'll need a few ORs in your join predicate.  Based on your sample data, what results do you expect from your SELECT query?

Where does the data in the...

Just a shot in the dark, but is there already a database with the same name as the clone you're attempting to create?

John

I don't understand why you can't generate a table?  Here's an outline to show how easy it is:

CREATE TABLE #Subscriptions (
cs_contactyominame <datatypename(nnn)>
,name <datatypename(nnn)>
,Status <datatypename(nnn)>
)

INSERT INTO #Subscriptions
VALUES
('Emil Salha',...

You need to create the temp table first, then use an INSERT...EXEC to insert the rows.  That applies whether you use OPENROWSET or not.  And don't forget to put those...

You don't need to specify the database name...

OK, good.  Did my suggestion work?  Can I ask why you're using OPENROWSET instead of just running the EXEC statement?

By the way, I think you need to enclose your date...

Try replacing "(local)" with ".".  Is (local)\SQL2014 the same instance you're running this code on?

John

Transactional replication would probably work as well as anything, so long as your table has a primary key constraint.

John

Mark

That code works for the values you mentioned in your original post.  Perhaps you have one or more values in the column that, for example, uses a comma for the...