Comments by Member 10017719 (Top 30 by date)

Thank u Andrius, 10000 is montly salary, salary per day=(montly salary/total days of month)
if fromdate='2014-04-20' and todate='2014-04-23' Working days=3 so, Salary Calculation=(10000/30)*3=1000

Ya Correct!

Ur question is not clear:)

Can u elaborate ur question?

Ya it's possible

Thank you Schatak...gr8

Ya I have tried with dynamic sql also as follows

SELECT TOP 1 @First_CName=COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=@Table_Name

SET @From_Value=CAST(@fromId AS VARCHAR(50))
SET @To_Value=CAST(@toId AS VARCHAR(50))

SELECT @SQL='SELECT * FROM ' +@Table_Name+ ' WHERE '+ @First_CName +' BETWEEN CAST(' +@From_Value+' AS INT) AND CAST(' +@To_Value+ ' AS INT)'-- ex: @fromId=45 and @toId=46(inputs)

EXEC sp_executesql @SQL


Its returning error:The parameters supplied for the batch are not valid.

Actually that column name I am passing to that variable right.. Now @First_CName=ColumnName of table

Id Name
======================
1 John
2 Mark
4 Peter
6 Joe

I m not skipping 5..consider id 5 is not available

1,3,6... Its not depend on multiples of any number..its depend on occurence of input number

Awesome...:)

Thank u Raul Iloc

Can u post ur question still clearly

ya Humayun Rashed

U can use While loop in sql server

Can u explain your method

I did tat also plz see SP

I m getting Imei_Number Karthick.Thats no probs

Thank u abhijitmalkar but still its returning null for lat and long....

Thank u so much karthik.But still its returning null

I checked manually also its executing but table does not contains values

Thanks OriginalGriff.....Error like must declare scalar variable @gps..

Thanks Karthick for ur reply but still same issue..Query is executing but values have'nt inserted in table