Search results for query: *

Afternoon, I get the following error when executing the code below. Server: Msg 510, Level 16, State 2, Line 9 Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint. declare @routine_catalog varchar(255) declare @routine_name...

Afternoon, I want to perform an update to a record on the left hand side of my join, for the number of times the join condition is true. For exmaple: update A set match_counter = match_counter + 1 from TABLEA A left join TABLEB B on A.postcode = B.postcode However, the code above...

Morning, If you have a query that you know update every row in a table, is there a significant performance benifit in aquireing an exclusive table lock within the query (as opposed to SQL Server escalating various lower level locks)? Hope this makes sense. Cheers, TheGeezza

Afternoon, Essentially I want to increment an error counter each time an error is encountered executing a stored procedure. So for example..... exec @custom_error = sp_executesql @sql ..... will catch the return status from the procedure. What I would like to do is this following which of...

Dear All, I have a data set that I wish to select unique records from based on the group which they belong to and a priority. The code below displays three records within a group (indicated by gr_id1). (Note:key1 is unique, ID is not) select s_id,key1, company, gr_id1, priority from...

Morning, Is a where clause applied to a data set before or after the join operation in the subquery bellow. update Llyods_dedupe_template set comp_add_dupe='T' where key1 in (select B.key1 from Llyods_dedupe_template A left join Llyods_dedupe_template B on A.gr_id1=B.gr_id1 and...