Loads of ways to do this.

Here's two.

BEGIN TRAN

CREATE TABLE #user (u_id INT, NAME VARCHAR(10));

INSERT INTO #user VALUES (1, 'steven');

INSERT INTO #user VALUES (2, 'david');

CREATE TABLE #work (w_id INT, userid INT,...

crazy4sql (2/7/2012)

---

Here is the updated script to capture the information for all user database in the server using suggested CTE method in earlier reply (but cursor still not going out...

hervouet (2/7/2012)

---

I have 2 requests. The first one do an "index seek", and the 2nd do an "Cluster Index Scan" ... Do you know why ?

select *

from dbo.ASPStateTempSessions...

a20213 (2/6/2012)

---

The function Split works great 😛

Still, i did

update #tgroups set alunos_ids = replace(alunos_ids, ' ','')

and my previous query worked well, so i think i have to make...

Tried polite and unpolite impolite comments directed at him, neither received a reply so I'm...

Jeff Moden (2/6/2012)

---

Heh... you guys must be talking about my recent favorite candidate for the "Flying Porkchop Award". I just dope slapped him where he posted two links that...

Perfect, thanks very much 😀

Does this help?

BEGIN TRAN

CREATE TABLE #temp

(

ID int IDENTITY(1,1)PRIMARY KEY CLUSTERED,

alunos_id bigint

...

HowardW (2/6/2012)

---

This one's particularly amusing in that not only does it have nothing at all to do with the topic, but it's not even T-SQL, it seems to be for...

Koen Verbeeck (2/6/2012)

---

It seems we have a personification of Google on these forums:

http://www.sqlservercentral.com/Forums/Topic1246473-391-1.aspx?Update=1

Now he is just copy pasting MSDN articles into the topics. :rolleyes:

At least it had something to do...

SELECT STUFF(CAST((SELECT '/' + [BudgetCode]

FROM [BudgetCode], [Employee]

...

Let's not use a cursor when we can avoid it 😀

--Method 1

SELECT NAME, COALESCE(STUFF((SELECT ', ' + roleName

...

Hello and welcome to SSC!

I'd like to be able to help, but it seems you've forgot to post readily consumable sample data and ddl scripts.

If you could read this article[/url]...

I've had a go, but my suggestion is that you read Jeff's article on running totals with the quirky update method[/url].

BEGIN TRANSACTION

--Not part of the solution, this is used to...

Oh for the love of. . .

1) That is...

ashutosh.kumarpandey (2/3/2012)

---

I know but a) cross join does not require any common key between the two table b) it will increase the number of column in the output which I...