pietlinden (8/23/2015)

---

MM,

Any idea why the parameters button would be grayed out? I'm using Integrated Security, and the SQL Instance is on my local PC.

So I can't specify a parameter as...

Connection properties window.

Eric M Russell (8/11/2015)

---

mister.magoo (8/6/2015)

---

You'll be in a big pile of do, because you won't even know who did it - as you want them all using the same ID.

Perhaps...

Sqlbill, how do they restrict the network people that can grant access to the account/group so that they don't work in cahoots with the villain?

The other problem you will have to contend with (aside from not being able to prevent new sysadmin accounts), is that the quality of your DBAs will decrease as the...

You'll be in a big pile of do, because you won't even know who did it - as you want them all using the same ID.

Perhaps you should just have...

order by left([B1_ALT_ID],3)

It's very simple.

You add an action to the textbox that contains the value. The action links to the detail report and passes parameters to it from the data row/group that...

Thanks, but I thought you wanted to specify a node name as well?

Otherwise, you could just take node 1?

Edit:Much later, with no further input, I will offer this suggestion:

DECLARE @tmpTbl...

Please read the link in my signature "Forum Etiquette: How to post data/code on a forum to get the best help"

That's no problem, just post some sample data and I'll show you...

declare @x xml = '<ns0:ADT_A03_26_GLO_DEF xmlns:ns0="http://microsoft.com/HealthCare/HL7/2X">test</ns0:ADT_A03_26_GLO_DEF>';

declare @t table(col sysname);

insert @t values('ADT_A03_26_GLO_DEF');

with xmlnamespaces(default 'http://microsoft.com/HealthCare/HL7/2X')

select *, @x.value('(//*[local-name() = sql:column("col")]/text())[1]','varchar(100)')

from @t

If you declare the namespace as default, then it will work.

If you answer this, I may be...

Please post the execution plan (.sqlplan, not an image) and the table definitions.

How many rows are in the tables on the remote server?

Maybe this will get you somewhere, but it's not quite right according to your desired output, I just don't have time to to spend trying to fix it and I...