Tag Info

New answers tagged

0

Its possible to get somewhat close to this. First precreate the table IF object_id('[LogparserTest].[dbo].[ZipCodes]') IS NOT NULL BEGIN DROP TABLE [dbo].[ZipCodes] END CREATE TABLE [dbo].[ZipCodes]( [CountryCode] [varchar](3) NOT NULL, [Zip] [varchar](6) NOT NULL ); Note that you have to use varchar columns one character wider than your ...


0

I found this article http://d2-systems.blogspot.co.uk/2013/06/enabling-mysql-multi-source-replication.html which covers the process of aggregated synchronisation.


0

SQLish Honestly, your best bet is probably ANSI-compliant SQL, because it can eliminate the ambiguities which you've mentioned. If there's any trouble with it needing to be written in "natural language", just add in the apprpriate prepositions and such... Select the maximum paid amount, the customer account number, and the customer phone number from the ...


0

I think loading from S3 is a common pattern. We needed to enforce uniqueness constraints so we chose to write to Postgres and then replicate new data to redshift every 10 minutes. We use https://github.com/uswitch/blueshift to load into Redshift.


2

If I'm understanding you correctly what you're looking to do should be quite simple. I'm not entirely sure how you're setting @date1 but for this to work you will need to set that as a SSIS variable and for this example I'll assum it's a date. Then you need to create your query as a variable and then set it as an expression like so. Then you set your ...


0

When using master/slave you do not need to replicate the all instance. You can go up the the table with the replicate-wild-do-table parameter. May be this could help you in what you are trying to do


2

It's not possible to bind column names to variables, but you can achieve similar results by using dynamic SQL. DECLARE @datetxt varchar(10) = '2015-01-01' DECLARE @sqltxt nvarchar(1000); SET @sqltxt = N'SELECT dateAdd(second, 1, ' + @datetxt + ') AS StartTime FROM Termination_Call_Detail' Exec (@sqltxt)



Top 50 recent answers are included