Topics
Started by
Posts
Last post
Hello folks, Even writing the title, it sounds oxymoronic but bear with me. We have a third party v…
3 replies
I want to be able to recursively go through the contents of a temp table without using a loop and c…
8 replies
Hello All, Below is the my existing table structure from which I am trying to do an update statem…
7 replies
I want to be able to generate 1 merge statement rather than loop through a lookup table using a si…
2 replies
Hello everyone 0 I have a Contact table which has columns like ContactID, Nationalidnumber, Firstna…
7 replies
We have a stored procedure that can load up a JSON file and process this in 12 seconds However on A…
2 replies
I am tasked with writing a package to import a series of files. One of the files is 7.4gb and has 2…
10 replies
Hello Team, kindly advise how to change dtsx connection? below is source details: Data Source=SQL12…
1 replies
Hi All, I have following samples. create table tbl_svr (Server varchar(200) primary key) insert int…
6 replies
I want to use a table variable in a merge statement using Dynamic SQL I know that you cant referenc…
6 replies
Hi, I need to insert a separator after each value but I don't want to mess the db with irrelevant c…
3 replies
Hi Everyone I am working on a SSIS package. There are multiple steps in the SSIS package design so…
2 replies
By: water490
I have created a table as per below query CREATE TABLE [dbo].[mydbtemp]( [Datetime] [datetime] NULL…
10 replies
Hi, each day we are sent an email with an XML attachment. Recently the XML file has acquired some s…
7 replies
Hi everyone I am working on a SSIS package where I am automating data collection and table updates.…
3 replies
Viewing 15 topics - 496 through 510 (of 1,784 total)
You must be logged in to create new topics.