That is correct....

Another option would be to add a parameter that tells the SP which columns to return. So for example:

(

-- SP parameters plus a new one

,@returncols...

Have you tried it? It should only return records with @Custid = 'Apple'

Because...

sindhuv.tx (11/5/2013)

---

Hello,

I have this schema given to me

<soapenv:Body>

<xxm:xxmesmo>

<xxm:systemName>TESTCP</xxm:systemName>

<xxm:companyId>1</xxm:companyId>

<xxm:document>

<![CDATA[

<!--document for xxmesmo,xsi namespace is added to support nulls in column values-->

<xxmesmo xmlns='http://www.deltek.com/enterprise/integration/xxmesmo' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'>

<!--Result set...

roy.tollison (11/5/2013)

---

ROW_NUMBER sounds promising.

the values they want in spdd_f5 will be 1 thru 100 (will never go over 100) no duplicates.

it is just a pad number but it would...

Unfortunately, I don't believe this forum has an administrator that will...

First let me share a small utility function that could help to make short work of this problem:

CREATE FUNCTION [dbo].[GenerateCalendar]

(

...

Borrowing from the code in the CASE that was thoughtfully provided by Scott, I offer another alternative:

SELECT MatchID, KeyCode, KeyValue

FROM @MySampleTable a

CROSS APPLY

(

VALUES

...

That is by design. Passing a NULL to @CustID is like...

IdRatherCodeIt (11/5/2013)

---

Nice article,

For truly dynamic behavior, do you think moving that responsibility to coding might reduce verbosity, error prone string concatenation, and allow more flexible dynamic searches?

I'm talking about solution...

Phil, Scott, Jeff and Erik,

Thanks for stopping in to read the article and offer your comments. I hope you find the content useful in your future endeavors.

And to Jeff,...

L' Eomot Inversé (11/5/2013)

---

You need some additional bchages as well as Dwain's correction, in order to handle the hvehicle history correctly.

First remove

INNER JOIN History H ON H.VehicleID=V.VehicleID

(actually since the...

rlindstrom 38273 (11/5/2013)

---

Since I'm new to this maybe another shot at explaining.

There are no empty records in the coitem_log table - every time a line item on a order is...

Gatekeeper (11/5/2013)

---

Alan.B (11/5/2013)

---

Forgive me if the code to do this has already been posted but I had a requirement for a greater-than-8k splitter. I made the following changes:

1) Changed...

Jeff Moden (11/5/2013)

---

dwain.c (11/5/2013)

---

Jeff Moden (11/5/2013)

---

I assure you, it's just words from some serious...