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
By: LearnSQL
I am having an odd issue. I have attached the SQL code and results below. For my Patient Gender, yo…
1 replies
By: Jeffs1977
Hello SSC, So, I inherited this code and trying to understand what this SUBSTRING is doing. I can s…
4 replies
By: MMartin1
Records Refrenace | DataMaster DataKey 1 A | A …
4 replies
By: MMartin1
hi, I am trying to migrate databases and we have huge tables like 30million records , and migration…
5 replies
By: Lynn8968
Hello, I am interested in turning one column into multiple rows depending on the value. I tried a …
7 replies
By: sgmunson
thank you all!!! This topic was modified 3 years ago by fri. This topic was modified …
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.