Search results for query: *

I found it....thanks anyway everybody. I had to change my select statement to.. SELECT Prdctnentry.WorkOrderNo, Prdctnentry.MachineAmount AS MAmount, GRASSLAND_dbo_PT_CaseLot.LotSize, Prdctnentry.Date FROM Prdctnentry LEFT JOIN GRASSLAND_dbo_PT_CaseLot ON Prdctnentry.WorkOrderNo =...

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

Never mind.... I had forgot a ). This seems to work great! But could you still explain what is happening on that line of code? Thanks a bunch!!!

Yes, It was working in 2000. Can you explain this part of the query for me? (@begInvDate IS NULL OR @endInvDate IS NULL) Is that checking to see if @begInvDate and @endInvDate is null? I'm not understanding the purpose of that statement. When I changed this I get data with invoice dates...

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

Thanks BlueStringPudding! It worked great! I'm not really sure if a DTS package would work or not. I haven't worked with them enough, but I will look in to it. I appreciate the suggestion.

sorry , i did not mean to post the previous message here.

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 + ','...

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) + ',' +...

Thanks donutman. That worked great. Here's a star!

I'm a newbie. Maybe I need to be more clear, sorry about that. I am using SQL Server 2000. This is what my SP looks like: CREATE PROCEDURE [dbo].[USP_Advances]@Name varchar(100), @No varchar(50), @DueDate datetime, @PayDate datetime, @Amount numeric...

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

Thanks for taking a look. I changed the SP to just output the variables I'm passing, instead of saving them to a temp table and then outputting. I appreciate the help.

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

Could you please explain the following part of the command: 'osql -S(local) -dclaire -Q"select @ from testa" -E >C:\text.txt' I do understand the "select @ from testa". I have tried to play with this command(in the Query Analyzer), but I can't get anything to show up in my text file. I am...

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

Sunil Could you please explain that join to me as far as what is happening, it works great, but I can't really figure out what is going on. Thanks again. stapet

Thanks Sunil! It worked perfect.

The problem is that source is never null in the table2. I am thinking that it is not possible to select my information this way. Thanks for the tip on selecting columns, I normally do select only the columns I need but wrote it this way to save on typing.

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