quote:

---

Originally posted by KidSQL

Hello, I have the following nested loop (yes I know it's not the set way, but it does what it does in a fraction of a second so it's okay):

declare @rgo int
declare @rmax int
declare @r2go int
declare @r2max int
declare @str varchar(8000)
declare @refarray char(8)
declare @let char(1)
declare @tname varchar(10)

select @refarray = 'abcdefgh'
select @rgo = 1
select @rmax = 8
select @r2go = 1
select @r2max = len(@refarray)



while @rgo <= @rmax
begin
while @r2go <= @r2max
begin
select @let = substring(@refarray,@r2go,1)
select @tname = 'tab'+convert(varchar(length),@rgo)+@let
print(@tname)
select @r2go = @r2go + 1
end
select @rgo = @rgo + 1
end


The only output I get as this stands is:

tab1a..tab1h

Why is the outer loop not executing? Shouldn't I be seeing

tab1a/b/c/d/e/f/g/h through tab8a/b/c/d/e/f/g/h?

Is there something I misunderstand about while loops or just something that's missed my eye? (If the latter, apologies in advance, but I would appreciate any help).

Any advice is much appreciated.

Thanks,

-KS

---

quote:

---

Originally posted by KidSQL

Thanks madhivanan!! I just needed an extra pair of eyes.

By the way, if I may say so, I remember joining this forum not long after you did, back when you only had a hundred or so posts to your name. I must say you've come a long way - impressive for the rest of us.

Thanks again!

---

quote:

---

Originally posted by visakh16

quote:

---

Originally posted by KidSQL

Hello, I have the following nested loop (yes I know it's not the set way, but it does what it does in a fraction of a second so it's okay):

declare @rgo int
declare @rmax int
declare @r2go int
declare @r2max int
declare @str varchar(8000)
declare @refarray char(8)
declare @let char(1)
declare @tname varchar(10)

select @refarray = 'abcdefgh'
select @rgo = 1
select @rmax = 8
select @r2go = 1
select @r2max = len(@refarray)



while @rgo <= @rmax
begin
while @r2go <= @r2max
begin
select @let = substring(@refarray,@r2go,1)
select @tname = 'tab'+convert(varchar(length),@rgo)+@let
print(@tname)
select @r2go = @r2go + 1
end
select @rgo = @rgo + 1
end


The only output I get as this stands is:

tab1a..tab1h

Why is the outer loop not executing? Shouldn't I be seeing

tab1a/b/c/d/e/f/g/h through tab8a/b/c/d/e/f/g/h?

Is there something I misunderstand about while loops or just something that's missed my eye? (If the latter, apologies in advance, but I would appreciate any help).

Any advice is much appreciated.

Thanks,

-KS

---

You've not specified length of varchar field while casting. so it will take the default value of 1.

---

quote:

---

Originally posted by Transact Charlie

Know it's kind of a hijack after the problems fixed but if you don't specify a length for VARCHAR in a CAST it will set to whatever the DEFAULT length for a VARCHAR is in your database - not necessarily a length of 1.

It's probably a good idea not to expect a CAST like that to work the same on different databases!

Charlie.

quote:

---

Originally posted by visakh16

quote:

---

Originally posted by KidSQL

Hello, I have the following nested loop (yes I know it's not the set way, but it does what it does in a fraction of a second so it's okay):

declare @rgo int
declare @rmax int
declare @r2go int
declare @r2max int
declare @str varchar(8000)
declare @refarray char(8)
declare @let char(1)
declare @tname varchar(10)

select @refarray = 'abcdefgh'
select @rgo = 1
select @rmax = 8
select @r2go = 1
select @r2max = len(@refarray)



while @rgo <= @rmax
begin
while @r2go <= @r2max
begin
select @let = substring(@refarray,@r2go,1)
select @tname = 'tab'+convert(varchar(length),@rgo)+@let
print(@tname)
select @r2go = @r2go + 1
end
select @rgo = @rgo + 1
end


The only output I get as this stands is:

tab1a..tab1h

Why is the outer loop not executing? Shouldn't I be seeing

tab1a/b/c/d/e/f/g/h through tab8a/b/c/d/e/f/g/h?

Is there something I misunderstand about while loops or just something that's missed my eye? (If the latter, apologies in advance, but I would appreciate any help).

Any advice is much appreciated.

Thanks,

-KS

---

You've not specified length of varchar field while casting. so it will take the default value of 1.

---

-------------
Charlie

---