Eric M Russell (10/7/2015)

---

mister.magoo (10/6/2015)

---

I don't know whether your setup would suit this, but how about converting to xml , then using hashbytes?

select MBT.refID,

hashbytes('MD5',(select MBT.* from (values(null))foo(bar)...

IMHO trying to use XML to format this is more trouble than it's worth.

A bit of VARCHAR works nicely though.

CREATE TABLE #Temp

(

[Column A] VARCHAR(10),

[Column B] VARCHAR(5),

[Column C] VARCHAR(10)

)

INSERT INTO #Temp...

I don't know whether your setup would suit this, but how about converting to xml , then using hashbytes?

select MBT.refID,

hashbytes('MD5',(select MBT.* from (values(null))foo(bar) for xml auto)) as...

It gets even more problematic if CustID can be/is updated, then Scott's trigger won't work either, as the join between INSERTED and DELETED will not return the rows for the...

jared.smith (10/4/2015)

---

This is exactly what I'm after. Thanks for that.

It works fine if both filters do not look up a data set for their available values. If one...

I don't think there is any way to restrict the options in the drop down, but if you are happy to just make it not export for the other options,...

This works, but may not look the way you want...

Create your two parameters and allow both to have blank or null values.

Create a Dataset, with this Query:

select case when nullif(@p1,'')...

And another answer comes out as x=4 and y=13.

Also, not great for performance, but shows a different technique.

/* Puzzle from SSC

http://www.sqlservercentral.com/Forums/Topic1723602-391-1.aspx

The beautiful problem:

...

Perhaps if you provide some sample data and the output required we could help, but as it is, the title doesn't really help.

All I can offer so far is that...

Are these connection timeouts or query timeouts?

One thing that is easy to fix is the WHERE clause from the last remote query, the one in this section:

-------------------------Warehouse Adjustments and AM Pickups 5/29/2014 Sue Klotz

You have this:

WHERE...

mceventphoto (9/24/2015)

---

Hi mister.magoo Kristen-173977,

Thanks for the suggestions. I checked permissions and everything is okay there. Collation is the same on old and new server, include the column collations. Local DB...

select ID

FROM #table

group by ID

having count(distinct value)>1;

Oops misread the requirement

select base.ID,base.value

from #table base

join (

select grp.ID

FROM #table grp

group by grp.ID

having count(distinct grp.value)>1

) mto -- More Than One

on mto.ID = base.ID;

Assuming you have the properties of the Linked Server matched on the old and new servers, it could be down to...

1. Permissions - the login that is used to access...

jameslauf (9/23/2015)

---

I am sorry I re-Read my original post and i was unclear.

I want individual LineitemNumbers per each InvoiceId.

so I cna have Invoice#97865 with LineItemNumbers 1,2,3.

right now I...