I suspect you just need this:
CREATE TABLE dbo.Orders (
    ORDER_NUMBER numeric(15, 2) NOT NULL CONSTRAINT [DF_Orders_ORDER_NUMBER] DEFAULT ((0)),
    ST_ID numeric(10) NOT NULL CONSTRAINT [DF_Orders_ST_ID] DEFAULT ((0)),
 ...

Just wondering why you would populate said temp table with 0 records when the user has access to ALL sites.   If you simply copied all the PK values for the...

And another thing..  If you use an IF statement where ReadLine is used, remember that it reads the line, and the line pointer will have moved, so you only get...

You've had no replies...  probably because this isn't a SQL Server problem, per se...  it's more of a problem with programming in C#.   However, that said, some things that usually...

I suspect you're getting an implicit conversion issue.   Somewhere in your processing, that data type of VARBINARY(40) is getting implicitly converted, and that succeeds because the resulting data type is...

FYI, if you have a GROUP BY in the query with the OR in the JOIN, then you have a different kind of problem, and the solution is more likely...

Well, there's always INFORMATION_SCHEMA.COLUMNS to play with.   If you go the dynamic SQL route, you can find all the column names for any given table, and then use the QUOTENAME...

Just a quick note on this...  using DISTINCT guarantees you only see one row of output per unique combination of values in the table rows for the specified columns.  Not...

Try this:-- temp TABLE
IF OBJECT_ID('tempdb..#SampleData', N'U') IS NOT NULL
    BEGIN
    DROP TABLE #SampleData;
    END;

SELECT *
INTO #SampleData
FROM LogFile;

--FIRST TO BRING IN SEQ2 IN A...