Viewing 15 posts - 2,701 through 2,715 (of 2,766 total)
Man, this would make for a good T-SQL challenge!
Now I'm really determined to figure this out!
December 29, 2009 at 11:44 am
Justin James (12/29/2009)
As I looked through my data further (what I provided was just a subset), I see that the grouping of information change throughout it. 🙁
Argh! My model...
December 29, 2009 at 11:08 am
Steve Jones - Editor (12/29/2009)
Just got my email about the new season this morning for the old man's league. We report in 4.5 weeks!
Nice! I wish I could play...
December 29, 2009 at 11:00 am
lobbymuncher (12/29/2009)
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,
...
December 29, 2009 at 10:42 am
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,...
December 29, 2009 at 9:02 am
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...
December 29, 2009 at 8:30 am
Only . . .
select cast(datediff(d, getdate(), '2/17/2010') as char(2)) + ' days' . . . until pitchers and catchers report! 😀
December 29, 2009 at 7:11 am
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.
December 29, 2009 at 7:03 am
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...
December 28, 2009 at 2:20 pm
Did you read BOL like I suggested? (Not trying to dance around the answer -- just trying to encourage you to look it up and figure it out on...
December 28, 2009 at 2:05 pm
pleasehelpme (12/23/2009)
Should I have 2 entities, one for stores and one for receipts? Or should I just have one entity called stores and stored everything in there.
It depends. How...
December 28, 2009 at 12:17 pm
99posts (12/28/2009)
use a select statement; how do you make this44.8730084
into this
44.8 %
BTW, 44.873 would round to 44.9, not 44.8 (this is the math guy in me coming out here)...
December 28, 2009 at 11:41 am
Go to BOL and look up numeric data types . . .
December 28, 2009 at 11:38 am
tknight (12/24/2009)
The Yankees are like Microsoft. A right-thinking person does not root for them, he accepts them.
Hey, as I tell my wife (who is a devoted Mac person): "I...
December 28, 2009 at 7:09 am
Viewing 15 posts - 2,701 through 2,715 (of 2,766 total)