Viewing 15 posts - 181 through 195 (of 345 total)
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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,...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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!"
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
July 5, 2011 at 3:36 pm
Post the queries that could not be converted. Maybe we can figure out why from the syntax.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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. 😀
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 30, 2011 at 12:22 pm
What does the error say?
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 29, 2011 at 9:14 am
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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:
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 27, 2011 at 2:59 pm
Bingo. Compatability was 80.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 24, 2011 at 10:14 am
Viewing 15 posts - 181 through 195 (of 345 total)