Topics
Started by
Posts
Last post
We have ID columns with values with up to 10 digits. Those ID's are usually third (and last) segmen…
8 replies
I have a target and a source table where I want to update the target from the source. I have one n…
11 replies
Wasn't sure how to word the title 🙂 I'm working on a method to take user input to update a (target)…
3 replies
Hi I am using a script to get details about database name, schema name, table name, row count and s…
1 replies
I have 3 source table and have to union them all source 1: Id name car 1 aaa BMW 1 aaa …
2 replies
hey i have link server to oracle from mssql. i want to update or insert with four part. 1. how can…
1 replies
declare @dte datetime Select @dte = GETDATE() @dte = 2016-10-31 11:42:51.920 Is it possible to co…
4 replies
We have a DataWarehouse with Large Fact Tables . The Some of the tables have about 30 to 60 Columns…
6 replies
experts, i am trying to calculate Overtime hours . we have got employee who has Friday and Saturda…
3 replies
I have two tables CREATE TABLE [dbo].[StatusAudit]( [RowID] [int] IDENTITY(1,1) NOT NULL primary…
1 replies
Hi All Our dev team is growing. We use red-gate toolbox, so we have schema compare, data compare an…
13 replies
I have a scenario where I have to create a replication of a target table along with source Id field…
3 replies
I am currently struggling with a query to recurse up/down a tree. In real life we have a junction …
2 replies
Dear All, I would like to get query with page break which after each group(preffered_name) results …
1 replies
I have a stored procedure that drops temp tables using dynamic sql. Immediately following that stor…
4 replies
Viewing 15 topics - 1,771 through 1,785 (of 3,067 total)
You must be logged in to create new topics.