Viewing 15 posts - 2,746 through 2,760 (of 2,769 total)
One of us usually ends up sleeping on the couch! 🙂
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 2:18 pm
CirquedeSQLeil (12/16/2009)
Now we need a database like that for basketball.
I'd be surprised if there isn't one out there somewhere. I actually found the baseball database by doing a Google...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 2:09 pm
Yeah, lifelong upstate New Yorker here.
It also occurred to me that maybe this thread does have something to do with SQL. One of the things I've been doing with...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 1:25 pm
if you want to upgrade your MCAD remember to take the two exam upgrade because the one exam upgrade comes with more than 90 percent fail rate.
Yikes!!! That's good...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 12:22 pm
I just remembered something . . .
VARCHAR(MAX) is equivalent to the TEXT type in SQL Server. You should change the column type to TEXT. However, Microsoft is depreciating...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 11:54 am
No. What I'm saying is change the destination to VARCHAR(MAX). That would make the column large enough to be handle variable-length character data to whatever the upper limit...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 11:51 am
One other thought (speaking of stray characters): data cleansing is always a good thing. For example, since you're importing from Excel, it's probably using the TAB character as a...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 9:49 am
Sheez . . . that's quite the variety of data.
Here's how I'd tackle it . . .
For the first column, make it a VARCHAR(MAX) column (equivalent to TEXT, which...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 9:44 am
If I'm not mistaken, I believe VARCHAR(MAX) is actually equivalent to the TEXT field type. My understanding is that Microsoft will be phasing out TEXT and replace it with...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 8:26 am
I had a similar problem. In regard to the truncation errors, what I initially did was create a staging table and set all my character fields to TEXT. ...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 16, 2009 at 8:12 am
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab1
Maybe I should try poking around Microsoft's site a bit more! 🙂
Nevertheless, your thoughts are still welcome!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 15, 2009 at 12:10 pm
YO!!!
Just came across this thread!!!
Pianist, clarinetist, and songwriter here!!!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 15, 2009 at 11:14 am
I haven't taken the time to dissect your code, but I did want to write my thoughts when it came to attacking set-based vs. structured programming.
Most traditional structured languages are...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 11, 2009 at 11:09 am
For what it's worth, I come from a structured programming and OOP background myself (mostly VB, VB.NET, ASP.NET, etc.).
But when it comes to SQL and set-based programming, I take a...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 11, 2009 at 7:35 am
You don't give very much information to work with. What do the queries look like? And how big are the data sources?
Give us some detail, and we might...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 10, 2009 at 2:40 pm
Viewing 15 posts - 2,746 through 2,760 (of 2,769 total)