Recent content by delphidestructor

The text on the labels will be the numeric parameters. If I enter 4 and 9 for param 1 and param 2 I want 6 labels to print out. 4, 5, 6, 7, 8, 9 Mike

I just want to print simple labels. There will be two parameters; the starting number and the ending number. I just want to print out labels starting with the first parameter and continue printing, incrementing by 1, until the second parameter value is reached. Mike

The parameter mentioned to export to a PDF is not passed to the database (SQL Server 2000). It is passed into the report through code and not forwarded on to the database. The min and max parameters although, are two distinct values that are passed to the report and then in turn passed to the...

Scenario Parameters passed to report are min = 1 and max = 4 Rec 1: Cust A Rec 2: Cust A Rec 3: Cust B Rec 4: Cust A This is not usually going to occur and for printing it isn’t a problem. The reports need to be printed in the original order entered. Not sorted by customer. Problem : I...

That is a good idea. Try the simple things first. I will do some playing around with the indexes. Much better than reprogramming to do a bulk insert. I will let you know if it makes a difference. Mike

No, there are no trigers and yes, the prinmary key is clustered. Would it be better if it wasn't clustered or had a different PK? The primary key is (tinyint, int, int, smallint). Should I have an identity column as the PK and make the primary a secondary key? I would have no use for an identity...

I have a stored procedure that inserts records into a table that is about 600,000 records in size at this point. This stored procedure is called recursively from a middleware application that reads a text file and calls this procedure for every line of the file that has valid information. At...

I am obviously am doing something that I should do a differnt way. I will look at taking a different approach. Mike

Say I want '[Nitrate ppm]/[Sample Wt]' from the table this time or maybe just '[Ammonium]' the next time. The possible ways I might need information or values from this table varies greatly. I want to pass in '[Nitrate ppm]/[Sample Wt]' or '[Ammonium ppm]' into @var1 and then query based on this...

Can anyone tell me why the value of @var2 can be used to execute a query but the value of @var1 cannot? Is there anyway to force sql server 2000 to recognize the value in @var1 instead of trying to read this as a column name? declare @var1 varchar(50) declare @var2 int select @var1 from...

Just found the post today. I was having the same problem this morning. I haven't been woking on the problem for 5 months. Mike

found a way to make this work. if anyone hasn't yet and are still interested. Mike

Yes I did try the GO after the adding of the column. The temp table then goes out of scope and the insert call will not compile. Creating the table with ## then calling GO might work but I didn't want the scope of the table to be global. Mike

Can anyone tell me why the first works in a sp and the second doesn't? 1) CREATE PROCEDURE w_z_testing AS create table #t_table (f1 int, f2 int) alter table #t_table add f3 int insert into #t_table (f1, f2) values (2,3) select * from #t_table GO RETURNS: (1 row(s) affected) f1 f2...

Thanks, that is perfect. I don't know how I missed that option? Mike