Viewing 15 posts - 76 through 90 (of 582 total)
You probably don't need to loop through the records. With any luck (and good db design) you can rewrite your code to use the whole of the inserted and/or deleted...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 12, 2006 at 5:59 pm
In case you wander back onto this path, this might be what you were after:
function dbo.getFY(@date datetime, @FYstartmonth Tim Wilkinson "If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 12, 2006 at 4:08 pm
You might want to have a look at this, too. It's about the same issue, rather than a crosstab (aggregate) query like the previous link.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=291923
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 12, 2006 at 3:14 pm
I've had a go at this, trying to keep the dynamic SQL to a minimum. The processing could possbly be made more efficient, but the task itself limits the options...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 12, 2006 at 3:05 pm
Effectively the same as
(2) Have the front end do the processing of the result sets for you.
Except you are using a middle tier (the CLR code) rather than a...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 12, 2006 at 1:28 pm
You can record them if they don't abort a transaction or terminate the connection, by changing the sp to capture the value of @@error immediately after each statement in the...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 12, 2006 at 1:01 pm
You need to use the table which contains all the ProsAtty entities as the basis of your query, using a left join (LEFT JOIN) to return...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 12, 2006 at 10:29 am
[edit: revised and expanded,...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 11, 2006 at 1:56 pm
Yes, I am imagining that, say, a...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 11, 2006 at 10:25 am
From BOL v9:
RAISERROR ( { msg_id | { msg_str | @local_variable} }{ ,severity ,state } [ ,argument [ ,...n ] ] ) [ WITH option [ ,...n ] ]
msg_id
Is a user-defined...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 11, 2006 at 8:45 am
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 11, 2006 at 7:58 am
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 11, 2006 at 7:40 am
Yes I believe fervently in teaching propositional logic via the means of SQL.
quiz:
In the context of te above batch, are these two logically equivalent? Could they give different results? Discuss.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 11, 2006 at 6:00 am
Just in case it could be a problem: the constraint as defined will also disallow nulls in ClaimStatusID.
@t table(ClaimStatusID int, DateClosed Tim Wilkinson "If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 10, 2006 at 7:39 pm
Agree with the indexing idea - but remember all other indexes use the clustering key for row access, so don't make it too wide. All the usual caveats about storing...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 10, 2006 at 11:36 am
Viewing 15 posts - 76 through 90 (of 582 total)