Search results for query: *

I'm looking for an ASP (VBScript) equivalent to the SQL IN operator. I have an IF statement and I need to check if the value I'm considering is equal to any value in a lengthy group of values. Plus, this group of values is dynamic. So I just want to throw this group and my number and see if my...

Hey folks, Just aquired a company and we've got some data of theirs in an MS Access table. The ID is a text field containing Alpha/Numeric data which really follows now concrete formula (some are two alpha followed by two numeric, some are four alpha followed by one numeric, etc.) All we...

DBomrrsm, At first glance, that appears to be the ticket. It appears that I was close ... or, at least, generally headed in the right direction with my attempt. But, again, thank you for your assistance. Haybails90

Hey there folks, I'm having trouble wrapping my brain around this one. I've inherited a database from a previous (no longer employeed here - LOL) developer which has data spread across multiple tables and is not very normalized. We'll be doing a database restructure to cure this...

OHHHHHHH! Hey, I might be on to something here. The previous developer, whom I replaced four months ago, named this database with a period (to reflect the name of the web site it's for) ... for example, "websitename.com" is the name of the database. Could this be causing the problem? And if so...

Hey dbomrrsm, Thanx for jumping on board here ... I'm initially testing this on my developement machine. So, I'm using Microsoft SQL Enterprise Manager Version 8.0. on an XP Pro machine. I right click on the table, hover over 'All Tasks' and select 'Import Data ...'. This...

Hey there SQL Gurus! I have a .cvs file containing some sales data. I'm trying to pump this into an already existing table in my database. I go through the DTS setup; when I get to the 'Select Source Tables and Views' section I click on the Transform button. Up pops the 'Column Mappings...

Swampboogie and SQLSister, Thank you both for your assistance. This was/is exactly what I was/am looking for. In all honesty, the statement I was writing was headed in the exact direction of Swampboogies statement, I guess I was just a little 'gun shy' on actually running it. <G>...

SQLSister, What I'm looking for is some sort of statement which does the following (in poorly written pseudo code): 1.) step through every record of the employees table. 2.) for each record in the employees table, grab the AutoID 3.) Look at the groups_members table and see if a record...

SQLSister, Thank you for your speedy reply. Unfortunately <BIG BLUSH> you've lost me already. I understand the need for an insert trigger on the employees table for newly created employee records (I'll get to that later today) ... but, for now, all I need is a statement which will...

Hey Folks, I'm here to request some assistance in creating a statement. I have two tables: * groups_members -- a Cross Referencing table consisting of only two fields - GroupID (referencing a record in a 'groups' table) and EmpAutoID (referencing a record in an 'employees' table)...

Well, I got it to work. I went ahead and booted from the PartitionMagic CD and did the resizing there. All worked well. As a side story though, let me tell you about how nervous I was (LOL), I forgot to do a system backup (you know, just in case). I've got a coding project I've been working on...

Hey folks, I'm trying to use PartitionMagic 8.0 to redistribute some free space on my laptop. Windows XP Pro on a Sony Vaio (or, however you spell it - worst damn logo in history in my opinion, I mean, you can't even read it! LOL). Any way, I go through the wizard to redistribute the free...

Would it be rediculous to do it like this: LEFT(RIGHT(Str(job_nbr),6),1) This would give me the sixth numeral from the right end of the job number. Haybails90

donutman, My superior and I were just discussing this (by the way, I REALLY HATE, with a passion might I add, the developer whom I replaced - LOL). So, now I'll be needing to come from the other end - I.E. the right end of the string back towards the front/left.

LOL!! vongrunt - you just caught me!! I just stumbled upon this exact issue with my data. Is there a way to count 'backwards' from the end of the string? Haybails90

Sorry, I just figured it out by myself. I completely forgot about one of the most basic functions - LOL. My only defense is "Monday Madness". Here's what I did: SubString(Str(employees.job_nbr), 4, 1) = '1' Sorry, again, for the interuption; now, GET BACK TO WORK!!! <G> Haybails90

This will be SQL code in an ASP page and I test it in Query Analyzer.

Um ... huh?

Hey there SQL Pros, I'm looking for some assistance on my SQL coding. I'm looking for a SQL solution to the following scenario: I'd like to use something similar to SubString but on an INT value. For example, let's say the INT value is 123457890, I need a way to check, say, the fifth...