Follow the link in my post and you can take it from there.

Fernando Margueirat-273899 (11/18/2015)

---

Thanks for this great tip!

One small change that I would make to avoid the "DR.EndDate+1" part and still be able to easily link to dates in other...

SQLBlimp (11/18/2015)

---

Phil Parkin (11/18/2015)

---

eavesdm (11/18/2015)

---

Good stuff. It should be coded better, though, perhaps; given the international audience and user-base and the long-established international standard ISO 8601 (https://xkcd.com/1179/) shouldn't this...

Jack Corbett (11/18/2015)

---

jasona.work (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Brandie Tarvin (11/18/2015)

---

robert.sterbal 56890 (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Why should we consider using hashtags? Is there any benefit on that? The forum software won't recognize...

You can't, as far as I know. It's stored in encrypted form.

eavesdm (11/18/2015)

---

Good stuff. It should be coded better, though, perhaps; given the international audience and user-base and the long-established international standard ISO 8601 (https://xkcd.com/1179/) shouldn't this have been written...

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...