J Livingston SQL (4/6/2016)

---

Chris ...dont think it is "unexpected behaviour"...beginning to see more and more of these types of questions where OP is given a solution and never responds...until the...

Hard to troubleshoot without accessing your instances and drilling down step by step, but here is my wild guess. Did you change/create routes on both instances to point to the...

MadAdmin (4/5/2016)

---

Oops, you are right, I meant

select title, userid, users.name, manager,

manager.name managername, hrid, hr.name hrname

from @employee employee

inner join @user users on employee.userid...

MadAdmin (4/5/2016)

---

Ed Wagner (4/2/2016)

---

If the employees table has lots of rows, you shouldn't be using table variables, as they t get the benefit of statistics.

If these were physical tables, I'd...

R.P.Rozema (4/5/2016)

---

Hugo Kornelis (4/2/2016)

---

I think that would be for a binary collation. For case-sensitive collations, it would be either LIKE '[a-Z][a-Z]%', or LIKE '[A-z][A-z]%'...

pbo71465 (4/3/2016)

---

Thanks Hugo,

I'm just looking for the logic to count patterns of action in a sequence.

If you're not aware of any, then thanks for your contribution.

I'm thinking someone has come...

You are repeating the question, but you are not giving the additional information we need. Without the CREATE TABLE and INSERT statements plus expected results I requested, I cannot help...

Okay, and here is the post I wanted to make in this topic.

Apologies for not replying sooner. I have been on the road for a few days, traveling to and...

Hi Patrick,

Here's my original requests for row constructors. The request focuses on updates, and it has a comment by Itzik Ben-Gan that adds a lot of useful cases for row...

EDIT:

Sorry, that's what you get for using multiple windows. I posted the text intended for another topic here. Apologies.

As others have already said, there is no way to guarantee execution order, so there are three answers that are "sort of" correct (0,0 / 1,1 / 2,2 - the...

Do you already have an existing database, or are you now looking at how best to design the database?

If you already have the database and cannot change the design, then...

ffarouqi (4/2/2016)

---

Hugo Kornelis (4/2/2016)

---

It is (sometimes) okay to shrink a database file or a log file as a one-time operation, if something happened that caused it to grow beyond the...

sqlbaby2 (4/2/2016)

---

here the sql statement

select title,userid,users.name,manager,manager.name managername,hrid,hr.name hrname

from employee inner join users on

userid = users.id inner join users manager on

manager = manager.id inner join users hr on

hrid = hr.id

But...

This sounds like a homework assignment so I will give you a few pointers but not a full solution. If you can show what you already have, I can provide...