Search results

How many potatoes does it take to kill an Irishman?

What do you call a prostitute with a runny nose?

Post the SQL and let us help. Is your db contained into one file, split between FRONT END and BACK END - and if so, is the BE still an accdb file?

Hmmm... I did see something along the lines of checking once string character is number, keep reading next string value if numeric, else if last value was numeric, insert pipe | operator, then after reading entire string, replace all non [0-9] characters with " ", then replace " " with "", or...

And i ask because it seemed the most difficult part was determining the last number in its entirety versus being the only number… i don’t have my pc to test anything right now, but as much as this has itched my noggin, you have me just as curious as to the details i was asking about in the post...

Hey Isaac, could you specify the below a little more? Like how are these columns populated, are you populating the columns, are you importing the data into columns, etc…. I guess i ask also because sometimes it seems you have one number or two… i’ll see what i can come up with.. asdf asdf #...

Here is an updated answer that should work for you. And no ambiguity on your part - it is my Friday afternoon brain fog! Reverse was a new one for me. I have never had to use it in T-SQL string manipulation before. DECLARE @stringvalue varchar(max) = 'asdf asdf 2222 # to 744 # asdf asdf asdf'...

If you you mean actual numbers then 1 or 2 would work, if you do mean #'s then 3 or 4. ---EDIT: UNSOLVED.... I need to fix #1 DECLARE @stringvalue varchar(max) = 'asdf asdf 2 # to 74 # asdf asdf asdf' SELECT CASE WHEN PATINDEX('%[0-9]%', @stringvalue) = 0 THEN NULL ELSE...

Some ODBC drivers can also be bit specific. I have to connect to an older IBM database and the only driver my IT could find was 32 bit. When I got a new 64 bit laptop, they gave me 64 bit Office, but I had to change it back to 32 bit Office just to be able to still connect to the IBM db via the...

I do want to say @Isaac that I appreciate your words of wisdom. As far as I am concerned, there is no room for justification of any actions

I'm far from Anti-Israeli.. I have a problem with selective outrage and selective condemnation. War is hell. We should be better. And there is no reason not to be, for the greater good of mankind.

If anyone wants to see the truth - I'll show you what is really going on every day, right here. It is all okay for us to come in here and talk about it, clutch our opinions, converse, go back and forth.... Want to see? If it is okay for us to talk about it openly, it must be okay to see what we...

I mean have you also seen the videos of Israeli's beating on prison walls because they were denied their privilege to ra** the Palestinian prisoners? Or the video of the Israeli soldiers raping Palestinian prisoners behind shields? Disgusting. Israel has dropped more tonnage of bombs on Gaza...

One good use is if you have a lot of SQL database changes to make. Rather than hardcoding table names in a script, you can have the names of the objects in a table, and then iterate through to perform whatever truncate, copy, call sp's, etc. for each object name value in the table.

Understood. I hope this didn't come across as needing to be posted in Site Complaints instead of Site Suggestions - I only asked out of curiosity, and maybe I shouldn't even be asking this question here. It is almost like searching inside a database on your local machine from windows explorer...

I just started using that bookmark feature yesterday. That should come in handy. And @The_Doc_Man that explains it perfectly. I was just curious and have no idea how forum software such as Xenforo works. At first thought it seemed it would be easier to search all of our internal text versus an...

Hey AWF, Do we include attachment & inserted tagged code in our site searches, and if not, is it possible? I've been trying to search things on this site for the last month or two, who knows, one month feels like two months and then the next thing that you know, two months go by and it is only...

Have you tried changing the sourceobject for the subform on frm_Main? You could have a hidden unbound text box on your frm_Main and set the value of it with the subform button click and then with the frm_ProductHoldData open/load event you could filter the recordsource with the text box value...

That color was because it thought the code was SASS, just noticed the tag and fixed. This is real people and stations - There is crosstraining/station rotation throughout the day, but in some cases an associate is fixed to the 1 station for the entire shift, and other stations will all rotate...

Hey AWF, I'm wondering how I can cycle through a set number of lets say 10 seats numbered 1-10, with 10 alphabetic names of A:J, and they are left to right. In this case, people will shift a seat to the right, but not everyone, and I need to record their new seat number. Is there an efficient...