August 11, 2015 at 7:46 am
SQLRNNR (8/11/2015)
GilaMonster (8/11/2015)
And in unrelated news, something of moderate interest might be happening this afternoon/tonight (depending on timezones). Watch twitter.With this kind of tease, you must have decided for a new career in marketing.
Now I am going to be stuck to twitter instead of finishing up those articles, presentations, and that client work.:crazy:
With all the buzz this has generated, I hope you post something here as well.
August 11, 2015 at 8:03 am
The silver spoons need to be ordered again. Better get at least a case.
Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
August 11, 2015 at 8:07 am
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I saw that. "Unfortunately..."????
hmmm :ermm:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 11, 2015 at 8:09 am
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I read that and I continually wonder why you and Lynn both continue to help this person. You guys put in way too much effort trying to help them and in return they put forth no effort, no learning and no details.
The whole quote from that is one of the more pathetic things I have seen. They got your code to work so they reverted to a simpler piece of code that doesn't work. :w00t:
Unfortunately I get your code to work.
Thank you for your script.
I reverted back to a simple script that is not really what I need.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 11, 2015 at 8:15 am
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I read that and I continually wonder why you and Lynn both continue to help this person. You guys put in way too much effort trying to help them and in return they put forth no effort, no learning and no details.
The whole quote from that is one of the more pathetic things I have seen. They got your code to work so they reverted to a simpler piece of code that doesn't work. :w00t:
Unfortunately I get your code to work.
Thank you for your script.
I reverted back to a simple script that is not really what I need.
This is one of the post that lead me, yesterday, to say that some people needs mentors more than they need questions answered on the forum.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 11, 2015 at 8:20 am
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I suspect the word 'can't' was left out by mistake.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2015 at 8:33 am
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I read that and I continually wonder why you and Lynn both continue to help this person. You guys put in way too much effort trying to help them and in return they put forth no effort, no learning and no details.
The whole quote from that is one of the more pathetic things I have seen. They got your code to work so they reverted to a simpler piece of code that doesn't work. :w00t:
Unfortunately I get your code to work.
Thank you for your script.
I reverted back to a simple script that is not really what I need.
I'm starting to wonder the same thing.
August 11, 2015 at 8:45 am
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I read that and I continually wonder why you and Lynn both continue to help this person. You guys put in way too much effort trying to help them and in return they put forth no effort, no learning and no details.
The whole quote from that is one of the more pathetic things I have seen. They got your code to work so they reverted to a simpler piece of code that doesn't work. :w00t:
Unfortunately I get your code to work.
Thank you for your script.
I reverted back to a simple script that is not really what I need.
I'm starting to wonder the same thing.
Would it be ok to suggest he have his boss contact me and I'll do it for a reasonable rate? Now he's asking for an Archive Delete Utility he can purchase.
Weak the force is. 🙁
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 11, 2015 at 8:50 am
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 11, 2015 at 8:51 am
Alvin Ramard (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I read that and I continually wonder why you and Lynn both continue to help this person. You guys put in way too much effort trying to help them and in return they put forth no effort, no learning and no details.
The whole quote from that is one of the more pathetic things I have seen. They got your code to work so they reverted to a simpler piece of code that doesn't work. :w00t:
Unfortunately I get your code to work.
Thank you for your script.
I reverted back to a simple script that is not really what I need.
I'm starting to wonder the same thing.
Would it be ok to suggest he have his boss contact me and I'll do it for a reasonable rate? Now he's asking for an Archive Delete Utility he can purchase.
Weak the force is. 🙁
I don't see why not. I've seen others do the same thing for other posts. Given the level of competence and sense of entitlement displayed thus far, however, I'd be cautious about investing a ton of time when you might not get paid.
BTW, I saw the most recent post, but I'm done.
August 11, 2015 at 8:55 am
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
And your point is? 😀
Depending on the intended use, it may not be so bad, but I see a few problem with the design, such as missing key and use of nvarchar.
It's presence does raise a few warning flags.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 11, 2015 at 8:59 am
Alvin Ramard (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
And your point is? 😀
Depending on the intended use, it may not be so bad, but I see a few problem with the design, such as missing key and use of nvarchar.
It's presence does raise a few warning flags.
I guess I left off that they are also NOT NULL. Why make them variable length when they can't be more or less than 1 character? And repeating columns like that is just awful. Would make more sense to spin them off to another table.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 11, 2015 at 9:04 am
Sean Lange (8/11/2015)
Alvin Ramard (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
And your point is? 😀
Depending on the intended use, it may not be so bad, but I see a few problem with the design, such as missing key and use of nvarchar.
It's presence does raise a few warning flags.
I guess I left off that they are also NOT NULL. Why make them variable length when they can't be more or less than 1 character? And repeating columns like that is just awful. Would make more sense to spin them off to another table.
I'm guessing the table is intended for clients to implement some sore of customization. One character fields might be ok, but nvarchar instead of varchar? hmmm
Unless the table is only going to have 1 row, where's the key column?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 11, 2015 at 9:06 am
Alvin Ramard (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I read that and I continually wonder why you and Lynn both continue to help this person. You guys put in way too much effort trying to help them and in return they put forth no effort, no learning and no details.
The whole quote from that is one of the more pathetic things I have seen. They got your code to work so they reverted to a simpler piece of code that doesn't work. :w00t:
Unfortunately I get your code to work.
Thank you for your script.
I reverted back to a simple script that is not really what I need.
I'm starting to wonder the same thing.
Would it be ok to suggest he have his boss contact me and I'll do it for a reasonable rate? Now he's asking for an Archive Delete Utility he can purchase.
Weak the force is. 🙁
I was going to suggest something similar. Have his boss contact me with a false promise of doing it for free, just to note the incompetence from this person that seems to keep his job by the effort of this community.
August 11, 2015 at 9:09 am
Alvin Ramard (8/11/2015)
Sean Lange (8/11/2015)
Alvin Ramard (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
And your point is? 😀
Depending on the intended use, it may not be so bad, but I see a few problem with the design, such as missing key and use of nvarchar.
It's presence does raise a few warning flags.
I guess I left off that they are also NOT NULL. Why make them variable length when they can't be more or less than 1 character? And repeating columns like that is just awful. Would make more sense to spin them off to another table.
I'm guessing the table is intended for clients to implement some sore of customization. One character fields might be ok, but nvarchar instead of varchar? hmmm
Unless the table is only going to have 1 row, where's the key column?
Those 50 columns aren't the whole table. There is a perfectly solid looking table with these 50 columns slapped onto the end. Just seems like such an afterthought, or perhaps a non-thought, that these exist in this table. Sure hope they don't need a ATTRIBUTE51 anytime soon.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 50,026 through 50,040 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply