Search results for query: *

Datatype is datetime Size is 8

Let's say I enter 12-01-2006 (january 12th) In my calendar table the entry is 2006-01-08(january 8th) 0 // 16 // 16 // 16 // 16 // 16 // 0 Where the week starts with Sunday and ends with saturday. The resulting table is Dates // Column name 2006-11-26 00:00:00.000 // 25 I think months...

I dont now if this can help, but my date format is yyyy-mm-dd

I tried your last in query analyser and it gives me Dates///////Days 2006-12-31//15 Since 01/01/2007 is a non-worked day, the result should be 0 Sorry for the delay I was working on another project

I entered the NEW code you gave me in the SQL panel of SQL enterprise manager, then I click the Run button, but it tells me that 1 row is affected by the last query again. Maybe I should specify where to save the new table? BUDGET.dbo.CALENDRIER_FONCTIONNEL was the new table created in the...

SET DATEFIRST 7 Declare @Dateent datetime --The date entered by the employee Set @Dateent = '1/1/2007' IF DATEPART(dw, @Dateent) <> 1 SET @Dateent = CONVERT(varchar(8), @Dateent - DATEPART(dw, @Dateent) + 1, 112) CREATE TABLE BUDGET.dbo.CALENDRIER_FONCTIONNEL (Dates DateTime,Days Int)...

It gives me an error prompt when I try the query. '1 row affected by last query'

If I had the possibility to create a GOOD table that act as a calendar where you can enter a worked day or a non-worked day, how should I do it?? What structure would be easier for retrieval considering my previous post? Note that I'm a beginner with SQL and that I'm trying to gather as much...

I am doing a report with Infomaker. The user will enter a date(I choose the retreival criteria), and will have various information that depends on the number of days since the beginning of the week, the beginning of the month, and the beginning of the year. (sales for the day, the week, the...

If you have some time to explain it, it would be appreciated. Thank you.

And what if he enters a date between two Starting Dates ?

SQL Server Enterprise Manager I don't have full access.

I guess I'll have to find some kind of way to do it. I cannot change the database =( Thank you for your advise.

It's similar to my other post... I have a table like this //STARTING_DATE//DAY1//DAY2//DAY3//DAY4...//DAY7 //////////////////////////////////////////////// //2005-01-02 // 0 // 16 // ... //2005-01-09 // 0 // 18 // ... //2005-01-16 // 0 // 18 // ... //2005-01-23 // 0 // 18 // ...

ok thx i'll give it a try....your help is very appreciated!

I have a table like this //STARTING_DATE//DAY1//DAY2//DAY3//DAY4...//DAY7 //////////////////////////////////////////////// //2005-01-02 // 0 // 1 // ... //2005-01-09 // 0 // 0 // ... //2005-01-16 // 0 // 0 // ... //2005-01-23 // 0 // 1 // ... //2005-01-30 // 0 // 1 // ...