Try this sir:

declare @stringtable table

( string varchar(20) )

insert into @stringtable select 'Friel, Joe'

select RIGHT(string,( len(string ) - charindex(',',string)) )+ ' ' + left (string,( charindex(',',string) -1 ))

from...

Jeff Moden (6/29/2010)

---

ColdCoffee (6/28/2010)

---

CHAR(10) inserts a line-break in the output...

:doze: i dint quite get u , Jason ; pls elaborate !

It always is the case here in SSC, u learn not only by asking...

or:

Declare @r_Count1 bigint

select top 1 @r_Count1 = tbl.rn from

(

select row_number() over(order by (select...

My 2 cents 🙂

declare @table table(

string varchar(50)

)

insert @table (string)

select '[gdhdnuidd] 1st Party SW'

union all select '[abcdef] Client'

union all select 'testbusiness'

select

case

...

Why not try this:

select max(tbl.rn) from

(

select row_number() over(order by [SkuNumber]) rn from BALEOD2009

...

hi there...

try this. to convert columns into rows, you need to use UNPIVOT.

declare @table table(

[Emp_Name] varchar(50),

[MOB] int,

[PHN] int,

[OTH] int

)

insert @table ([Emp_Name], [PHN], [MOB] ,[OTH])

...

sammm (6/28/2010)

---

I have a SP which gets parameter @business like this

[abcdef] Client

[gdhdnuidd] 1st Party SW

testbusiness

I want to get rid of the charcters from [ and ]. Is there a SQL...

CHAR(10) inserts a line-break in the output result

FOR XML PATH('')...

Are there chances of one RelationId getting more than one value for xaml column ?

I almost did the query, but waiting for this confirmation..

Oleg and Hugo , thanks for the nice explanations and links.. nice question depicting the precedence of data-types... niceee.

Please proved clearer "Desired Output" ; it is very hard to arrive at what you want for your post,mate...

I guess he/she wants to check if a date is a valid date.. IF MailDate is something like '84-15-0156' (dd-mm-yyyy), then he must reject it, if it is '01-01-2010' then...

xp_sendmail will work with SQL Server 2005..but it will be removed from SQL 2008.. as the yr now is 2010, i would recommend you to change the code to utilize...