-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: San4u8
Message 4 in Discussion
New Message on MumbaiUserGroup
breaking strings in first table and store into second table
Reply
Reply to Sender
Recommend
Message 2 in Discussion
From:
San4u8
Hi Deal ,
declare @strLen int
declare @position int
declare @str Varchar(200)
declare @first varchar(100)
declare @second varchar(100)
set @second =''
set @first =''
select @strLen= Len(string), @str= lower(string) from firsttable where ID=1
print @strLen
print @str
set @position = 1
WHILE @position <= @strLen
BEGIN
if @position%2 = 0
begin
set @second [EMAIL PROTECTED] + (SUBSTRING(@str, @position, 1))
end
else
begin
set @first [EMAIL PROTECTED] + (SUBSTRING(@str, @position, 1))
end
SET @position = @position + 1
END
print @first
print @second
insert into secondtable(@first,@second)
Regards
Santosh Ughade
Professional Access Software Dev. Pvt. Ltd.
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
