Search results for query: *

I have a stored procedure that sends out and email. It runs fine in SSMS and sends the email, but when it runs as a job it fails. The error is 'can not convert nvarchar to real', which I have spent months trying to fix and can not figure out, since I can not find any nvarchar fields. So I would...

Hello, I am trying to join two tables and have the output include all eqmtids. The hist_eqmtlist table has all eqmtids but the hist_load table has only some. I need the output to include all eqmtids and nulls or zeros for the other columns. I thought an outer join would do it but alas, I have...

I am running a command line utility that grabs a .rpt file, inputs the dates to run it for and spits out a .pdf. Here is the command: C:\Powerview\exe\mms_PrintReport.exe @rpt="C:\Powerview\rpt\Custom\DailyEmail\jpm_de_minekpi.rpt" @dsn="C:\Program Files\Common Files\ODBC\Data...

Hello, I am trying to call one sp with another but am getting an 'Error converting nvarchar to real' error. However, there is no nvarchar in either report. Not only that but other reports that call the sp work fine and seem to be set up the same. I am running this command DECLARE @startd...

I am trying to get an ODBC connection to work from excel. I have copied the excel sheet from a working copy and am trying to point it at a different server. I am a VBA noob and have no idea why it isn't working. Sheets("DataQuery").Select reportdate = ActiveSheet.Range("B1").Value...

I am upgrading from Sql Server 2000 with Crystal Reports v8.5 to Sql Server 2005 with Crystal Reports v11. There is an xml job that grabs a .rpt puts it into a .pdf and emails it. If I send the email with no attachements it will work. When I add an attachement it throws the 'Invalid TLV record'...

We are upgrading from sql server 2000 to sql server 2005. I am trying to move an xml script that sends out an email every morning with pdf attachements. Here is the code: <?xml version="1.0"?> <!--XML writer for DataGridView Control--> <XML> <schedule id="1"> <fileSettings...

I have been trying all week to get my new sql 2005 server to send out auto emails. The test emails come through fine but the EXEC msdb.dbo.sp_send_dbmail do not. Earlier they said that the email was queuing but no email was sent to my inbox. Now it seems I have regressed. I am seeing this error...

I am running into some trouble creating a user for one of my dbs. The user account will be used to pull data out of the db into excel, so they don't need to login directly to the server. I was reading the BOL on creating database users which states 'The topic assumes that a corresponding sql...

Hello, I am trying to move some DTS packs from SQL 2000 to our new SQL 2005 server. I have used the wizard and it said it completed successfully, but I can not find the DTS packs. I re did the wizard and renamed the packs to go into a new DTS folder, but when I opened the folder it appears to...

Hi, I am trying to send an email everyday that list down events by equipment. I am trying to display all the rows returned out of a temp table. I have no idea what I am doing, so I have been trying to copy a few of the other auto emails that are already set up, but don't have a good enough...

Here is a select statement I have been given by someone else (who is not available to answer why it doens't work). select eqmtid from ( select distinct eqmtid, eqmtid as sortorder from hist_eqmtlist where eqmtid is not null union all select 'All Equipment' , NULL) The error being...

Last Fall I created a MS Access DB, which was finished in December. I have kept a master copy on my computer and now, since we have misplaced the stick that housed the copy people have been used for data entry (bad idea, I know and I told them). Now I can open my master copy with the SU account...

I have a crystal report with 14 sub reports that has been working fine for months. Suddenly it is reporting on all sections and then rereporting all sections. So it prints details a through o and then attaches a second copy of details a through o again. They are both showing the same data. I...

I am struggling to find the correct syntax for the max function. I want it to return the eqmt, endtime and shiftindex, but only the row with the highest shiftindex for each combination. So if I have eqmt endtime shiftindex 1 2 1 1 7 2 I want it to return 1...