maybe this article by Phil Factor will provide some ideas for you....

interesting read anyway.

https://www.simple-talk.com/sql/t-sql-programming/searching-for-strings-in-sql-server-databases-/

I posted some code in this thread a while back

http://www.sqlservercentral.com/Forums/Topic1544629-146-1.aspx

http://www.sqlservercentral.com/Forums/FindPost1558835.aspx

this may be what you are looking for....but please read the comments from Jeff Moden after my post.

I think that you may have oversimplified your real data....??

do you know in advance the maximum number of items that are allowed?

anyways here is some code that does what you...

the following excellent articles by Jeff Moden may help you on your way

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

as a sidebar...I would start using datetime for your month names....you are likely to get into all sorts...

maybe food for thought....

the random data is a bit simplistic...but relatively large.

not sure if this meets your requirements.

/*set up some simple test data*/

use tempdb

go

If exists(select * from information_schema.TABLES where TABLE_NAME...

[p](Code is used for more than 60 or 70 tables in three different databases).

[/p]

out of curiosity....whats the reasoning behind this proc?

not sure I completely understand....for the first search rule if I run

SELECT ...

jeichelber (4/18/2014)

---

I spoke with the program developers and they said that there are no columns like that.

That is why I was going to bail.

I spoke with a gentleman that is...

jeichelber (4/18/2014)

---

Thank you for the information.

It looks like I will have to hobble along with overly complicated PROGRESS queries until the company decides to upgrade our systems.

They promise that it...

as a sidebar.....is there a reason why you cannot get a solution to you problem from your NAV reseller?

using your setup script

SET NOCOUNT ON

CREATE TABLE SampleOrders (

[SalesOrderNumber] NVARCHAR(20),

[VersionNumber] NVARCHAR(10),

[ItemNumber] NVARCHAR(20),

[OrderDate] DATETIME,

[RequestedDeliveryDate] DATETIME,

[LeadTimeReqDeliveryDate] INT,

[PromisedDeliveryDate] DATETIME,

[LeadTimePromisedDeliveryDate] INT,

[QuantityOrdered] DECIMAL(38, 18),

[PostingDate] DATETIME,

[ShippingTime] INT,

[ActualDeliveryDate] DATETIME,

[LeadTimeActualDeliveryDate] INT,

[ShippedQuantity] DECIMAL(38, 18)

)

INSERT INTO SampleOrders (

[SalesOrderNumber],

[VersionNumber],

[ItemNumber],

[OrderDate],

[RequestedDeliveryDate],

[LeadTimeReqDeliveryDate],

[PromisedDeliveryDate],

[LeadTimePromisedDeliveryDate],

[QuantityOrdered],

[PostingDate],

[ShippingTime],

[ActualDeliveryDate],

[LeadTimeActualDeliveryDate],

[ShippedQuantity]

)

VALUES (

'S19856',

1,

'10568',

'2014-02-13 00:00:00.000',

'2014-03-14...

itortu (4/18/2014)

---

Down below is the SQL that creates the "Orders" table. It includes every version of an Order. In the code below, I used it to retrieve Order S20026. I...

itortu (4/18/2014)

---

I would like to try your code against my real tables, but how would I replace Orders? that is a table I just created to provide as an example.

When...

jeichelber (4/18/2014)

---

Hello all,

This feels like it is probably a noob question, but I don't know exactly where to post. (If this question is more appropriate in another forum, please let...

Louis Hillebrand (4/18/2014)

---

This looks me as a homework job, so the OP has to find the solution, that's why I didn't give the query,

Just a hint: Min quantity = 1,...