Recent content by thefrstgatsby

Is there any way of turning off the feature in xp and oulook xp, where the menu items that aren't used as frequently are hidden by those two little arrows at the bottom of the menu?

I have a new computer (well used) Which was debranded, for whatever "reasons". Anyways I need to find out the make of the hardware devices. Does anyone know of any utilities that can detect device brands for which there were no device drivers that matched the hardware in the device manager?

Thanks, stupid thing is, I had that problem on my computer and knew it to be the cause, but I forgot I had mapped a drive on her computer. :-(

For some reason, when I open a file in Excel, or Word, as soon as I use the pull down (look under) menu, the program freezes for a while, then the pulldown will finally "pulldown" with the directories. Any ideas on why this might be happening? I'm using windows xp, and office 2003

so my syntax is correct then?

thanks, I figured as much, one more question though, let's say I want to join one table to another, but the second table is a compound key. in order to join it and avoid duplication, is this the proper syntax? table a INNER JOIN table b ON a.col1 = b.col1 and a.col2 = b.col2 or does the inner...

k, that part of the problem is already solved, the real issue is where I say when it returns the value for a row, if for example I have a column in the Not doing business Anymore table called "reason", it will copy that reason over any row associated with that record. So let's say there was a...

I think that the problem will still exist, I'm getting the correct amount of records, but the reason column values are being placed into the the transaction record results as well. The reason column doesn't actually exist in the transaction record, so it should say 'NULL' in those cases.

The first part of this message is a repost which was already answered, but after we decided the problem was solved, I realized there was one more thing that I need help on. So the question is at the bottom since the backstory to this is needed to understand. Clients (table A)...

One last thing, when it returns the value for for a row, if for example I have a column in the Not doing business Anymore table called "reason", it will copy that reason over any row associated with that record. So let's say there was a transaction record for joe and mary under the transaction...

In addition to my reply I have one more question, are JOIN and INNER JOIN the same thing?

Great, I did this and wasn't sure if it was right, so this should return the not doing business records as well as the transaction records?

I have a sql database, and I'm trying to pull records from tables a main table related to to other tables, where records from those two tables must be in another table as well. Here is a diagram Clients (table A) Service Prov (table b) Name Transaction IDc...

I've checked the website, do you know where on it they are? I was unable to find it in the downloads section.

Also, for the variables that I declare for the function: @money and @name if one of them is a unique identifier, does that change anything, or do I just declare it as CREATE FUNCTION fnGetCars (@Name uniqueidentifier(100)) ?