thanks for the reply, i used the following to get the date and also the week select convert (varchar,getdate()-7,112)+ convert...
Hi, I need to select date for my project. I used the following select datepart(yy,getdate()) select datepart(mm,getdate()) select...
Hi guys this worked Connect to your Server, go to security folder, drill down to logins, right click, create new login. Once the new login is...
hi, i tried to create a sql authenticated login by right click security,new login and follow the steps needed but once i finish creating, i could not...
Hi, i dont really understand how to do this. Number column will only contain numbers from 1 to 53.
Hi, I have a table called Past with 4 columns(Number,WW,Goal,Eng) and in Number column has 53 rows, 1,2,3 - 53. Now i need to update the 53rd row...
Hi, i used the following to insert data from one table to another. How do i add % to the value that i insert? Insert into A ( AA ) Select BB from B...
Hi, I need one week before the current week. How to get that? Example, this is week17 (WW17) so i need to have WW16. Please advice. Thanks
Hi, can anyone suggest me how to make the incresing order to be reset after WW52 and start again from WW01?
Hi I used the following and it works thanks.. UPDATE ABCSET B = substring(B, 1, 2) + cast(cast(substring(B, 3, 10) as int) + 1 as varchar(8))WHERE...
hi, i think your answer is almost close. Im receiving result as ww1 no matter how many times i execute. It should keep increasing right? How to fix...
i can schedule the update but i just dont know how to make the WW15 to WW16 and so on each week. I think i must use the variable i but i dont know...
Hi, I have a table ABC. It has 2 columns, A and B. At column A i have 3 rows, Week,Goal,Used. Let say for column B at row Week is WW15 now, after 7...
Hi, when i use your query it says error near keyword "AS". How to fix this? thanks
Hi, I need to update column week14 in table PastWeeks with data from Eng_Goal and then result of some calculation from table AverageEngTime in the...
Even if I use update command, im getting error at where statement. Please help..thanksdeclare @Weekday tinyint, @hour int select @Weekday =...
Hi, I have two tables, Weekly and AverageEngTime. Weekly table has 14 columns, "Mon_Day,Mon_Night,Tue_day,....Sun_Night". AverageEngTime table has 15...
Yes, but now Im in the following part of the project where I need to get the average of the columns once they are updated and then insert the average...
Thanks for the input, now i used the following and it works.. Sat_Day=CASE WHEN (@Weekday= 7 and @hour >= 19 ) OR (@Weekday= 1 AND @hour <7))
Thanks man, it works.
Separate names with a comma.
