Good question. The numbers from the daily table does not tie with the history tabvle. There is a descrepancy between the tables that I cannot figure out. And...

No, it wouldn't work for me. I had to add the tick marks. I can run it past my Teradata group to see if they have heartburn. 😀

Thanks...

Thank you very much, Andrew. You gave me the solution:

First I removed into #Tbl_budget

SET @SQLBUD = '

SELECT *

>>>>>into #Tbl_budget<<<<<

FROM OPENQUERY (aaaa_TERADATA,

Then I changed this:

fiscper = @Yearmonth

to

fiscper...

Thank you so much for responding so quickly.

The code that I sent earlier didn't need a yearmonth, so I re-wrote it with the temp variable.

This code does have...

Thank you for pointing out my error. I corrected it and still no luck. Since this is a relatively small table, I selected the whole year via hard...

I want to use Microsoft Snipping tool and do a quick copy and paste.

I wish all the responses to my thread were as kind and helpful as yours. I got two responses telling me I was breaking all laws of nature and...

My bad. I should have given you credit for informing me about sql server 2012. I am at the mercy of my company on what versions of...

Thank you opc.three. I changed my code to look like yours and it works. There are a couple flaws (in the results, not your code) such as a...

Solved. 😀 Thank you for your patience with me. This is what was driving me nuts. I can right click on the text box, but cannot...

Is it possible that even though I dropped a field in between two fields that are in a group, it didn't become part of the group? How can I...

Thank you. Stupid question, where do I find remove duplicates? I right clicked on the field name and the header, but cannot find the properties that has the...

My fault, I misunstood you. It is a date,null format

The table #tbl_deltab contains a single record and I use below to pull it:

select @lastdate1=lastdate

from #tbl_deltab

set @lastdate =CONVERT(VARCHAR(10), @lastdate1, 111)

Thanks for pointing me in the right direction. Your solution along with this code I found from a blog by Anith S Larson who credits Adam Machanic with this code...