Search results for query: *

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