Thanks Pw,

Using profiler, I think I know why it is not working. The executing command: exec sp_executesql N'INSERT INTO "<DataBaseName".."Orders" ("Id",...) VALUES (@P1,...) is not including the PkgCodeID field in...

Since I didn't write the app, I am not sure except that it is not a stored procedure. I am familiar with all of the stored procedures on the server,...

Thanks Noel,

I have learned how to do most of the things I need to in T-SQL, but now I am trying to learn how to do them right.

Thanks for your...

Is there a 1 to 1 relationship between voucher payments in tbl1 and tbl2? I think that it could be done with a cursor on tbl1 if there is no...

Would this give the results you desire?

select col1, col2 from test where col1 < col2

union

select col2, col1 from test where col2 <= col1

Still learning, but I think it would do...

Using Farrell's table, I think that this variation of some of the previous solutions will do what you want:

SELECT DISTINCT ac.AccountNum, ac.EffBeginDate, ac.EffEndDate

FROM #Account ac

     JOIN

     (SELECT AccountNum,...

Thanks for the suggestion.  We used another method to accomplish the goal without the stored procedure, but I will experiment with this anyway as I get time for future reference.

I...

You solved the problem!  Somehow the compatibility level had been changed to 70.

I don't know how it got changed, but thanks for you...

Thanks, stacenic

I think that this will do what I want it to do.  It worked on the test data, so I think I can adapt it work on the real data....

SubjectID is char, but will always contain numerical values, so can successfully be cast as int.

Thanks for the input. I am learning much from this forum. I didn't consider that it might work if varchar, since most of the tables I work with use char()...