Thanks for the information .

SELECT EQ.EmpDegree, EJS.ProjectName, EPD.HireDate FROM dbo.EmployeeQualification EQ

INNER JOIN dbo.EmployeeJobStatus EJS ON EQ.EmpID=EJS.EmpID LEFT OUTER JOIN dbo.EmployeePersonalDetail EPD...

Please provide an information wheather there are 3 colums in your sheet or 2 columns .

create PROCEDURE [dbo].[proc_AdditionalInfotbl] (@jobtbl JobTableType READONLY) AS

Begin

Update additionalinfo

Set RunningUnwind = Case unwindfrnt when 5 then 1 when 6 then 2

when 7 then 3 when 8 then 4 else...

delete from [table_name] where %%lockres%% in (

select MAX(%%lockres%%) from [table_name]

group by [column_name])

With the help of the above query you will meet your needs.

where [table_name] ...

Hi , Thanks for sharing so important comcept .

But can't we perform join in this way becz in the output result we are getting colum names like

(C.Componentname or P.projectname...

Editor: Post removed as it was copied from another source.

The validation of scripts examines the syntax of each Transact-SQL statement and returns any errors without compiling or executing the statement.

To validate the syntax of your query from the toolbar...

By uisng the below string and conversion functions you can meets your requirements.

SELECT CONVERT(VARCHAR(30),GETDATE(),121) + ' ' + SUBSTRING( CONVERT(VARCHAR(30),GETDATE(),0),18,1000).