Search results

This appears to work and is pretty slick! I'll do some more reconcilliation, but I think this will do it. Thank You!

Unfortunately the software I'm using does use "Time" as a field so I must deal with it. I do still, however, get multiple patients, I need only one temp per patient. If I remove the "min" before time I get the same number of records, it does not affect the query.

Ok, using the table below I need only the first temp for a patient patient temp time 1 98 8:00 2 97.5 9:15 2 98 9:18 2 99.1 9:22 3 98.6 5:15 3 99 5:27 4 97 6:12 ..... My results should...

I need to link an application that will be running to a .asp page. The application that will be running lists a CurentCustomerID in the registry. I see no other way to pass that value to the SQL server,other than to read it and run a procedure pulling up all of the information. Basically...

Yes I need SQL to read it for my .asp page. I know asp.net can do it...can .asp?

Can I read the registry of a client PC with SQL? In other words, when a client runs a procedure it uses a value found in its own registry.

OK, now this is sure to confuse you but.... the "staff" table is where all of the original data resides, notice he only puts the hours into each field, each field is named for an employee. Through a stored procedure, I rewrite the data into the "daily_info" table, where I also gather the pager...

Unfortunately I am pulling the data from a horrible SQL db where the data is stored by employee, I need it by day. I had to run an obnoxious stored procedure just to make teh dat almost useable, which is where I am stuck. Sort of confusing, but if anyone wants to take a stab at it I'll post an...

The user must choose from a list of values, so I will be able to control that scenerio. I could probably just change the "-" to a "to" and resolve it that way.

I believe if I change my delimiters this code may work??? Am I correct?

Ok, sorry for the confusion. Lot's of good ideaas posted though. The field consists of a name - Hours - Pager - userid I need the hours. The length of the name or the hours length will change. If I can use a delimiter to get what I want, I can set up my file to be: name * Hours * Pager *...

If I have a value in a table of: Smith - 8 - 2323 - b3234 Is it possible for me to display the "8" in a separate part of the form I cannot use the "Right" or "Mid" function since the "8" could be "10" or "7-5" etc.. It is not a fixed length. Is it possible to look for a delimiter to display a...

You are correct, I was looking in the wrong area. Thanks you for your help!

There is no "save password" option. I just checked.

I can't thank you enough for your help with this. Your code worked. Any chance you also know how to hard code the connection string into my linked tables so it doesn't ask me to log into SQL every time the db is opened?

Where does this code go? In a query, or VB? How do I call it up? Sorry for all the questions.

I am just running a pass through query all it consists of is: exec SP_ADD_EMPLOYEE I tried: exec SP_ADD_EMPLOYEE[forms!datepicker!list36] but I get an error that SQL cannot convert nvarchar to a date field. I believe that error simply means that SQL reads the parameter directly from the pass...

I have and access form that has a list box with dates in it. I need to pick a date and then run a stored procedure in SQL based on that date. Can someone help me with the login to pass on the date? So if I have listbox1 which is a list of dates from another table and my procedure is simply...

I need to pass a date from a listbox. Is that possible? So when the user chooses a date, I can run the procedure for that date.

thanks You, that did work. Now I have to find a way to pass a date through it...