excuse me while I hang my head in shame,

just a note for everyone out there.........

MAKE SURE YOU DETACH THE DATABASE!!!!

Thank you,

my self flagellation has ceased

Hi,

You have asked a complex question.  From the SQL server part your data is stored as an Image datatype.  Now Image does not mean picture it means any Blob Data.

How...

Mikey,

NP i understand how posts are misinterpreted.  I never allow SQL queries against my data from the client. 

I guess I always think that every query is inside of a...

hi, I am Guessing that you want to ad a counter at querytime that lists the number of the employees because you have said "add a column to the recordset" If...

michael,

I fully inderstand how to use the single quotes and double quotes,  Cleech however had missed a few in his code and said that he was having problems.  I suggested...

Sorry for the delay,

I agree you do not need the subquery. 

As for the single double triple quadruple quotes thing, I found it helped out a lot when I started...

Hi,  I have used this type of thing when trying to list as a string all of the groups that a person may be a member of.  I found that...

Hi,

First I am unclear what you arre trying to do.  It appears from this script:

Feng,

What type of client are you using to input the data?

it is pretty easy if you can tell just a bit more maybe I can help

Tal

Hi,

Just curious, Why do you care what order the rows are in? when you are querying the data you can sort them with the order by clause.

tal mcmahon

Hi,

This is Relatively easy and it is What I do for all of my Digital Media.  I figure the SQL server is not a Fileserver so I would prefer to...

Hi,

Generally if you have table type questions it is easier to get help if you give a little example of the table structure, it helps the geeks see what you...

The Example From Essea is Correct i use it all the Time for all of the tables I use for drop down boxes.  The only Caveat is that you have...

I am sorry I forgot to add now that you have the function you can refer to it in your parent query right in the select statement. like so:

SELECT

Hi, as I am not familiar with your table size or the performance issues that may arise from this, But,  When I have had to count the number of children...