My concern is that use of GenAI is causing people to not think. Even cell phones cause issues... how many people do not remember a frequently called phone number because...

• This reply was modified 3 months, 3 weeks ago by DB_Newbie2007.
• This reply was modified 3 months, 3 weeks ago by DB_Newbie2007.

Sorry, I appreciate everyone's help.

Is there a way to delete this post?

Can you provide the relevant table structure and an insert statement that fails?

LOL... love seeing people ask for that. Unfortunately, this is proprietary so we cannot. I was hoping someone...

Thanks for the suggestion!

Looking at the incoming data, the biggest field coming in was 4 characters, so we did change a replica table to be varchar(4). While that removed the...

I was about to post the same comment but looks like Thomas beat me to it...

That...

Phil Parkin wrote:

I use a lot of apps, but don't like clutter.

I totally agree!!!!

I use to use a DELL U3417W (34-inch curved) but "donated" it to another peer after it...

• This reply was modified 1 year, 4 months ago by DB_Newbie2007.
• This reply was modified 1 year, 4 months ago by DB_Newbie2007.

Typically only update SSMS when we update the actual SQL version. Most of the users have 19.3 but there are still a few 18.x instances around here...

That does suggest a permissions problem.

Yes... that is what I am thinking... but just have not figured out what/how. I posted here as we could not figure this out, so...

I like, in general, ingimas, as I feel they help us learn and grow (and, for myself, the greater the challenge the more I dig my heals in to try...

• This reply was modified 1 year, 6 months ago by DB_Newbie2007.

Somehow you left out the "SET @MyBit = 0" on one function?

No... all the functions come from a central location.

Strange part, if I script out the function and just execute...

• This reply was modified 1 year, 6 months ago by DB_Newbie2007.
• This reply was modified 1 year, 6 months ago by DB_Newbie2007.
• This reply was modified 1 year, 6 months ago by DB_Newbie2007.

Thanks for all of the replies.

Unfortunately, we have little control over the format of  the date field, since it is coming from a large international vendor's invoicing system. In the...

Lordy.  Thanks for the feedback on that.  It's very timely as I was going to actually try column store on a table or two and then put them into production. ...

If the source definition for the column is varchar(20) - why are you trying to force that into a char(6) column? 

Long story... but in a nutshell, the "source" table...

Jeff,

Thanks for the update. For the initial problem, we spent over 5 hours trying to look at the data to figure out what was going wrong.

• Len() and DataLength()

• Different...