Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: delphidestructor
  • Order by date
  1. delphidestructor

    How do I print labels not linked to a data source?

    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
  2. delphidestructor

    How do I print labels not linked to a data source?

    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
  3. delphidestructor

    Any suggestions on how to suppress certain records?

    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...
  4. delphidestructor

    Any suggestions on how to suppress certain records?

    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...
  5. delphidestructor

    Should I consider using a bulk insert?

    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
  6. delphidestructor

    Should I consider using a bulk insert?

    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...
  7. delphidestructor

    Should I consider using a bulk insert?

    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...
  8. delphidestructor

    Dynamic field names

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

    Dynamic field names

    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...
  10. delphidestructor

    Dynamic field names

    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...
  11. delphidestructor

    INSERT, ALTER TABLE, doesnt recognize new field?

    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
  12. delphidestructor

    INSERT, ALTER TABLE, doesnt recognize new field?

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

    Help with adding column.

    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
  14. delphidestructor

    Help with adding column.

    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...
  15. delphidestructor

    Locking section size?

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

    Locking section size?

    I do not know if it is possible to do. I’m using version 9. I would like to lock the page header and footer sizes on a report template so any reports made from that template will look consistent. I do not want other report creators to be able to increase or decrease the height of the sections...
  17. delphidestructor

    How do I assign a variable field name?

    Karl, yes I do have tables you said I needed. The samples table, results table, and a test details table. I didn't have any luck with the ##tempTable. It kind of worked but not for what I needed. I did this simplified code to do what I needed though. CREATE PROCEDURE testdynamtable AS set...
  18. delphidestructor

    How do I assign a variable field name?

    To answer Karl. I work in a laboratory environment. If I designed the database to hold all the possible test results for a sample I would have tables with 500 + columns with only 5 – 20 or so of those fields with actual values. It seems better to me to store the values in table with a reference...
  19. delphidestructor

    How do I assign a variable field name?

    I have tried this and it does work for creating the table, apparently. The problem I run into now is inserting data into the field and returning the temp table. neither set @FinalSQL = ('insert into #tmptable values(888)') exec(@FinalSQL) or insert into #tmptable values(888) works. Invalid...
  20. delphidestructor

    How do I assign a variable field name?

    CREATE PROCEDURE testdynamtable AS set nocount on declare @tmpcolname varchar(20) set @tmpcolname = 'col1' create table #tmptable (@tmpcolname int) ^ | How do I do this? GO Mike

Part and Inventory Search

Back
Top