Got it!  Thanks for the explanation.

Hi Ninja -

Could you please give an example?  I'm not following how this makes concatenation work easier. 

Thanks,

Susan

Hi Roberto,

Thanks a lot for the advice and the links.

Keep well,

susan

These are both great suggestions.  I'm wondering whether there's anything built-in in SQL Server that I could use, instead of a 3rd party encryption system. 

Maybe instead of asking about...

Soumna,

Thanks for posting the solution!

Hi Janet,

Rather than going through all of your code and changing SQL statements, I think you'd be better off fixing your data: run update queries to change...

We had a similar need to execute a parameter-driven Oracle stored proc from SQL server. We do this using linked server, via a small Oracle table with an...

What if no new records are added to the Orders table? Wouldn't this query always return the same 10 records? How is that random?

I'd convert the 3 dates to YYYYMM format:

SELECT * FROM table_name

WHERE CONVERT(char(6), some_field,112)

BETWEEN

CONVERT(char(6), lower_date_field,112)

AND

CONVERT(char(6), upper_date_field,112)...