Search results for query: *

First, let me preface this by saying that I haven't done any VBA coding in more than a decade, so I'm pretty much flying blind (or working from some very faint memories). I've been searching around for ideas on this, but most of what I've found is either close (moves the duplicates but not the...

Hoping this is the right forum for this question. I'm trying to come up with a formula to delete all characters after the last occurrence of a delimiter, but I keep getting stuck. I have something to work with text after a delimiter, but ran into a problem when the string contained in more...

First off, for the record, I am not a vba coder. I've taught myself enough over the years to be dangerous, but since I only need to script things once in a blue moon, have never had any official instruction. That said, I'm trying to automate saving an Excel file as PDF using the Acrobat...

Ok, first off I'm starting this in the Access forum as I'd just assume be able to do it locally rather than having to go through our DBA to create something on the SQL Server to work with. However, given the nature of what I'm trying to achieve (which I'm not even sure is remotely possible at...

Ok, this is mostly just a self educational project, but I'm trying to see if this could be streamlined. The field this is reporting on contains 3 statuses, 0,1, and 2 for not started, incomplete, and complete respectively. The idea is to output a count/total % style number for each. So the...

This is a bit odd to explain, but I'm looking to find records that have a one field that's duplicated, while a second field is different. It's proprietary data, so I can't post the exact thing, but here's an example: EmpID EmpName IncidentID 111 Bob Smith 123 111 Bob Smith...

Ok, considering the approaching holiday and severe braincramping as a side effect, I'm stuck on what I thought would be a very simple query. The table stores EmployeeID, EvalID, CompletionDate. I need to pull the record for each employee's latest completion date. i.e. if each employee has 4...

Ok, first off, hopefully this will be at least understandable - medication has my head swimming right now. Second, if this is really simple, it's the drugs making me miss it. :) Basically, I have a table (SQL 2000, not 2005) with a parent/child structure for three levels. Something like...

Ok, first off, I've not really worked much with Crystal in many many moons. However, my new job does require maintaining and updating some Crystal 9 designed reports. The one I'm working on at present places a graph below a can grow text box. In order to keep them closely aligned, the report...

I'm trying to track something down, but I'm not sure where to look. Basically, starting yesterday, any time I create a stored proc on any db on the server, it gets created as System instead of User. I've tried creating from QA and EM with the same result. Additionally, while QA will accept...

I have what should be a simple query to do, but for the life of me I'm stuck. Dealing with a data import from a client who converted their ID String from numeric to 6 digit numeric. (ie... record with id of 3841 is now 003841) I won't go into all the bs details of why we can't just redo the...

Ok, it may be just a bad day and my brain is offline, but this seems like it should be pretty simple, yet I'm stuck. Table contains EmployeeID and SupervisorID. I need a query to list each EmployeeID, then whether or not they also appear as a Supervisor. I've tried a dozen different ways to...

Been digging around, but can't get this to work, and I'm not sure if it's possible this way. I'm trying to add a Case to the IN Clause. The problem is in this case it needs to be a list. I may be missing something obvious here, but there's the basic idea: DECLARE @Var INT SET @Var = 1...

Ok, first off I've never had any asp/vbscript training, just go on what I picked up by hand, so if this is standard, it's just one I never encountered before. Will having a comment in the middle of an IF statement (before the THEN) cause an error? This was the original code. If (args.Step =...

Tried searching on this, but didn't get any hits. Is there a way to list the databases that the current user has access to? Back story. I was asked to create a script that runs some logic aginst all databases (used Name from Master.sysdatabases). However, they didn't really mean all...

For some reason, I have what should be a simple query giving me some serious fits. Using example table #Steps as follows Item Step Review 1 Review 2 Review 4 YearEnd 1 YearEnd 3 YearEnd 4 Is there a way I could pull a list of each Item, Each Step, and a count of how...

Ok, this one is going to be hard to describe properly, and as it's some client confidential stuff in the query I can't just post it direct. So here's the summary. I have a query that is used by an ASP page to provide a report for a client. Due to some filtering they're asking for, I needed to...

I'm thinking there's no easy way around this, but figured it's worth a try. I have a table PerfPeriods with two fields, EmpID INT and Periods varchar. Periods contains a comma seperated list. EmpID Periods 1 1,2 2 2,4 Is there any way to join this to another...

Ok, given the long day, I may be missing something obvious here, but a co-worker just showed me a table where a column, defined as smallint had a row with a value that was text, specifically a sentence. Is there any way whatsoever this would be possible? I thought that even if the field was...

Ok, the non-sql expert in me just inherited a new "problem query" that was causing major load issues and taking quite a while to run. Basically it's a logon usage by interval report, showing the number of employees that logged on in each interval (currently 1 day). When run for small ranges...