Hi, I need to select date for my project. I used the following select datepart(yy,getdate()) select datepart(mm,getdate()) select...
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 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 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, 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...
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...
Hi, I used the following code to update my table after each shift, But i noticed that when one column is updated the previous updated column is being...
Hi, I used the following query to select and insert data from ALD table into Weekly table by shift. When it is Monday morning,data should be pushed...
Hi, I have a table called Daily. It has 5 columns, "Testers ","Activity ", "GivenHours ","UsedHours " and " Delta ". This table will be regularly...
Hi, i need to send emails from sql server with a table from my database as the body of the email. I understand that i have to configure my database...
Hi Im new to sql. I have to select a table from sql database and send the table to a person every 10am. How to do it? Thanks..
Hi Im new for SQL, I have 2 tables in sql database, "Daily" and "Tester". Daily has a column called Hours given. Data for that column should be taken...
Separate names with a comma.
