SQLTestUser (2/20/2015)

---

not allowed to change the structure, wish i could, A location can have multiple areas, a customer can be associated to only one location and one area. The concept...

jung-387933 (2/20/2015)

---

actually what i am trying to do is

logic something like below that I am going to put in a function .. but value field in table A...

szucs.tas (2/20/2015)

---

I am looking for a way to fix an Access file. When i open it i get an error: The file needs repaired or isn't a database. I...

Grant Fritchey (2/20/2015)

---

Ed Wagner (2/20/2015)

---

jasona.work (2/20/2015)

---

Remember...

KGJ-Dev (2/19/2015)

---

Hi Sean,

thanks for reply and if at all if there is any improvement on the query in which part of execution plan will intimate me. Any suggestion. Can i...

There is nothing wrong with the plan. What is the issue here? Your query returns 6 rows nearly instantly.

It sounds like my wife may have to travel to Denver for work soon, probably within the next couple of weeks. I am trying to coordinate it so she can...

If...

Joe this thread is 6+ years old and the OP hasn't even logged in for more than 2 years. However your analogy on using the scratch tape and rewinding nearly...

treyagrimes (2/18/2015)

---

Thanks again imex,

Last question I promise. Adding Distinct does work, but with or without it, I am noticing it is trimming the the first letter word/number off the...

Check out this article on the topic. http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

kabaari (2/18/2015)

---

SSC,

I am inserting data to SQL 2005 from an HTTP Post, the minimum usable data is 120 characters long (Sample: Tag:E200 32E2 F2B3 A4B1 252B CE92, Disc:2015/02/17 15:47:44.215, Last:2015/02/17...

Using the examples from the article I posted you should be able to come up with something like this.

with SortedValues as

(

select a.*

, b.Task

from TableC c

join TableA a on a.Id =...

Thanks for the ddl and sample data. However, what you posted is not like what you originally posted. More importantly there is not enough sample data. If I understand what...

Hi and welcome to the forums! You can do this using STUFF. http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

If you need help with the coding part please take a look at the first link in my...