SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Need to alter my code to show limited Info


Need to alter my code to show limited Info

Author
Message
lisa.ogle
lisa.ogle
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 22
And My Thanks is to Luis C he was very helpful without being Condescending! :-)
Luis Cazares
Luis Cazares
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16204 Visits: 19059
I agree with Sean, even if I don't know Erland, his reputation and answers in a short time in this site say a lot about him and his expertise and willingness to help.
The three of us suggested you the same thing to get better help (Sean and I in an article and Erland with a direct post).
I'm glad that you considered my posts as helpful, but I couldn't help you any further without more information.
I hope that you continue to visit this site and learn as we all do in here. ;-)


Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?


How to post data/code on a forum to get the best help: Option 1 / Option 2
pietlinden
pietlinden
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4775 Visits: 13132
he wasn't being snarky or anything like that.

he was just trying to point out that you need to provide enough information for the people here to understand your problem (your table structures and some data). Without that, all people here can do is guess at a solution. On the other hand, if you provide enough information, you can get some great (and quick) answers.

Basically, make it as easy as possible to understand and recreate your scenario. Then other people can see what you see. And then they can help. Without that, they really can't.
Erland Sommarskog
Erland Sommarskog
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2093 Visits: 872
lisa.ogle (9/6/2013)
Thats fine but we all have to learn somewhere and Im guessing you all were not born with the ability to do SQL. I am thinking you too had to learn somewhere.


No one is blaming you for not knowing SQL. These forums exists exactly for people who need help with SQL.

However, remember that people here help you in their free time. We are not paid to help you, nor do you pay us. And in order to help you, we are very much reliant on the information you give us.

And, it is very frustrating when you want to help someone, but the person only says "I still get an error", but do not show us the query, nor the error message.

As for asking data as INSERT statement and not in Excel book. Sure, I can construct INSERT statements myself. But that's a kind of boring job, and since I do this for free, I rather concentrating on the fun part. And, I will have to admit, I do appreciate when the person asking for help also makes an effort.

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
lisa.ogle
lisa.ogle
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 22
Again I did provide the code I did provide the error and I did attach a sample of the data that was returned. Please remove me from your forum. My point was I did attach all that was requested and needed. Sorry that you did not see that I still see it myself in this thread. I thought it was rude and condescending for you to assume I thought you were Psychics-- I did not think that at all I merely asked for assistance and was dealt with what I thought and still do think was a sarcastic return. I was able to figure it out myself. Therefore I consider the matter closed I know not to ask anything on this forum again and in fact tried to disable my account feel free to do that for me if you like.
Sean Lange
Sean Lange
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25803 Visits: 17509
lisa.ogle (9/6/2013)
Again I did provide the code I did provide the error and I did attach a sample of the data that was returned. Please remove me from your forum. My point was I did attach all that was requested and needed. Sorry that you did not see that I still see it myself in this thread. I thought it was rude and condescending for you to assume I thought you were Psychics-- I did not think that at all I merely asked for assistance and was dealt with what I thought and still do think was a sarcastic return. I was able to figure it out myself. Therefore I consider the matter closed I know not to ask anything on this forum again and in fact tried to disable my account feel free to do that for me if you like.


Lisa, I am certain this whole issue is a misunderstanding caused by the fact that as humans we cannot hear inflection in the written language. I don't know Erland personally but I have been reading his articles about SQL server for a long time. I can't speak for him but I do not think he meant to be rude.

I truly hope you do not walk away from this site after having a single response that was interpreted in a way that made you mad. This site is truly unique and we try very hard to not have the arrogance and condescension that is so persistent on other forums. I can understand being irritated. I would suggest that if nothing else you signup for the daily newsletter and attempt the question of the day. The knowledge you can learn just from those is staggering.

_______________________________________________________________

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.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search