You are welcome!

I am satisfied you liked the article. I really struggled to keep it simple and consise. And as you write, my purpose was to give away the base...

SELECT TOP 50 PERCENT ?

The posted query can't be the complete query, right?

Use this function for very simple encryption/decryption

CREATE FUNCTION dbo.fnSimpleEncDec
(
@StringText VARCHAR(8000),
@PasswordCharacter CHAR(1)
)
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @Index SMALLINT,
@ReturnText VARCHAR(8000)






SELECT@Index = DATALENGTH(@StringText),
@ReturnText =...

You are missing the ItemType in your table definitions. Also you have renamed changeddate to balchangeddate in the query.

With the expected sample data above, what...

No, it is not difficult at all.

I don't like subqueries much (like SQLZ's solution which do the job), because they take too much time to execute.

Derived tables however I like...

If you only want unique Voyage_ID, this is the query to use

SELECT   MAX(Voyage_ID) Voyage_ID -- Or MIN if you prefer

FROM     MyTable

GROUP BY PlateNumber,

         StartDate

SELECT     z.Voyage_ID,

           myt.PlateNumber,

           myt.StartDate

FROM       ( 

               SELECT   MAX(Voyage_ID) Voyage_ID -- Or MIN if you prefer

               FROM     MyTable

               GROUP BY PlateNumber,

                        StartDate

           ) z

INNER JOIN MyTable myt ON myt.Voyage_ID = z.Voyage_ID

Maybe you can provide us with some additional information such as the real error message you get, and the real query?

First learn about arrays and list queries at http://sommarskog.se/arrays-in-sql.html and then realize that you are sending a lot of parameters to the stored procedure, instead of the intended array.

Remove all '...

How do you pass the string to the stored procedure? Via ADO Command Object?

And those financial fiscal year intervals are..?

I get a "403 Permission Denied" error....

We can't see your pictures since they are stored on your hard drive C:

Upload you pictures to a public web site (where we have access to read) and change the...

-- prepare test data

declare @test-2 table (SKU int, Status varchar(4), dt datetime, Warehouse varchar(2))

insert @test-2

select 111111, 'Sale', '1/1/2006', 'NY' union all

select 111111, 'Sale', '1/1/2006', 'TX' union...