Any Inputs ?

http://www.sqlservercentral.com/Forums/Topic432183-8-1.aspx

i have tried to implement it. But i failed to implement.

Anybody help me out to resolve this issue.

Your query will fail,if i have one more space in...

Really Jeff ! Can u give me an example ?

Jeff,

I have modified your code slightly.

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

Select SUBSTRING(Full_Name,CHARINDEX(' ',Full_Name),LEN(Full_Name))+','

+SUBSTRING(Full_Name,1,CHARINDEX(' ',Full_Name)) AS ModifiedName

From #yourtable

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

It works fine.

Thanks Chris. I Welcome your suggestions.

I have modified your code slightly and found a new way to acheive the same task.

select People_Number,count(*)

into #Cnt

from #TheTable

group by People_Number

having count(*) = 2

select a.People_Number,a.Web_Role

into...

"http://www.aivosto.com/visustin.html"

it is very useful.

Thank you for all.

I know the second method is efficient.Because it doesn't use Temp tables.

Every Database...

steveb,

i think your query will display 200 and 250.

But the expected output is 250 only.

Please check it.

which one is the efficient way ?

Any Inputs ?

Gsquared and SteveB,

Suppose if i want to replace some special characters from a string, shall i use char() function ?

Say for example,

Declare @Str varchar(15)

set @str = '13-08-2008'

select replace(@str,xx,char(47))

here xxx can...

Thanks SteveB and Gsquared.

Sorry for not including your suggestion.

Well,once again,Thank you for all.

can't we achieve this by using SQL queries ? Because you are all saying sp_depends or dbo.sysdepends table will not provide the necessary or relaible informations.

Again,can't we achieve this by...