Viewing 15 posts - 6,301 through 6,315 (of 7,636 total)
graham cleverly (7/14/2008)
July 14, 2008 at 8:54 am
Hmmm, your question and the title of this post seem to have nothing to do with each other.
But OK, "Solid State Disks" is an archaic term for a physical device...
July 13, 2008 at 6:26 pm
Here you go:
Create proc spTable_LoadDynamic (@TableName as sysname, @hdr as varchar(max), @data as varchar(max)) as
/*
Dynamically load a table from a reformatted Excel export file.
13-July-2008, RBarryYoung
Test script:
declare @headers as varchar(max),...
July 13, 2008 at 5:48 pm
Jeffrey Williams (7/13/2008)
Hi, I posted a solution on Friday - but I guess I took too long writing it up and it was lost.
This happens to all of us from...
July 13, 2008 at 5:19 pm
You need to go back to whoever you bought it from and get the license key from them.
July 13, 2008 at 5:02 pm
Thanks, Christian, that was helpful.
July 13, 2008 at 11:33 am
Try MAX(Cast(textfield as varchar(max))
July 13, 2008 at 6:44 am
There is also a massive project planning document free from Microsoft on this very thing. You can find it here: http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx
And of course, there are many consultants here who...
July 13, 2008 at 6:37 am
Gosh, I was wondering where all the MS-haters had gotten too.
July 13, 2008 at 6:27 am
Jeff Moden (7/12/2008)
It's like, I wonder how many people know what a "Dog and Pony Show" really is?
Many years ago I actually asked some executives at the one of the...
July 12, 2008 at 6:31 pm
Steve Jones - Editor (7/12/2008)
July 12, 2008 at 5:06 pm
I''d be happy to help if you would answer my question: How should I determine the data-types? Should I just set everything to varchar?
July 12, 2008 at 5:02 pm
Jeff Moden (7/12/2008)
SELECT yada-yadaFROM sometable1, sometable2, sometable3
WHERE sometable1.somecol *= sometable2.somecol --Left Outer Join
AND sometable1.somecol = sometable3.somecol --Inner Join
Right, now...
July 12, 2008 at 4:58 pm
Is that the right site? It doesnt seem to have anything to do with my questions?
July 12, 2008 at 4:40 pm
I agree, Jeff. Pivot & Unpivot are extraordinarily difficult to use and read.
July 11, 2008 at 10:17 pm
Viewing 15 posts - 6,301 through 6,315 (of 7,636 total)