Comments by abhijitmalkar (Top 8 by date)

CREATE PROCEDURE [dbo].[InsertRowInPersonelCard]
(@personelcode varchar (50),
@fk_month int,
@fk_year bigint,
@vacationhours time(7))
as
DECALRE @empID INT

SELECT @empID=empID FROM EmploymentInfo WHERE FK_pID =(SELECT pID FROM PersonelInfo WHERE FK_pID=@personelcode)

insert into PersonelCard(FK_empID,FK_month,FK_year,VacationHours)
Values(@empID,@fk_month,@fk_year,@vacationhours)

insert into ICardDate(FK_empID,Imonth,Iyear)
Values(@empID,@fk_month,@fk_year)

SELECT
CAT_ID
,CAT_NAME
,SCAT_NAME
,SCAT_IS_ACTIVE
FROM
Category
INNER JOIN SubCategory ON Category.CAT_ID = SubCategory.SCAT_CAT_ID
INNER JOIN AppStatus ON SubCategory.SCAT_IS_ACTIVE = AppStatus.STS_IS_ACTIVE
WHERE AppStatus.STS_NAME='created'
-----IF U WANT MODIFIED RECORDS THEN RELACE WHERE CLAUSE AS
WHERE AppStatus.STS_NAME='modified'
-----IF U WANT FEATURED RECORDS THEN RELACE WHERE CLAUSE AS
WHERE AppStatus.STS_NAME='featured'

SET @Latitude_Val='SELECT Latitude FROM dbo.'+@Imei_Table+' WHERE Imei_Id= '+CAST(@Imei_PK AS VARCHAR(50))
SET @Longitude_Val='SELECT Longitude FROM dbo.'+@Imei_Table+' WHERE Imei_Id= '+CAST(@Imei_PK AS VARCHAR(50))
---------------------------- OR-------------------------------------------
SET @Latitude_Val='SELECT Latitude FROM dbo.'+@Imei_Table+' WHERE Imei_Id= '+CONVERT(VARCHAR(50),@Imei_PK)

SET @Longitude_Val='SELECT Longitude FROM dbo.'+@Imei_Table+' WHERE Imei_Id= '+CONVERT(VARCHAR(50),@Imei_PK)



THERE IS AT LEAST ONE SPACE IS REQUIRED WITH IN TABLE NAME AND WHERE CLAUSE