Search results for query: *

I understand enough to get by for now, but I have a lot of reading to do and testing other things out. I know it's for work but I find this kind of stuff super fun. (My co-workers think I'm a weirdo for that LOL) I appreciate the help and the tips on where to find explanations on the functions...

Thank you so much for this!

Case is not important for this report, everything is in all caps. Yep, I am open to any help.

Hi Andrzejek, no I need an exact match on the BPL code. It would be nice to have "found", "not found" but not imperative.

Hi, I have a list of codes in one cell separated by comma's. I have to compare another cell to see if that value exists. I've tried using the Vlookup formula but it doesn't work. I need to compare BPL to PROC to make sure the BPL codes are in the PROC column. PROC BPL AAC, AK...

Thanks Combo, I appreciate that link!

I keep getting a compile error: User-defined type not defined.

Hi, Yep, I just got this back because it didn't work exactly the way expected. It is duplicating verbiage if the number of rows being combined is more than 3.

Thank you so much, this worked perfectly. You just saved me a gazillion hours of tedious work! Deana

Hi, The report didn't come with the empty rows between each codes. I added the separate rows between codes so I could see the descriptions for each code easier. I can't copy and paste because I can't get on tek tips from my work computer and I can't send anything to my personal email. I've added...

Hi, I received an excel report with codes and descriptions. The codes and descriptions are in multiple rows. I need to combine all the data descriptions for each code into 1 cell for the corresponding code. The number of rows per code is variable. There are no duplicate codes. I tried to use a...

Thanks kray4660 that worked perfectly.

Whoops yep that was a typo (fixed below). In the description field I have a description and a 3 digit code at the end. The characters in that field are variable and I only need the 3 digit code. SELECT RTRIM(RIGHT(CSCS_DESC,3)) FROM CSCS_TABLE Example of data in field. Utah - 216 Alaska -...

Hi, I am trying to pull a query to get the right 3 characters in a field. I need to right trim the field first. What I wrote is not working. It returns blanks. I would appreciate any help with this. I've tried several variations of rtrim and right string to no avail. I eventually want to update...

Hi TamarGranor, It was difficult to try and clearly state what I needed. I finally figured this out! It seems a bit convoluted and I'm sure there would have been an easier way to complete what I needed to do but this worked. I ended up using MAX(ceip_term_dt) in the select statement with the...

Hi, I am having a problem trying to figure out how to write a query to get the results I need. I need to see both the IPCD and IPCD2 codes as there can be several different IPCD2 codes associated with one IPCD. There are also several generations which is where I having a problem. I don't want to...

Hi Olaf, I am actually using the File > Save As,(I'm a mouse person). I thought maybe it might be a setting with the new SSMS Tools. This didn't happen before it was installed. Thanks Deana

Hi Everyone, I just had SSMS Tools installed on my laptop. Now when I open an existing query modify it for a different client and then save as to a different location it is saving the changes over the original query as well. Has anyone else had this issue or know how to fix it? Thanks Deana

Hahaha you are a riot! Thanks so much for your help. [smile]

Hi Andrzejek, If I could give you a million stars for this, I would!!! This is exactly what I needed and it works perfectly. I just inherited this process a few days ago and it is a bit convoluted right now. However, both the quarter 2 and 3 updates are past due so I needed to do it the way I...