lawson2305 (6/26/2013)

---

searching I finally found an answer.

GilaMonster

I find it strange when you double them it puts in the single quote. Thanks for...

This isn't too bad to write. Any chance you can post ddl and sample data in a consumable format? (Create tables and inserts so we can hit f5 and get...

Luis Cazares (6/26/2013)

---

Sean Lange (6/26/2013)

---

What would really help is:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results based...

Steven Willis (6/26/2013)

---

Sean Lange (6/26/2013)

---

Steven Willis (6/25/2013)

---

So in that vein of thought, you CAN do this but not with an identity column which is of course always and only numeric....

skempf (6/26/2013)

---

I have a stored procedure that is used to sync dates between two databases. It looks at the project start date in one database and the production date for...

What would really help is:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results based on the sample data

You...

But you still haven't posted the actual query that you ran....

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

bquintana (6/26/2013)

---

If I run a query to return an email address from an emails replied to, I get some returnes with multiple email addresses with the email address I want...

Barkingdog (6/26/2013)

---

I need to create a table of running totals. Suppose initially we start with $50, then write a check for $3 (leaving $47), then write another check for $7...

mamzy10 (6/26/2013)

---

will give it ago now n its for work actually but i have very limited knowledge using sql but there are no sql dudes in to this work im...

mamzy10 (6/26/2013)

---

Hey guys i need to create a query were i can find out the number of learners there are with a model of 21 and another model eg

learner ...

kapil_kk (6/26/2013)

---

you can do the same thing as Sean did using SUBSTRING also:

SELECT id,

SUBSTRING((SELECT ', ' + Term

FROM Something s2

WHERE s1.id = s2.id

and s2.Type = 'Subject'

ORDER BY s2.Term

FOR XML...

kapil_kk (6/26/2013)

---

Hi Sean,

I know to print comma seperated values using FOR XML.

But I was trying the same solution using COALESCE like this:

DECLARE @var varchar(max)

SELECT @var = coalesce(@var +',','') + term...

Not quite sure what you are asking? Are you asking how does FOR...