SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE lkpTable (
  "TableName" sysname,
  "requiredcolumns" nvarchar(max)
);

INSERT INTO lkpTable
  ("TableName", "requiredcolumns")
VALUES
  ('Pricedetails', 'sellingPrice,RetailPrice,Wholesaleprice'),
  ('Itemdetails', 'ItemID,Itemprice');

CREATE TABLE Pricedetails (
  "Priceid" INTEGER,
  "Mafdate" VARCHAR(10),
  "MafName" VARCHAR(8),
  "sellingPrice" FLOAT,
  "RetailPrice" FLOAT,
  "Wholesaleprice" FLOAT
);

INSERT INTO Pricedetails
  ("Priceid", "Mafdate", "MafName", "sellingPrice", "RetailPrice", "Wholesaleprice")
VALUES
  ('01', '2020-01-01', 'Americas', '25.00', '43.33', '33.66'),
  ('02', '2020-01-01', 'Americas', '43.45', '22.55', '11.11'),
  ('03', '2021-01-01', 'Asia', '-23.00', '-34.00', '23.00');

CREATE TABLE Itemdetails (
  "ItemID" INTEGER,
  "ItemPrice" FLOAT,
  "Itemlocation" VARCHAR(8),
  "ItemManuf" VARCHAR(2)
);

INSERT INTO Itemdetails
  ("ItemID", "ItemPrice", "Itemlocation", "ItemManuf")
VALUES
  ('01', '45.11', 'Americas', 'SA'),
  ('02', '25.00', 'Americas', 'SA'),
  ('03', '35.67', 'Americas', 'SA');

8 rows affected

TableName	ColumnName	IsInt
Pricedetails	Not All ints	sellingPrice
Pricedetails	Not All ints	RetailPrice
Pricedetails	Not All ints	Wholesaleprice
Itemdetails	All ints	ItemID
Itemdetails	Not All ints	ItemPrice


SELECT
  TableName = 'Pricedetails',
  ColumnName,
  IsInt
FROM (
    SELECT 
    [sellingPrice] = CASE WHEN COUNT(CASE WHEN ROUND([sellingPrice], 0) <> [sellingPrice] THEN 1 END) = 0 THEN 'All ints' ELSE 'Not All ints' END,
    [RetailPrice] = CASE WHEN COUNT(CASE WHEN ROUND([RetailPrice], 0) <> [RetailPrice] THEN 1 END) = 0 THEN 'All ints' ELSE 'Not All ints' END,
    [Wholesaleprice] = CASE WHEN COUNT(CASE WHEN ROUND([Wholesaleprice], 0) <> [Wholesaleprice] THEN 1 END) = 0 THEN 'All ints' ELSE 'Not All ints' END
    FROM [Pricedetails]
) t
UNPIVOT (
  ColumnName FOR IsInt IN (
    [sellingPrice], [RetailPrice], [Wholesaleprice]
  )
) u

UNION ALL 
SELECT
  TableName = 'Itemdetails',
  ColumnName,
  IsInt
FROM (
    SELECT 
    [ItemID] = CASE WHEN COUNT(CASE WHEN ROUND([ItemID], 0) <> [ItemID] THEN 1 END) = 0 THEN 'All ints' ELSE 'Not All ints' END,
    [ItemPrice] = CASE WHEN COUNT(CASE WHEN ROUND([ItemPrice], 0) <> [ItemPrice] THEN 1 END) = 0 THEN 'All ints' ELSE 'Not All ints' END
    FROM [Itemdetails]
) t
UNPIVOT (
  ColumnName FOR IsInt IN (
    [ItemID], [ItemPrice]
  )
) u

Warning: Null value is eliminated by an aggregate or other SET operation.