Hi you can do something like this.
DECLARE @CT INT
SET @CT = (SELECT COUNT([pWholesalePrice]) FROM [dbo].[Products])

IF ISNULL(@Ct,0) > 0
BEGIN
    --update

Ok thank you

This is purely hypothetical to see if it's possible to pass a table to a function created by the statement 
;WITH
Is it not possible?

They're grouped 

CREATE TABLE [dbo].[Title]( [ID] [int] NULL,
[Description] [varchar](50) NULL,
[Dept] [varchar](50) NULL
) ON [PRIMARY]

INSERT INTO [dbo].[Title]([ID],[Description])
VALUES(1,'Architect','IT')

INSERT INTO [dbo].[Title]([ID],[Description])

This is just dummy data to show how I need the data displayed in 3 columns.

It's not a good file and I need to filter the insert. Can you select certain columns and add a where clause?

It's separated by tab, thank you.

The flat file looks like this.

...

What about Windows 10?

I followed this https://blogs.msdn.microsoft.com/cesardelatorre/2011/03/27/the-application-has-failed-to-start-because-its-side-by-side-configuration-is-incorrect-error-related-to-mmc-exe-programs-and-weird-cause-simple-solution/. This is what was in the C:\MySxSTrace.log :crazy:

Ð Ð ...