nileshbgp123 (11/18/2015)

---

Thanks a lot for your reply, as i said earlier i am not so good in SQL, Can you please just explain me how the value of SUPPLY is...

I've used it...

This will help others. I've taken the query, removed the spurious additional spaces and reformatted it:

create view INV_SUPPLY

as

(select RRN(BAL) as SEQ

...

I can't see MERGE working in a two-way sync solution, unless there are never any deletions and...

OK, I wrote a simple SSIS package to try this out.

My solution uses the code from this page, without modification.

I added a package parameter called FilePath, which I set to...

MadAdmin (11/17/2015)

---

He is using the old ansi-89 style joins.

SELECT

tm.task_id

FROM

task_mstr...

cjefferson (11/17/2015)

---

I'm trying to run a simple query where I'm aliasing. SQL keeps giving me syntax error on the first alias call(SELECT tm.task_id). Does anyone have any ideas as to...

You could try using OPTIMIZE FOR ...

You could also consider adding trace flag 9481 to your problematic queries, at least in the short term.

Bouke Bruinsma (11/17/2015)

---

A simple query joining 2 tables:

select * from t1 join t2 on t1.id = t2.id

t1 is a table with only column id with a user defined statistic with...

Is that a two-way sync?

Only because that is what is assigned to it by SSIS. You can change this.

But I say again: flat file columns have no (explicit)...

Data in flat files does not have a data type.

Luis Cazares (11/16/2015)

---

Anything or nothing that...

David Tooker (11/16/2015)

---

Hi,

I need to use a Like statement with an Or statement in a where clause. below is what I am trying to do and the @ProjectType can...

OK, now I understand better. I get round that limitation (as suggested in previous posts) in a different way:

use SSISDB

go

exec catalog.set_environment_variable_value @folder_name = N'_environments', -- nvarchar(128)

@environment_name...