Search results for query: *

The information you are providing isn't helping my issue. Do you have any indication what might be causing the temp tables to not be recognized by the system? I understand that there are more ways to complete the task, but I am looking for a solution to the objects not being recognized...

I will do a join later on, but that is part of my problem. Because the temp tables aren't being recognized as objects, the join isn't recognized and I am getting more records than I am expecting, e.g. ItemCode is in both tables, table one has 100 records and table two has 50 records. Instead...

Update: I created the temp tables as views and I am having the same issue. What would cause objects not to be recognized within the system? Thanks in advance, Donald

I stopped and restarte SSMS and that didn't take care of the problem. In 2008 R2, I am used to seeing the table names in the autocomplete when I begin typing them, but they aren't showing up. It is as if the system is not recognizing them. They do return values if I Select from them, but I am...

Here is my code. I am working on MS SQL SERVER 2008 R2 IF OBJECT_ID('tempdb..#JAM_TMP_TBL_00','U') is not null BEGIN DROP TABLE #JAM_TMP_TBL_00 END; IF OBJECT_ID('tempdb..#JAM_TMP_TBL_01','U') is not null BEGIN DROP TABLE #JAM_TMP_TBL_01 END; IF OBJECT_ID('tempdb..#JAM_TMP_TBL_02','U') is...

Thanks again, but that returned null values for every column except 1 and 2. I think I might try a stored proc for this. Thanks in advance, Donald

Thank you for the quick replies, unfortunately, none of these worked. The one that came closest was Markros, but it returned several lines for each value, but they were not distinct, so I couldn't eliminate the duplicates. Here is my code select T0.DocNum,T0.DocDate,T1.ItemCode...

I have two tables; One is a Standard Cost history table and one is a purchase order table. Both have a transaction date. I am trying to figure out a way to compare the Purchase Order Price of an item on a particular day with the Standard Cost of an that item during that time. Here an example...

I am running them from File System. How do I determine the package protection level? I am running 2005 on 64 bit server. Data Sources are MS 2005 and MySQL 5.1 Thanks for your comments. Would it be more effective to run these packages from the SQL or the package store in SSIS? Donald...

I have an SSIS Solution (Package) that works fine when I run it from BIDS, but when I run if from the SSA Job Scheduler, I get a positive response, but it doen't run the package. I have tried to troubleshoot it, but now I am lost. Has anyone else had a similar experience? If so, could you...

Please ignore the ambiguous error, I have solved that one. Thanks in advance, Donald

Here is my revised code: DECLARE @RecordKey varchar(100) DECLARE @NumAtCard AS NVARCHAR(20) SET @NumAtCard = (Select max(T0.NumAtCard) FROM OINV T0 WHERE T0.Series = '37' and T0.NumAtCard not like '500%') SELECT T0.RecordKey COLLATE Database_Default as...

Within a particular set of results from a query, I want to number the lines, e.g. Order 1 has 5 lines, I want to process the results to read Order 1,0 Order 1,1 Order 1,2 Order 1,3 Order 1,4 I am using the following code to achieve this, but I can't seem to get it to work. I am getting the 2...

That was it, thanks. BTW, I will include you code as well. Thanks for all of your help. I knew it was something small. Thanks in advance, Donald

Same thing, it only prints one record. Should there be a 'Next' after the 'END' statement? Thanks in advance, Donald

I am attempting to send out 72 separate emails using the following code; DECLARE @cardname varchar(100), @mailrecipients varchar(100), @numatcard varchar(100), @trackno varchar(50), @docnum as varchar(50), @DocDate as varchar(50), @newBody...

The error code "incorrect syntax near '+'" is still persisting. Here is the code updated to reflect your recommendation: DECLARE @cardname varchar(100), @mailrecipients varchar(100), @numatcard varchar(100), @trackno varchar(50), @newBody varchar(1000) SELECT...

I have the following stored proc. I want to embed the declared variables into the body and subject of outgoing emails, but I continue to get the error "incorrect syntax near '+'" However, when I use literals, the code works. DECLARE @cardname varchar(100), @mailrecipients...

Either should work, no? I am just concatenating a string to a parameter. I think this should work for any NVARCHAR parameter. In any event, I changed it and it still didn't work. I will keep looking at it. Thanks in advance, Donald

It doesn't like the '+' signs. I think I have to escape out of the string first or there is a different way of concatenating this. Thanks in advance, Donald