<div>
Please craft and post a concise and complete example.
</div>


<div>
Hi<br><br>Thanks for your response. I have a table in sqlserver as below:<br><br>CREATE TABLE [dbo].[stg_emp_rewards_data](<br>&nbsp; &nbsp;[Given_By_Employee_ID] [varchar](50) NULL,<br>&nbsp; &nbsp;[Given_By] [varchar](100) NULL,<br>&nbsp; &nbsp;[Given_To_Employee_ID] [varchar](50) NULL,<br>&nbsp; &nbsp;[Given_To] [varchar](100) NULL,<br>&nbsp; &nbsp;[Program_Name] [varchar](100) NULL,<br>&nbsp; &nbsp;[Program_Code] [varchar](100) NULL,<br>&nbsp; &nbsp;[Is_Event_Based] [varchar](100) NULL,<br>&nbsp; &nbsp;[Citation] [varchar](100) NULL,<br>&nbsp; &nbsp;[Reward_Points] [varchar](100) NULL,<br>&nbsp; &nbsp;[Given_On] [varchar](100) NULL,<br>&nbsp; &nbsp;[Recognizer_BU] [varchar](100) NULL,<br>&nbsp; &nbsp;[Recognizer_Designation] [varchar](100) NULL,<br>&nbsp; &nbsp;[Recognizer_Location_Type] [varchar](100) NULL,<br>&nbsp; &nbsp;[Receiver_BU] [varchar](100) NULL,<br>&nbsp; &nbsp;[Receiver_Designation] [varchar](100) NULL,<br>&nbsp; &nbsp;[Receiver_Location_Type] [varchar](100) NULL,<br>&nbsp; &nbsp;[Vals] [varchar](100) NULL<br>) ON [PRIMARY]<br>GO<br><br>I need to load the attached Json file data into this table. If you need any further details Please let me know<br><br>Regards<br>Naren<br><br><br><br><br><br><br>
</div>


Naren Ko

<div>
is it possible to delete the attachment from the question I posted? Since my need was dire i attached the real time data . is there anyway i can delete the attachment?
</div>


<div>
<div class="content wysiwyg-content fr-view">
I am having json file without column value pair. the file format contain the column header followed by data. I loaded json files into sqlserver &nbsp;having array. this file format looks different. Please assist me in loading this file into sqlserver database.<br><br>Please find the attached file<br><br>Regards<br>Naren<br><br>
</div>
</div>



I am having json file without column value pair. the file format contain the column header followed by data. I loaded json files into sqlserver  having array. this file format looks different. Please assist me in loading this file into sqlserver database.
Please find the attached file
Regards
Naren

loading json  file into sql server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.