I have a table with 3000 Client_id's.

I have another table with 56 different order types.  The order types
primary key is two fields (search_id, item_id)

I need to insert into another table each client_id, along with each
unique instance (56 instances) of search_id, item_id.

So the new table would have 3000 (client_id's) x 56 (distinct order
types) = 168000 rows.

What would be the easiest to go about this?

Thanks.

How to concatenate strings from a column into a single row (with NULL value)?
xp_cmdshell - works with string in one format but not in another -
Query help
Single to Multiple columns
Assistance with SQL Script