Reputation
532
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 14
Impact
~14k people reached

  • 0 posts edited
  • 1 helpful flag
  • 2 votes cast
Aug
21
asked What does the presence of rsAccessDenied mean?
Aug
21
accepted How to call modify() on a nodelist in T-SQL?
Aug
21
comment How to call modify() on a nodelist in T-SQL?
And since there's no real identity, ordinal counting it is.
Aug
21
comment How to call modify() on a nodelist in T-SQL?
To clarify I understand the pattern in your first example- 1. Get a count of nodes meeting the criteria 2. Build an accumulator loop/reference count 3. On each iteration call modify() using the accumulator as the ordinal in an xpath expression
Aug
20
asked How to call modify() on a nodelist in T-SQL?
Aug
12
answered Is it possible to develop a SSIS with a SQL Server Evaluation Version
Jul
14
asked What is the relationship between the SSIS Package Store and Catalog?
Jun
24
awarded  Notable Question
May
22
comment Installing instances of older versions of SQL Server
@AaronBertrand - Leaving client tools out sounds like the obvious Right Thing.
May
22
asked Installing instances of older versions of SQL Server
Apr
8
asked What is the security model for viewing transaction history in MDS?
Mar
29
asked Why do maintenance plans exist as a feature?
Mar
26
awarded  Notable Question
Mar
25
awarded  Disciplined
Mar
20
comment How to make a flexible service broker receive in a stored sql procedure, how to pass “FROM” parameter into receive
@RemusRusanu - do you mean to say multiple instances of activation procedures or multiple, different activation procedures? I was under the impression that a queue could only have one activation procedure.
Mar
8
awarded  Yearling
Mar
8
asked Can I split lines into Elements with For XML?
Feb
26
comment How to architect Service Broker with three or more systems?
More specifically, can an activation stored procedure be the initiator of of secondary conversations in a conversation group? That sounds a bit like recursive triggers.
Feb
26
asked How to architect Service Broker with three or more systems?
Feb
17
comment Is there a Document based nosql with deep json update?
No. Xindice fits the equivalent niche for xml. I suppose you could lay some sort of mapping layer there. Without a broadly implemented query language for json, I don't see it happening.