Viewing 15 posts - 901 through 915 (of 5,504 total)
It sounds like the sproc is part of a RBAR process (a loop where a few thousand acctId values are "collected" - e.g. using a c.u.r.s.o.r. *cough*).
From my point of...
October 9, 2011 at 10:59 am
An alternative for such a scenario would be to use ServiceBroker. It's designed for exactly such a scenario (among others).
There are two disadvantages of the frequent job concept: The first...
October 9, 2011 at 10:54 am
It depends 😀
If the DBs are in the same instance, use the same collation and security context, have a similar layout of file groups (e.g. in terms of log file...
October 8, 2011 at 3:06 pm
You might need to use your current query as the source of a CrossTab query as described in the related link in my signature.
October 8, 2011 at 2:53 pm
duplicate post. no replies please.
Original post: http://www.sqlservercentral.com/Forums/FindPost1187493.aspx
October 8, 2011 at 2:50 pm
GSquared (10/6/2011)
LutzM (10/6/2011)
...As a side note: if you're using nested transactions, be aware that a COMMIT or ROLLBACK only affect the outermost transaction (see BOL, Nesting Transactions for details).
Not quite....
October 6, 2011 at 2:06 pm
It seems like you just reposted the original query.
Did you even try to follow the hint given by BrainDonor? :unsure:
What exactly do you mean by "Where need to give"?
October 6, 2011 at 1:21 pm
It seems like you're using several transactions but the (logical) number of COMMIT /ROLLBACK commands does not match the number of related OPEN TRANSACTION commands.
You'll need to review the code...
October 6, 2011 at 12:53 pm
Ok, now we have the result set you don't want to have.
But what is the result set you're looking for?
October 5, 2011 at 1:38 pm
As usual, google will return some helpful info as long as you know the "magic spell".
in this case, "patindex escape" would have provided a number of helpful links. 😉
I agree...
October 5, 2011 at 1:36 pm
Please provide some ready to use sample data as described in the first link in my signature together with your expected result based on the sample data provided.
October 4, 2011 at 1:14 pm
It sounds like homework or test.
If not, can you please explain the business case?
October 4, 2011 at 1:11 pm
Since [ is a meta-character in wildcard expressions, you'll need to wrap it with another set of brackets:
SELECT PATINDEX('%[[]%',mytextfield)
October 4, 2011 at 1:09 pm
Without seeing the expected result based on your sample data it'S hard to tell what solution may be useful.
In general, I would look into the CrossTab approach as describerd in...
October 4, 2011 at 12:56 pm
parsayandan (10/3/2011)
Hellocodevc.com is a code collection website and he collect best and true way in programming and IT
...
You know, the very first thing this person should post is:
DO NOT...
October 3, 2011 at 2:18 pm
Viewing 15 posts - 901 through 915 (of 5,504 total)