Viewing 15 posts - 1 through 15 (of 56 total)
Ah, never thought of a trigger. That would work.
August 15, 2022 at 6:37 pm
To all, was out sick for a few days. thank you for all your insights, Truly was an education.
May 11, 2022 at 11:06 am
A little confused on the schema but will look up more reference on that. Understand on the creation of data. Everyone have a nice weekend. Nocking off for the day...
May 6, 2022 at 4:18 pm
Jeff, you are correct. I had the cursor distinction mixed up. it is a dynamic cursor and I have used forward only in the past. The left outer joins are...
May 6, 2022 at 3:29 pm
I guess you may be correct, an application programmer. That is what I have done for a very long time. For data manipulation, I guess, I would not know how...
May 6, 2022 at 1:52 pm
OK, I love to learn new things. Thought I posted code yesterday but possibly
declare @partno char(35)declare @rev char(3)declare @id numeric(15)declare @id2 numeric(15)declare @std numeric(1)declare @prc numeric(1)--Get list...
May 6, 2022 at 12:07 pm
@Mr. Gale - No only when debugging in VS does it take long. When I would debug in SSMS it would not do that. I like to step though my...
May 6, 2022 at 11:40 am
How do you union the blank rows on fquantity? I have search and searched and have not found anything.
April 27, 2022 at 4:43 pm
I renamed them for now and will see what happens over the coarse of a few months.
February 23, 2022 at 4:39 pm
I found some articles using msiexec /x GUID and that seemed to work. Thanks for the reply.
February 23, 2022 at 1:00 pm
I got around it by selecting a 0 as the field name then doing an update to the table setting the field to a select statement value. Runs lickidy split...
October 22, 2018 at 6:35 am
OK, now I know why, there are more than 1 records in the #PMARevenueTemp with the same fsono, fpartno, and frev. But how do I get around that? I only...
October 19, 2018 at 7:24 am
Can you take a look at this for me? Maybe I am over seeing something.
This is the offending code:Select Distinct fsono, fprodcl, fpartno, frev, fccompany, lstclassify,
October 19, 2018 at 6:24 am
I found the code that is offending. It is a select statement. Within the select statement there is a select statement to a very very large table. I know a...
October 19, 2018 at 5:42 am
a bit over my head but I will try to get through it.
October 18, 2018 at 12:47 pm