Guru E. Technology

need of every business.

SQL Server

How to Get Unique Item with Latest Date of Entry

Situation is, I have a table which contains multiple records of a item but with different date. For example, I have table of workers which contains the Id, Name, WorkingDay column similar to below table: ID NAME WorkingDay 1 VJ 15-Mar-2012 2 AP 15-Mar-2012 3 TS 15-Mar-2012 1 VJ 16-Mar-2012 2 AP 17-Mar-2012 I want […]

Tags: , ,

Posted in SQL Server | No Comments »

How to Update a Column Value from Another Table

While working with SQL Table and queries most of the time we have to face this scenario to create or update a table with another table values. So I am going to demonstrate a simple example here. I have a table1 which has following structure. ID | Name | State =================== 1 | Ap | […]

Posted in Developer Solutions, SQL Server | No Comments »

How to Load XML file into SQL Temporary Table

Well, this is very interesting! We can load complete XML file into SQL table and Add/Update records for the table. It was not easy earlier as it seems to be iterating all the nodes picked the value and then insert into table hu! really tough Job. I will explain you how you can load XML […]

Tags: , , ,

Posted in SQL Server | No Comments »