Possibly the easiest way would be

select convert(bigint,+9966557785.0000000000000000)

Depends on what you want to do with the number after this really though.

Try this article for the general pro's and cons.

http://sqlserverpedia.com/blog/sql-server-bloggers/catch-all-queries/

Try the exists clause to test your output from BK_TagSMS_ParameterSplit

Have a look here http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ , under "Saving the execution plan".

Connect bug report raised here.

This link discusses your options

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Feel free to post again with any further questions

OK....

Take For instance

1 2 3

-----------------

15 5280 96828810

16 5280 96828810

What output are you expecting

96828810 15,16

96828810 15

96828810 16

something else?

Here's a simple distinct example..

create table x

(

x1 integer,

x2 integer

)

go

insert into x

select 1,0

union all

select 1,0

go

select * from x

go

select distinct x1,x2 from x

Im not sure im clear on your requirements , can...

Ok ,you are on 2000 not 2005 , Cross apply wont work,

have you tried modifying your SQL as drew suggested ? ie remove the join to DW_SERVICEORDERSJOBS_F. Looks like...

I'm sure we can help with this. Just one question: if a country has its population changed, what are the rules for updating the states? Say USA changes...

with cteSalary(Id,Salary,RowN)

as

(

Select Id,Salary,row_number() over (order by salary)

)

Select * from cteSalary where Rown = 3

Try this, possibly not the most efficient, i suspect that a hierarchyId-esque based query may be faster over a large dataset , but should do

Create table #RecursTest

(

ID integer,

Node varchar(10),

ParentId...

Recursive CTE's are the way to go....

Try this link http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/

Sorry the...

Shall I ? , i feel mean , but at the same time it is quite simple.

http://www.sqlservercentral.com/Forums/Topic781960-338-1.aspx

--edit : Fix URL

KB (9/3/2009)

In this article, I need to know what is the purpose of SortKey in CTE.

In the hierarchy, will the Top level row is returned first??

(In our project we need...