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 7 months, 2 weeks ago by  DB_Newbie2007.
• This reply was modified 7 months, 2 weeks 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 10 months, 1 week 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 10 months, 1 week ago by  DB_Newbie2007.
• This reply was modified 10 months, 1 week ago by  DB_Newbie2007.
• This reply was modified 10 months, 1 week 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...

Jonathan,

Thanks for the suggestion. We did think of that early on and tried a few different combinations, i.e.,

AccountNo LIKE '%[^a-zA-Z0-9]%'
AccountNo LIKE '%'+CHAR(13)+'%' OR AccountNo LIKE '%'+CHAR(10)+'%' ...

We just discovered another process that is having a similar issue. It appears to be where the field size in the "source" table (which contains the non-clustered columnstore index) is...

• This reply was modified 4 years, 8 months ago by  DB_Newbie2007.
• This reply was modified 4 years, 8 months ago by  DB_Newbie2007.

Its not just the data but how the data is used and the mathematical models they help to create. I suggest reading the book Weapons of Math Destruction by...

Thanks immensely, Steve! I sent the information to our development team so they can make the appropriate modifications to our table(s) and code. 

 I love surprises but *not* "gotchas"....