Viewing 13 posts - 1 through 13 (of 13 total)
I will also help if you need it.
For your testing set, i believe there are really only 8? tests necessary.
1. no strikes or spares
2. 1 spare
3. 2 spares in a...
August 31, 2004 at 2:45 pm
aTSQL example would be:
create procedure up_Count
@Id int
as
set nocount on
return (select count(*) from CustomerAddress where customerID = @ID)
August 13, 2004 at 9:08 am
if the values are in a list box, then put them in a small table
and have the stored procedure just join to the table.
One example would be
create table ListSelect (
...
August 6, 2004 at 10:16 am
Try changing
and updated = 0 and q2204.batch is null
to
where q1204.updated = 0 and q2204.batch is null
also why q2204.batch is null?
August 6, 2004 at 10:05 am
Sure, do it all the time. Here is one example of a Sub that takes an ID (record key) and performs a function in a stored procedure Not returning a...
August 6, 2004 at 9:45 am
Well I have a good chance based on simplicity then.
August 5, 2004 at 7:18 am
So will the answers be scored on? simplicity, sneakieness, set solution, lines of code, or all of the above.
August 2, 2004 at 12:30 pm
Two sites come to mind:
http://www.parallax.com embedded controllers
http://www.nutsandvolts.com electronic hobbiests
June 26, 2003 at 6:46 am
Well, if you can install a .DLL on the server then you could create an Extended Stored Procedure to call C code. I know that
SHA etc have been written in...
October 14, 2002 at 7:10 am
Ah, a blind spot in my knowledge. <G> So how do you assign an ADO.recordset to a listbox?
Is it just listbox.rowsource = adors ?
August 22, 2002 at 9:25 am
Ok, I like the ideas in the article, but I need help with the idea of using a persisted recordset as the basis for a listbox or combo box. That...
August 19, 2002 at 1:51 pm
OK, I know there are more ways to program than programmers but since you are passing a SQL statement anyway, why not just:
select datefield, datepart(ms,datefield) ?
then in Vb you can...
August 12, 2002 at 8:57 am
Viewing 13 posts - 1 through 13 (of 13 total)