Topics
Started by
Posts
Last post
Hi Can this work ? update ventven vv1 set vv1.mtht = vv2.mtht, vv1.mthtsp = vv2. mthtsp, vv1.mthtax…
10 replies
Hi all, When we want to check the access privilege of a partic…
2 replies
I have a complicated and interesting problem here for you. I am currently working on a data cleans…
9 replies
Please help with this newbie syntax problem. I would like to populate my table variable with a comp…
4 replies
does anyone know how to select (delete) the second of a pair of rows in 1 table that are joined by …
2 replies
When editing Stored Procedures through QA, it adds a blank line at the beginning & end. Is ther…
9 replies
I want to perform a left join between two tables, summing the values, and have it return a value fo…
10 replies
SQL Server 2000. What are the basic steps to updating a table based on an outside source?&nb…
6 replies
Hi Everyone I have 3 tables Employee(emp_id emp_name) example of data 1, John 2, Mary 3, Jo Empdept…
4 replies
Hi Folks, I have a table called base1005 (word 'base' and mmyy) in my database and i am …
8 replies
Hi all! I'd like to manage the inserts of table A with a stored procedure, so I created an instead …
2 replies
Hello guys. I need to get the time the employee has been working, but I get that a DATEDIFF is inna…
5 replies
I have a table (any table will do) that has an ID column (the primary key) and a bunch of other col…
13 replies
if the if exists ( DOES NOT EXISTS)?? Hello, my querry is working fine until i added this piece o…
2 replies
I have an existing sp, usp_Proc1. I have another sp, usp_Proc2, that is exactly like usp_Proc…
3 replies
Viewing 15 topics - 8,491 through 8,505 (of 17,082 total)
You must be logged in to create new topics.