Hi.,

Can you post the table structure with some sample data and your required output..

Thanks.,

Hi guys i have got the solution for my problem..

The Following is the coding

alter procedure Hierarchy

(

@m_id int

)

as

begin

declare @cnt int

declare @e_id...

Hi GSquared,

Hope you are not clear with my Question the criteria is if i give the E_id 2 it produce...

WITH Managers AS

(

SELECT top 1 E_id, Name, M_id, '' f_name

FROM Employee_detail

WHERE M_id IS NULL

UNION ALL

SELECT e.E_id,e.Name, e.M_id,m.f_name

FROM Employee_detail e INNER JOIN Manager m

ON...

Ken it works well ..

Good Job.

Thanks for posting the Query.

Hi.,

Hope im correct jus try this and some may come out with an optimized Query.

DECLARE @NumStr varchar(1000)

declare @num int

SET @NumStr = 'T5e3st003';

set @num=(select PATINDEX('%[A-Z]%[A-Z]%[A-Z]%',reverse(@NumStr)))

BEGIN

WHILE PATINDEX('%[^0-9]%',@NumStr)> 0

SET @NumStr =...

Can you Post your Coding.

Hi,

i have a doubt whether the length of this string('Te6st03') will change or its static.

Thanks.

Can you send me some sample records and your table structure.

And whats your expected result.

Ya you are correct i have modified that now it's working fine

Thaks for your response

Thanks

Chandru

Hi steve,

Yes you are correct that was the mistake i made .Thanks for your kindly help..

Hi,

I have made some changes in that coding

alter procedure upd_screen_optional_data

(

@xmldoc ntext,

@option_id int

)

as

begin

declare @v_error_no int

declare @xml_hnd INT

EXEC sp_xml_preparedocument @xml_hnd OUTPUT,...

Thanks John,

I got the idea about Excel CONCATENATE function ..

Thanks for your kindly help..

Thanks John I can understand the insert statement well and im trying to use one time import , i dint get any idea about Excel CONCATENATE function to build...