Viewing 15 posts - 31 through 45 (of 65 total)
Hi,
I tried that and it didn't work. What I want to end up with is the following:
So the results would contain an entry for each...
December 11, 2007 at 10:43 am
Hi,
I think that's exactly what I'm looking for. I'll give it a go later on this morning.
Much appreciated.
July 27, 2007 at 1:46 am
Hi,
Thanks for teh reply. I'm fairly new to this so forgive me for the simple questions but how do I use this -i flag?
I presume what...
July 26, 2007 at 8:49 am
Hi,
I'm sure this is a really silly question but how do I create a batch file to call osql to run the contents of the textfile?
Thanks
July 26, 2007 at 3:36 am
Yes of course, please send via pm
THanks.
April 13, 2007 at 9:14 am
Current requirements are for on-site work but that might change.
April 13, 2007 at 9:01 am
The items are individually labelled i.e. with a barcoded number. So, to return the three items mentioned above would mean three separate Returns. To issue them again would also be...
January 16, 2007 at 3:14 am
Hi Guys,
Thanks for the examples. I am going to use Option 1 for now and I will try Option 2 as soon as I can.
Again, all help...
February 24, 2006 at 1:38 am
Yep,
All sorted now.
Thanks for all of the help.
Dec.
February 23, 2006 at 1:43 am
Hi,
I got it to work by putting brackets around the SELECT statement i.e.
SELECT @RetVal= (SELECT MAX(RevNo)+1
FROM dbo.tblRevision
GROUP BY DocumentID
HAVING (DocumentID = @DocumentID))
Thanks for the help anyway.
February 22, 2006 at 8:14 am
I didn't think of the Injection attack! I am just wondering though, will it be quite slow if I have to cmd.ExecuteNonQuery() for each value?
Would it be quicker if I...
February 21, 2006 at 7:24 am
Looks good. I will give it a go.
Thanks for the reply.
February 21, 2006 at 6:12 am
Hi Jesper,
Yes, that's it, thanks. I think I was confusing myself by putting TransDates in the table out of sequence with the TransID
Thanks again,
Dec.
December 22, 2005 at 6:45 am
Hi,
Table Data (disappeared down the page):
TransID | TransDate | SocietyID | TransType | MobileNo... |
December 22, 2005 at 5:47 am
Viewing 15 posts - 31 through 45 (of 65 total)