Tally table really great ...

GSquared (1/5/2010)

---

(Looks like a test/homework problem to me.)

Are you familiar with the string functions in T-SQL? Looks to me like you could resolve this with Len, Right, and a...

tq for the info.

tq mr lynn

Sharul Nizam (11/21/2009)

---

My statement as follow,

create table tStrRndm

(

BoardCd varchar(6) -- this is a unique

)

DECLARE @myString AS varchar(50)

SET @myString= '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'

DECLARE @gStrRndm as varchar(6)

1. I'm looking a solution to build a T-SQL...

Article shown by Dave, give me a hope.

thanks for the guide.

me still develop the T-SQL

Just saw your great article.

How to make it random string in...

1. Me just want to see, Stored Procedure...

Florian Reischl (11/14/2009)

---

Hi

First, to pay my bill for entering this thread 😀

SELECT

CONVERT(CHAR(6), DATEADD(MONTH, -1, CONVERT(DATETIME, @yyyymm + '01', 112)), 112)

,CONVERT(CHAR(6), DATEADD(MONTH, 1, CONVERT(DATETIME, @yyyymm...

Jeff Moden (11/14/2009)

---

Just another slant on this...

declare @yyyymm as varchar(6)

set @yyyymm='200901'

SELECT CONVERT(CHAR(6),CAST(@yyyymm+'01' AS DATETIME) -1,112) AS [Prev yyyymm],

CONVERT(CHAR(6),CAST(@yyyymm+'01' AS DATETIME)+32,112) AS...

tq very much sir

tq very much sir lmu92

Kindest Matt Wilhoite,

Your direction give me an accurate resultset. 😀

TQVM.

Matt Wilhoite (11/9/2009)

---

Well, I have already done a loop and thats just a nicer word for cursor. I don't have access to a test environment right now but I...