LOL!!!!!!!!!!!!!!!!

I suspect there are many people (myself included) who share your sentiment!!!

Hmmm . . . there's a function called CHAR that might be what you're asking about. (Not sure if this is what you need, but what the heck.)

What...

Ach du Lieber, ich habe meine Deutsch nicht üben! (I hope I said that right!)

Off the top of my head, I'd suggest checking the collation settings.

I see the Mess . . . uhh, Mets got Jason Bay . . .

I'm not having much luck with this, but here's where I'm going with it.

Using the @school table that we defined earlier, I started with this query:

select ID, row_number() over (order...

Which is why I'm making every effort to avoid RBAR. (If I was coding this in VB.NET or something similar, I'd...

Man, this would make for a good T-SQL challenge!

Now I'm really determined to figure this out!

Argh! My model...

Nice! I wish I could play...

lobbymuncher (12/29/2009)

---

;WITH CTE1 AS (

SELECT ((UniqueID-1)/6)+1 AS CourseBlock, [ID], ColumnName, [Text]

FROM YourTable

),

CTE2 AS (

SELECT CourseBlock,

ROW_NUMBER() OVER(PARTITION BY CourseBlock ORDER BY [ID]) AS CourseElement,

...

Thanks . . . actually, what I was looking for was this (I'm posting this here for anyone else who wants to try this problem):

declare @school table ([ID] int,...

I'd like to take a crack at this. Can you put your data into an actual text format (not an image) so I can try it out? (It'd...

Only . . .

select cast(datediff(d, getdate(), '2/17/2010') as char(2)) + ' days' . . . until pitchers and catchers report! 😀

Farbeit for me to encourage a cross-post, but you'll probably get a better answer if you ask this in the SQL 2000 forum, rather than the SQL 2008 forum.

If you're trying to convert from a table, try playing with this example:

declare @temp table(thisval float)

insert into @temp values (23.61)

insert into @temp values (1234.13456143)

insert into @temp values (100.00001)

insert into @temp...