October 3, 2018 at 12:51 pm
jasona.work - Wednesday, October 3, 2018 12:22 PMI can't decide if the posted replies here are just trolling the OP or what: https://www.sqlservercentral.com/Forums/1998406/Automatically-avoid-error-inserting-into-identity-field
Although I think I'm leaning towards trolling...
There are currently 3 replies to the post - they all look like legit answers to me. None of them are quick-n-easy solutions, but they will all work.
October 3, 2018 at 1:04 pm
Chad Crawford - Wednesday, October 3, 2018 12:51 PMjasona.work - Wednesday, October 3, 2018 12:22 PMI can't decide if the posted replies here are just trolling the OP or what: https://www.sqlservercentral.com/Forums/1998406/Automatically-avoid-error-inserting-into-identity-field
Although I think I'm leaning towards trolling...There are currently 3 replies to the post - they all look like legit answers to me. None of them are quick-n-easy solutions, but they will all work.
Nope, you're right, I mis-read the original question, missed the bit about "updating many tables."
Plus, OK, in all honesty I kinda was skimming the answers...
October 3, 2018 at 2:05 pm
jasona.work - Wednesday, October 3, 2018 1:04 PMNope, you're right, I mis-read the original question, missed the bit about "updating many tables."
Plus, OK, in all honesty I kinda was skimming the answers...
The problem is that he was told the same thing yesterday in another thread.
October 3, 2018 at 3:04 pm
Lynn Pettis - Wednesday, October 3, 2018 2:05 PMThe problem is that he was told the same thing yesterday in another thread.
yeah.. but that was a different thread on a different day right??? 😀
October 4, 2018 at 7:59 am
Chris Harshman - Wednesday, October 3, 2018 3:04 PMLynn Pettis - Wednesday, October 3, 2018 2:05 PMThe problem is that he was told the same thing yesterday in another thread.yeah.. but that was a different thread on a different day right??? 😀
Now THAT is a short term memory problem. I thought mine was bad. At least I think I thought it was - I'm not sure now.
October 4, 2018 at 8:09 am
Chad Crawford - Thursday, October 4, 2018 7:59 AMNow THAT is a short term memory problem. I thought mine was bad. At least I think I thought it was - I'm not sure now.
What were you talking about now, Chad?
And are you sure that's what you were talking about? @=)
October 4, 2018 at 8:16 am
OK, the weather is getting really weird around here...
A couple days ago, needed at least a windbreaker going outside.
Yesterday, open windows on the car for the drive home, and opened windows at the house, even left a couple open overnight...
This morning, open lots of windows in the house (work from home day) yet now I'm thinking about going around and closing all the windows as it's cooling down...
:crazy:
AND I just looked at the forecast and they're talking 80s on Saturday???
WTH man?!?!
October 4, 2018 at 8:24 am
jasona.work - Thursday, October 4, 2018 8:16 AMOK, the weather is getting really weird around here...
A couple days ago, needed at least a windbreaker going outside.
Yesterday, open windows on the car for the drive home, and opened windows at the house, even left a couple open overnight...
This morning, open lots of windows in the house (work from home day) yet now I'm thinking about going around and closing all the windows as it's cooling down...
:crazy:AND I just looked at the forecast and they're talking 80s on Saturday???
WTH man?!?!
This sounds like British weather to me. It's either Grey outside, or it literally cannot decide what it wants to be from one hour to the next (late Feb/March was insane this year, went from -10 (Celsius) to low 30's to -5 within the same month).
Chris Harshman - Wednesday, October 3, 2018 3:04 PMLynn Pettis - Wednesday, October 3, 2018 2:05 PMThe problem is that he was told the same thing yesterday in another thread.yeah.. but that was a different thread on a different day right??? 😀
I do wonder if someone people don't subscribe the the topics they create, then when they come back they can't find their topic, they simply post a new one. Of course, the person seems to not be the case, as they have either replied or marked a post as a solution since. :ermm:
I wonder how I would introduce that into my work life. "Oh sorry, I didn't do that work for you because I forgot where I put the database." I'm sure management will be fine with that. :hehe:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 4, 2018 at 8:27 am
jasona.work - Thursday, October 4, 2018 8:16 AMOK, the weather is getting really weird around here...
A couple days ago, needed at least a windbreaker going outside.
Yesterday, open windows on the car for the drive home, and opened windows at the house, even left a couple open overnight...
This morning, open lots of windows in the house (work from home day) yet now I'm thinking about going around and closing all the windows as it's cooling down...
:crazy:AND I just looked at the forecast and they're talking 80s on Saturday???
WTH man?!?!
Yesterday high of 85, today a high of 63, tomorrow into the 90s, saturday high of 61, sunday mid 70s, Monday in the 80s again. SMH.
_______________________________________________________________
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/
October 4, 2018 at 8:28 am
Thom A - Thursday, October 4, 2018 8:24 AMThis sounds like British weather to me. It's either Grey outside, or it literally cannot decide what it wants to be from one hour to the next (late Feb/March was insane this year, went from -10 (Celsius) to low 30's to -5 within the same month).
An old saying around here: "If you don't like the weather, wait 5 minutes and it'll change."
Today is doing it's level best to prove that.
Case in point, I started my work day in shorts and no shirt. Now I'm thinking about throwing on jeans and a shirt (gads I love working from home!)
October 4, 2018 at 8:33 am
jasona.work - Thursday, October 4, 2018 8:28 AMAn old saying around here: "If you don't like the weather, wait 5 minutes and it'll change."
Today is doing it's level best to prove that.
Case in point, I started my work day in shorts and no shirt. Now I'm thinking about throwing on jeans and a shirt (gads I love working from home!)
I have seen all four seasons in the same day here. I am beginning to think mother nature is just not taking her meds for her bi-polar condition.
October 4, 2018 at 8:42 am
Lynn Pettis - Thursday, October 4, 2018 8:33 AMI have seen all four seasons in the same day here. I am beginning to think mother nature is just not taking her meds for her bi-polar condition.
I think the earth is finally getting tired of these pesky humans and has decided to start the next mass extinction. Changes to the earth are very slow but unstoppable.
_______________________________________________________________
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/
October 4, 2018 at 9:44 am
At what point would you suggest that someone is no longer "new to SQL"? Would you suggest that, for example, someone who has been working with SQL Server for at least 2.5 years could still consider themselves "new to SQL"?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 4, 2018 at 9:48 am
Thom A - Thursday, October 4, 2018 9:44 AMAt what point would you suggest that someone is no longer "new to SQL"? Would you suggest that, for example, someone who has been working with SQL Server for at least 2.5 years could still consider themselves "new to SQL"?
I suppose that depends on what they've been working on. For instance, someone who mainly does backups probably isn't experienced enough to write T-SQL. Or someone who only, during that 2.5 years, writes the occasional line of T-SQL (such as a C## dev). On the other hand, if someone's using that line as an excuse to not learn or retain what they've learned definitely needs to stop and woman up.
October 4, 2018 at 9:49 am
Thom A - Thursday, October 4, 2018 9:44 AMAt what point would you suggest that someone is no longer "new to SQL"? Would you suggest that, for example, someone who has been working with SQL Server for at least 2.5 years could still consider themselves "new to SQL"?
Well, if I used the Chief of Operations back at my first duty station while in the Air Force where he actually wanted new computer operators to wear a red "L" for the first six months, six months.
Viewing 15 posts - 62,386 through 62,400 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply