Hi,

try this, on inner join

create table #temp1

(

MID int,

EID int,

ENAME varchar(10)

)

insert into #temp1

select 1,1,'A'

union all

select 1,2,'AA'

union all

select 1,3,'AAA'

union all

select 1,4,'AAAA'

union all

select 2,1,'B'

union...

Hi,

One of the best work bench to the calculating the MEDIAN, is ref this

http://www.simple-talk.com/sql/t-sql-programming/median-workbench/

Pemmasani Srinivasa Rao. (12/4/2009)

---

Please try the following, I am also learner, please tell me if any thing wrong in my query, as per my tests it is giving correct results.

Select...

Hi, Ref the discussion

http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/53f689c1-53c8-45c6-b9ce-c44bce46cd9d/

Hi,

In the enterprise managers is some time happened on the client side because of the client and server code pages may not match, but its not the issue in the...

Hi,

I say about the DBs, but you mentioned the tables, Ok, lets confirm this,

In the enterprise managers, when expend the database, its not show the DBs except the System...

Hi,

Can you see the system DBs(like master, tempdb…) ,database tab in the enterprise managers?

Hi,

In the sql, it’s not possible to convert the overflow (if happened) to zero, but we have to make it to zero, like (in your case)

declare @tbl1 table ...

Hi,

What you mean by the JUNK characters,

Give some samples of those characters, its can help to offer some advice

Hi,try this

create table #temp1

(

ID1 int,

Qs1 int,

Qs2 int,

Qs3 int

)

insert into #temp1

select 1,2,1,4

union all

select 2,2,1,1

union all

select 3,3,1,2

union all

select 4,2,1,3

select b.[char],b.[charcount],c.[totalrow],

(cast(b.[charcount] as float)/cast(c.[totalrow] as float))[percent]

from

(

select Qs1 [char],count(Qs1) [charcount]

from #temp1

group by Qs1

)b...

Hi,try this

create table #table

(

name1 varchar(20)

)

insert into #table

select 'Alok Bhatia'

union all

select 'Amit Chaudhuri'

union all

select 'Amit Varma'

select * from #table

select PATINDEX('% %',name1) from #table

select right(name1,(len(name1)-(PATINDEX('% %',name1))))

+','+

left(name1,PATINDEX('% %',name1))

from #table

Hi,

Also use this,

For search in the current database

select object_name(id)TableName from...

How you say the extra load on the DB?

raaz66 (11/27/2009)

---

combined these...

Hi,

No need to connect the each DB separate to run the multiple DB procedures,

Just call the procedures with full qualification that is DB1.DBO.MYSP, DB2.DBO.MYSP2 like this you manage to executive...

create table #test1

(

slno int identity(1,1),

c1 int,

c2 int

)

insert into #test1 (c1,c2)

select 1,2

union all

select 2,3

union all

select 6,8

union all

select 7,7

union all

select 8,8

union all

select 4,9

union all

select 9,9

select a.slno,a.c1,a.c2,

(

select count(case...