GilaMonster (4/26/2016)

---

If you remove the database users, the person can still log in and access the server. Depending on their server-level permissions, they may still be able to access the...

sorry, little confused as to what you are showing with the screenshots.... list1, list2?

Can you do a quick screenshot or just type what you expect the outcome to be?

Just...

same answers been...

Luis Cazares (4/20/2016)

---

Just a small note on your nice suggestion.

You offered first a solution for a many to many relationship. This is useful when a product can have different categories....

I don't know the answer for this... is it even possible? Would you ever have a scenario like this?

I'm curious to see if any one has a solution for you...

Also, if you're not sure on "how to do" whats being asked (E.g. writing the code to make the tables). Try an attempt first, if its wrong we will fix...

Try to use my question 2 as a guide. Its all very similar.

Copy my temp table and modify it to meet your needs. Post...

djmenon21 (4/17/2016)

---

This is what i came up with for the below questions as per the data given :- Can anyone help me with the 2nd question ?

2. Please write an...

SQL!$@w$0ME (4/15/2016)

---

Tava (4/14/2016)

---

For our SSIS process we have a dedicated ETL Server per environment (TST/STG/PROD - TST way lower specs), all our packages run on here and perform all the...

For our SSIS process we have a dedicated ETL Server per environment (TST/STG/PROD - TST way lower specs), all our packages run on here and perform all the Extract, Transform...

Interesting Jeff, we were in the same boat as you regarding our indexes. I think we are doing this now as a reactive exercise as it fixed our problem (and...

Thanks for all the replies, least I know I'm on the right track for doing this... I'll have a look at those links provided as well.

Thanks again

Firstly to answer your questions.

1. ORDER BY is in my code, i had it left out...

2. The relationship between Table1 & Table2 exists i left out a condition...

Phil Parkin (4/4/2016)

---

So am I right in thinking that the number of columns which you are returning depends on the number of rows in the temp table? There's some unusual...

Phil Parkin (4/4/2016)

---

Tava (4/4/2016)

---

Phil,

I've had a quick read, I'm a little confused... The values of 4,8,30,N... will be passed via the #temp table i created.

Since I'm using an outer apply...