Click here to Skip to main content
15,888,016 members

Comments by vahid_erad (Top 12 by date)

vahid_erad 2-Nov-11 5:07am View    
tnx dear
but what is 11 and 12 ???
vahid_erad 14-Oct-11 14:02pm View    
this query :
SELECT ID,
REPLACE(RTRIM(SELECT Name + ' ' FROM myTable
WHERE (ID = t.ID)
FOR XML PATH ('')),' ',' - ')
FROM myTable t
GROUP BY ID


Have this errors :
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'SELECT'.
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ')'.
vahid_erad 14-Oct-11 12:14pm View    
what am i for this table :
---------
ID | Name
--------
1 | A1
2 | A2
3 | A3
1 | B1
2 | B2
1 | C1
---------

get table :

---------
ID | Name
--------
1 | A1 - B1 - C1
2 | A2 - B2
3 | A3
---------
vahid_erad 19-Sep-11 13:17pm View    
dont work ...
vahid_erad 19-Sep-11 4:25am View    
how do this : isnull(b.cost,0) ?