Topics
Started by
Posts
Last post
I have this stored procedure that is inserting/updataing a staging tabe and another table. I dont h…
7 replies
Scenario: An SSIS package needs to read a flat file and insert it into the host SQL server DB tabl…
4 replies
Hi All, I have the below query , have set datefirst as Sunday (7), but here i am getting week 52 fo…
29 replies
I am having an odd issue. I have attached the SQL code and results below. For my Patient Gender, yo…
1 replies
Hello SSC, So, I inherited this code and trying to understand what this SUBSTRING is doing. I can s…
4 replies
Records Refrenace | DataMaster DataKey 1 A | A …
4 replies
hi, I am trying to migrate databases and we have huge tables like 30million records , and migration…
5 replies
Hello, I am interested in turning one column into multiple rows depending on the value. I tried a …
7 replies
thank you all!!! This topic was modified 3 years, 2 months ago by fri. This topic was…
9 replies
I have an SSIS package which is copying 5 large tables daily. There is no WHERE logic in these data…
6 replies
i use exec dbo.sysmail_start_sp to start DB Mail but it keeps running forever. When i check the sta…
3 replies
What is the easy way to purge ExternalMailQueue ? I tried using END Conversation command but it tak…
1 replies
Consider that i have 2 tables like as bellow : The first table contains the table that i want to up…
3 replies
I'm trying to add some more robust error handling to my packages. I'm adding Try/Catch to all my Sc…
1 replies
Hey All, We have a very big table which stores transaction data and it is SCD Type 2 table. Records…
2 replies
Viewing 15 topics - 121 through 135 (of 1,544 total)
You must be logged in to create new topics.