Viewing 15 posts - 181 through 195 (of 345 total)
One more test, Wendell. Can you insert directly into the archive table? No trigger, no proc, just run an insert into arcAddresses with static values in a query window.
July 6, 2011 at 12:20 pm
The converstion may have made qry_Reports and qry_PI_Reports into tables. Check that. Also check that qry_Reports and qry_PI_Reports were converted at all.
Run this in a SSMS query window:
select * from...
July 6, 2011 at 12:10 pm
GilaMonster (7/6/2011)
There are no other triggers on either table? Absolutely sure of that?
Exactly. There has to be an INSTEAD OF INSERT trigger on the archive table. Lowell and I have...
July 6, 2011 at 11:54 am
The RAISERROR doesn't rollback the transaction, you would need an explicit ROLLBACK TRANSACTION after that statement.
Wendel, your trigger is fine, but I'm thinking other triggers may be interferring. Disable all...
July 6, 2011 at 10:53 am
If the period columns are nullable and dont get filled in until the current month, then this will get the last filled in month:
insert into tableB ...
select coalesce(period12, period11, period10,...period2,...
July 5, 2011 at 3:59 pm
Good luck on prioritizing 100 million users. You may have to stay late 😀
Like my dad used to tell me, "Todd, I told you a million times not to exaggerate!"
July 5, 2011 at 3:40 pm
Not really a SQL Server related question. Google those errors related to your code environment (VB, C#, etc.) There are tons of forums that address these types of errors.
July 5, 2011 at 3:36 pm
Post the queries that could not be converted. Maybe we can figure out why from the syntax.
July 5, 2011 at 2:48 pm
Note that your trigger is insert only. If you want to capture edits, change it to FOR INSERT, UPDATE
July 5, 2011 at 2:40 pm
CELKO (6/29/2011)
Do you often update things at random? Does your boss know?
I don't care who ya are, that's funny right there. 😀
June 30, 2011 at 12:22 pm
You post is very confusing. Let's start simple.
When I run my 'Insert' statements I can not see the record in the table using SQL Express Management Studio.
Exactly how are you...
June 28, 2011 at 3:06 pm
george sibbald (6/27/2011)
toddasd (6/27/2011)
george sibbald (6/27/2011)
I think you have to accept that in most shops devs will own the code but not the environment (and certainly not production). The DBA...
June 28, 2011 at 9:01 am
george sibbald (6/27/2011)
I think you have to accept that in most shops devs will own the code but not the environment (and certainly not production). The DBA is needed to...
June 27, 2011 at 3:46 pm
Your procedure doesn't have any INSERTs, so I can't see how anything is being populated. :Whistling: Which table is table 1? :unsure:
June 27, 2011 at 2:59 pm
Viewing 15 posts - 181 through 195 (of 345 total)