Topics
Started by
Posts
Last post
Hi All I am new to merge statement so need your help in making it better understanding for my task.…
3 replies
I have a database restored on two seperate servers. The data in the database on each server is iden…
8 replies
Hi All, i have this data: declare @vartable TABLE( PAY_CYCLE varchar(50), PAY_CYCLE_SEQ_NUM INT, V…
5 replies
Hi SQL Experts, I'm trying to automate a rather complicated process. The process compare numbers of…
4 replies
Hello, Currently in the below stored procedure, I'm using a table variable to fetch results from th…
2 replies
When developers are running cast on one of the systems the day and month are transposed. eg SELECT …
9 replies
Hi, I am ok using MERGE I think its a great compromise on using separate commands but is there a wa…
13 replies
I know this has been asked alot and I have read through a lot of articles on using pivots, row_numb…
7 replies
Hi All, i am trying to update some a table from another table in another database but am getting th…
4 replies
Have a table data as below. UserID| ObjectID | Cid| Launch| startDate -----------…
4 replies
I have a staging database and also a production database. I also have two ssis package to load data…
9 replies
My predecessor came up with the following rule: When doing table joins, always use the INNER JOIN /…
18 replies
I have a program that dumps data into a table nightly. After the program is done. I end up with a 8…
10 replies
Hi, I have two tables: Table 1 Account Amount 1 1000 2 500 3 1000…
1 replies
Hi, i'm not able to index a view as it is built on several tables from different servers. does the…
12 replies
Viewing 15 topics - 6,826 through 6,840 (of 10,647 total)
You must be logged in to create new topics.