Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Another question
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... -
Another question
I dont now if this can help, but my date format is yyyy-mm-dd -
Another question
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 -
Another question
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... -
Another question
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)... -
Another question
It gives me an error prompt when I try the query. '1 row affected by last query' -
Another question
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... -
Another question
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... -
Another question
If you have some time to explain it, it would be appreciated. Thank you. -
Another question
And what if he enters a date between two Starting Dates ? -
Another question
SQL Server Enterprise Manager I don't have full access. -
Another question
I guess I'll have to find some kind of way to do it. I cannot change the database =( Thank you for your advise. -
Another question
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 // ... -
Need help with a query plz
ok thx i'll give it a try....your help is very appreciated! -
Need help with a query plz
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 // ...
