Search results for query: *

Hi adamroof: Yeah I have the proper value in that line. Any other suggestion on how to trace it?

Hi Everyone: I got this piece of code from the internet. What it suppose to do is send an email from a stored procedure. I created the stored procedure and it compiles fine. The funny thing is that when I try to execute it in the Query Analyzer: EXEC sp_SMTPemail 'from@example.email.com'...

Hi Everyone I created a stored procedure, what I want it to do is use a random generated number and use that as the name for a file that I will be exporting to a file. Here's what I have conceptually: ... SELECT RAND( (DATEPART(mm, GETDATE()) * 100000 ) + (DATEPART(ss, GETDATE()) * 1000...

Hi vongrunt: Thanks for the reply. Dumb question...can I just copy and paste the dll into this MSSQL\Binn directory from the CD?

Hi Everyone: I wrote a stored procedure that calls the master..xp_cmdshell and when I execute my stored procedure, it gives me this error: ---------------- Cannot load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). ----------------...

Hi SQLDenis: Okay i changed it up and it works now...but when I tried to change it and save it to a network path, it gives me this error message: output...

Hi SQLDenis: I tried doing a quick test with the sample you posted and I keep getting an error: output...

Hi SQLDenis: Thanks for the tip! I have a question though...in your example it creates this text file into the c: directory, but what would happen if the file already exist in the directory? does it overwrite it? I would prefer that if the file already exist, another output file (leaving the...

Hi Everyone: I created a stored procedure that updates records in the master table (we'll call it master_table) with data from another table (we'll call it update_table). A feature I want to add to my stored procedure is to export the data from the update_table into a file (csv, xls, etc) and...

Hi George: I'll give this a try. Thanks for your help! So looking at this script...if the record doesn't exist in the master_table and update_table, the record is ignored for the StuffToUpdate temp table?

Hi George, So you suggest I code it like this: ---------------- CREATE PROCEDURE dbo.testSP AS update t2 set t2.field1 = t1.field1, from update_table t1 inner join master_table t2 on t1.part# = t2.part# GO ----------------

Hi Everyone: I'm not sure how to do this in SQL Server, but I thought maybe someone can point me in the right direction. What I want to do is create a Stored Procedure. What I want it to do is read a table (update_table) and if that record exist in another table (master_table) I want to...

Hi Everyone: I'm trying to help an end-user with this strange problem she's having with the Pre-import Report in eBackoffice 7.2 SP 4. When she goes to Accounts Payable > Processing & Posting > Voucher > Pre-import Report, the "Raw Data Pre-Import Report" window pops up. She then clicks on...