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 TouchToneTommy 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: stapet
  • Content: Threads
  • Order by date
  1. stapet

    Query help?

    Can someone please help with what I am doing wrong here? I'm not an expert programmer, but do try hard... :) SELECT Prdctnentry.WorkOrderNo, Prdctnentry.MachineAmount, GRASSLAND_dbo_PT_CaseLot.LotSize, Prdctnentry.Date FROM Prdctnentry LEFT JOIN GRASSLAND_dbo_PT_CaseLot ON...
  2. stapet

    Passing parameter values to a SQL 2005 where statement

    Hello all....I am stumped! I recently upgraded from SQL Ser ver 2000 to SQL Server 2005. I change to some code in one of my Stored Procedures after the upgrade and found that passing a parameter value to a WHERE statement no longer works. I have been researching this for 2 days, and not sure how...
  3. stapet

    Problem with newline character in SP.

    SET @UploadDir = ‘\\MyServer\data\’ SET @UploadFileName = ‘test.txt’ SET @UploadData = ' echo ' + @HoldRecNo + ',' + @Name + ',' + @Terms + ',' + @Description + ',' + CONVERT(char(8), @DueDate,1) + ',' + CONVERT(char(8), @PayDate,1) + ',' + CONVERT(varchar(15), @Amount) + ',' + @InvoiceNo + ','...
  4. stapet

    Check if text file is empty

    Does anyone know how to check a text file to see if contains data. I am currently writing to a text file, but everytime I write I overwrite what is in the file all ready. Thanks
  5. stapet

    Saving SP Query results to a text file

    Hello, I am having trouble with my stored procedure. Any help would be appreciated. I am passing parameters to a SP, inserting them into a temp table and then selecting all from the temp table to save to a text file. Here is my code: SET @UploadDir = '\\MyServer\testdata\' SET @UploadFileName...
  6. stapet

    Create trigger to write to text file

    Hello to all, I would like to create a trigger that writes records to a text file after every insert. I am currently inserting records to a table through a Stored Procedure, but I would also like the record copied to a text file. Could anyone point me in the right direction on finding the...
  7. stapet

    Select Statement in SP

    I am passing the following parameters to my stored procedure @username, @password, @source. My select statement looks something like this Select * From Table1 LEFT OUTER JOIN Table2 ON Table1.name = Table2.winname Where @username = table1.name and @password = table1.password And table2.source...
  8. stapet

    Query Multiple Databases within SQL Server

    I am a newbie at programming with SQL Server 2000. I am wondering, is it possible to Query more than one database at a time within SQL Server? Any help would be greatly appreciated. The whole purpose: I would like to report off of two different databases without having the tables stored in both...

Part and Inventory Search

Back
Top