Topics
Started by
Posts
Last post
I have an SSIS package which is copying 5 large tables daily. There is no WHERE logic in these data…
6 replies
hi, I am trying to migrate databases and we have huge tables like 30million records , and migration…
3 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
I have an SSIS package that's looping thought a folder of Excel files and loading them into SQL Sta…
17 replies
By: Ed B
One of the dbmail is getting delivered thousands of time. Same recipient, same subject , same body.…
2 replies
Good Morning. I made a view with select in SQL. I need the negative numbers to be in green color, a…
6 replies
Hi All, I have around 120 columns and it has around 1 million record. Use to receive a csv file and…
3 replies
Good Morning I need to subtract : a.[Vendas Ultimo Ano]-2.STKActual and b.[Vendas Ultimo Semestre] …
5 replies
I need to add xml data stored in multiple rows in a table to a XML document by using XML.modify W…
2 replies
Records Refrenace | DataMaster DataKey 1 A | A …
3 replies
Hello SSC, So, I inherited this code and trying to understand what this SUBSTRING is doing. I can s…
3 replies
Viewing 15 topics - 1 through 15 (of 1,429 total)
You must be logged in to create new topics.