Search results for query: *

Two excel spreadsheets: tbl1 tbl2 SSN NAME AMT SSN NAME AMT 123-45-6789 JOE 25.00 123-45-6789 JOE 25.00 123-45-6790 SUE 50.00 123-45-6700 JASON 80.00 333-45-6700 CHRIS 10.00...

I do not understand why IF cl.SomeField = cm.SomeField is not valid. Can you please explain a little more?

Thank-you, I placed SET as suggested: SET @hld_tracknum = ci.TRACKNUM SET @hld_gdat = ci.GDAT SET @hld_id = ci.ID etc........ NOW I have received the following error: Msg 4104, Level 16, State 1, Line 79 The...

Can you still help with my error????? With all the suggestion I have ended up with the following code and still have the errors: Msg 102, Level 15, State 1, Line 96 Incorrect syntax near '@hld_suta'. Msg 102, Level 15, State 1, Line 130 Incorrect syntax near 'END'. <<--LAST END IN CODE This is...

Thank-you for the valuable information!

Thank-you for the information JonFer. Couple of questions regarding forming and IF statement - when creating an IF statement do you place a BEGIN after the IF conditions an END after the block. EXAMPLE: IF var1 = var2 AND St = State BEGIN INSERT INTO table ----- ----- -----...

The tables and all columns and hold variables are defined. If you would like me to submit all code I can. It is just alot of work because I have to change names of items due company policies.

Your last statement has told me I need to use a SELECT statement. So with that code in place I am still getting the same error: Incorrect syntax near '@hld_gdat'. Revised code: SELECT * FROM [XXXX_dev].[dbo].[tblImport] ci IF ci.TRACKNUM = cs.TRACKNumber AND ci.ID = cs.Id...

I placed the suggested ideas into the code below and received a new Error: Incorrect syntax near '@hld_GDAT'. SQL Code where error is occuring: I also tried a select statement and received the same error. It seems like the if statement is not set up correctly. Could it have something to do...

Can't figure out how to correct this error, also is the commit rollback set up correctly could not find verification or example!! Project Description: Need to run a table (tbl1) of information (ex. Name,Ssn, Amounts) through some joined tables finding out if a record exists. If a record does...

Thank-you, you have been very helpful with the information that was provided in this last post.

I am unable to resolve printing a page footer, report footer and/or group footer. I am mentioning all three types because I worked on trying to printer a footer of some sort on to each page that prints. Is this possible? The solution that was given to me: Right click on the report body, go to...

lbass: Thank-you for a reply. I want to print a small amount of data that I copied from the header. Answer to 2nd question: When the info is placed in the footer it prints on the last page only of the report. This works when I have created a report footer and a group footer ( all at separte...

I tried "infinitizon" suggestion. After right click on report body, I do not have a Report Option. I see a Report Drop down menu at the top of Crystal Reports Menu but then I not not have a Report Option from there. I am using ver 8.5 if that helps.

Tried a report, page & Group footer to print footer data on every page. Of course report and group footer data printed on last page. I need the data in footer to print on EVERY page. Worked with Section Expert check boxes with no success. Any ideas?