Topics
Started by
Posts
Last post
Hi, I've got a table with 110M+ rows. It is an SCD2 table with historic data. Most of the queries…
6 replies
(Edit: Should this be in the SSDT or Integration Services forum?) Hi, This post may be a bit like "…
2 replies
Hello, I am trying to format data in a specific way from one table. The columns look like …
2 replies
I have 35 tables all with a SSN column. I need to use a stored procedure and write a Select stateme…
30 replies
Can any1 help in update statement in coalesce statement Begin tran Declare @tran_hdr table ( tran_n…
9 replies
************* Got the solution ******************* Hi all, I hope and pray for everyone to be safe …
2 replies
Hi Having an issue creating a SP to create indexes for an overnight job on a replicated DB that doe…
10 replies
Hi, I have tried the select top 1000 rows and found out that it does not show the latest inserted/ …
6 replies
Dear All I have a question regarding decimal field, i have set field to DECIMAL (18,2) and it looks…
3 replies
Hello, I am trying to edit a procedure to add new points to existing points without resetting it. I…
6 replies
Getting the following error when running the below SELECT statement: "Invalid length parameter pass…
2 replies
I have this column in my table example below: Ace Master Agreement (IRE) Alzeee De Janeriro (FR) Al…
1 replies
Hi Friends, I have a stored proc with 45 tables that are used to store ssn's (All of the tables hav…
9 replies
Hello, I'm trying to write a AR aging select query that uses a case statement to indicate if the i…
13 replies
Hello All, I am about to do partitioning for my DW tables based on datetime and left range partitio…
6 replies
By: Saravanan_tvr
Viewing 15 topics - 976 through 990 (of 3,091 total)
You must be logged in to create new topics.