Topics
Started by
Posts
Last post
Hi. I have been asked to insert all Products from table Products into ProductProductCategories wher…
4 replies
Dear Friend, My situation as follows i have two databases , each databases are in different locati…
1 replies
I'm very new to Pivot Tables in SQL 2005, after working with the TSQL for a while, I final got scri…
7 replies
hi guys, what is the best way to delete two million rows from a table that the date created is afte…
25 replies
There is a table UDF in the script section of this site that I have used in times past. It can take…
1 replies
WAREHOUSE acts as an inventory. The Trigger should update the WAREHOUSE.ItemQty column. After testi…
3 replies
whats the correct way to write this i keep getting this error: Msg 205, Level 16, State 1, Line 1 A…
8 replies
I need to run an update statement from a sql server in a primary location that will update tables i…
3 replies
Hello, I'm having problems achieving this: I have a list of purchases by client. Something like: T…
2 replies
I have a table or you can say a result of query is like that A B _______ a x1 a x2 a …
2 replies
Hi, I created a database user and assigned required permissions. Then I created a database with the…
1 replies
Hi people. I need sql to log activity happening in our database, particularly when requests are mad…
5 replies
DECLARE nId NUMBER; BEGIN INSERT INTO TABLE A ( name, age ) VALUES ( 'X', 12 …
1 replies
Hi all, I'm trying to send a sql statement using sp_send_dbmail procedure. Result should be attache…
2 replies
Hi, I have below Select statement ... with 3 columns (DOC, PRODTYPE and TERM). In TERM field, there…
3 replies
Viewing 15 topics - 8,296 through 8,310 (of 12,234 total)
You must be logged in to create new topics.