yes yes

you right

TNX

how

i must...

TNX it help

it working 100%

can i do this is it right ?

i need to know

i must to search between 2 rows

1 )day before Last day of the Previous Month

2)"day before...

can i use it inside a view ?

this is my table

my table

----------------------

empid basedate unit_date shift...

hi

i ask the friends here if thay can help only !

i am working on complex project and i need it

to find the "day before Last day of the...

tnx

i have only 3 tables

1) employee_tb

empid name

---------------------

12345678 abc-defg

98765432 hijk-lmno

........ ..........

100...

TNX men

i try to do it + fiil the zero value :hehe:

the main problem i need to do it to specific month in year

how to do it like this ?

select...

OK OK

it work but to convert it to a view OR function

this is the working code

----------------------------------------

SET NOCOUNT ON;

IF OBJECT_ID('dbo.Nums') IS NOT NULL

DROP TABLE dbo.Nums;

GO

CREATE TABLE dbo.Nums(n INT...

John Mitchell (12/20/2007)

---

No loop is necessary, especially a loop within a loop, which would kill performance if you have a lot of data. It should be possible to solve...

wow complicated

friends

can someone please please

sohw me example how to do it

TNX

i think this can help

http://www.sqlservercentral.com/Forums/FindPost433662.aspx

Jason TNX

To change to your language, change the language of the user account connecting.

Assume you run this statement Tuesday December 11, 2007

If the user account language is english then the...

Derek Dongray (12/10/2007)

---

Please post what you've tried and, if I have time, I'll see where you are going wrong if I have time. Like most people here, I don't get...

this function working ok whan spliting the employee shift value (1,1,2,2,3,3,4,5) .

but for the "UNIT" value for

the employee i need that value "UNIT" the value(1,2,3,4)

change evry first day in the...

need help with this function !

first prolem

this line

--------------------------------------------------------

(convert(int,(datediff(dd,b.unit_date,d.dt) / 30)) % 4) + 1)

-------------------------------------------------------------

i don't get in unit value the correct division the "/30"

how to handling in month 28...