That was it. Thank you

This should work.

Any reason you are not doing this calc in SQL ?

=DATEADD(DateInterval.Year, -1, (DateAdd(DateInterval.Month, -1, DateSerial(Year(Now), Month(Now), 1))))

Hello gents,

So I started researching the Convert and Bitwise. Very interesting stuff. I also ran into another issue. Not all row colors go good with black text.

So I used more...

mister.magoo (3/15/2015)

---

While all this Bit Bobbling, and Digit Dicing is fun and groovy :cool:, isn't the problem that you are storing your RGB values as a CSV string?

If they were...

That Bit Bash is sweet! Wow, so cool. I'm not sure why this is exciting but it is. 😀

I searched things like

Convert RGB to Hex color TSQL

RGB column stored as INT how to convert tsql

RGB to hex code SQL

Hex to RGB sql

Convert int rgb to hex SQL

Stuff...

Thanks again Jeff , "Jefe el Sql ",

I ran both convert codes and on my limited test data (1,000 rows) they were both uber fast. Not even a 1 ms.

The...

Holy smokes Batman

That is awesome Erik!

I can put that directly into the code and this makes it where I don't have to install any other objects beside my SP.

Just put...

I am currently building the report with my test data. Its small so my original function is working well but wont on larger data sets. The stuff you pointed out...

Wow Jeff you always amaze!

Just blown away 😀

I was trying to figure out a efficient solution. I found this Scalar Function online it use the INT version...

I also have the color stored as a Int

So I have either this format 255,255,224 or 14745599

Yes sir,

Did I say it wrong on what data type it should be?

Sean,

Thank you so much. This did work and provided my solution to a very hard to understand table structure and requested query I was dealing with. I have incorporated...

If I understand you needs correctly what about this. create table #test_table

(KW varchar(100),LP varchar(100))

insert into #test_table

select 'cat' as KW, '/catpage' as LP

insert into #test_table

select 'bigcat' as KW, '/catpage' as...

Thanks so much for the explanation the pattern you mentioned is something I noticed but until you explained it I did not know why it was occurring. I really want...