Topics
Started by
Posts
Last post
I'm not sure when, but years ago as a BASIC programmer, I picked up the habit of checking to see if…
4 replies
Hi folks, I have a 2012 sql and it works very fast, one of the most used queries is a table functio…
13 replies
Greetings, I'm struggling to find a solution to find when a value is set or changed to specific val…
10 replies
Hi, I have a requirement to only execute the SP on tuesday and friday. The SP is called within the …
7 replies
I have two tables and I want to do a recursive query in order to get a final table with a parent-ch…
3 replies
Hi Experts . I have table Temp_decimal_mismatch which has duplicate data . The duplicate data is no…
7 replies
I am currently trying to dedupe a customer table based on both the email and phoneno fields. I can …
4 replies
Hi, I am working on optimizing some of Tsql code for SP's. I know we have formatting tools which he…
8 replies
Hi All, In my environment, we are getting huge account of refresh activities coming from to product…
2 replies
Here is sample code from my running total, now I need to reverse it and add a where exists clause t…
3 replies
USE Test GO IF OBJECT_ID('customer') IS NOT NULL DROP TABLE dbo.Customer GO -- PK or unique key i…
4 replies
I tried Googling this but most complaints seem to be that SSIS is giving people truncation errors w…
9 replies
Hello, I think my requirement is fairly straight forward, but cant seem to get the syntax right or …
20 replies
Table 1 is missing an index that was supposed to be in place when the table was created that is set…
7 replies
I have a table : tableA with the following column names: DateCol1,Col2,1,2,3,4,5,6 so there are 8 c…
1 replies
Viewing 15 topics - 286 through 300 (of 4,984 total)
You must be logged in to create new topics.