If you choose a pipe-delimited flat file, you won't go too far wrong (assuming there is no possibility of a pipe (|) appearing in the data you are loading.

Luis Cazares (6/17/2016)

---

It's using the formula shown on BOL.

Considering example 1.00 / 7.1 we just get the formulas.

p = p1 - s1 + s2 + max(6, s1 + p2 +...

Nice example, Luis.

One thing which is unclear to me in all this is how SQL Server determines precision and scale for a given calculation. For example

1.00 / 7.1

which, according to...

cstg85 (6/17/2016)

---

Phil,

Thank you very much for the advice, I used SQL queries in my SSIS package instead of a merge join and created a static table to be truncated each...

sunil.mvs (6/17/2016)

---

Hi,

Thanks for looking into my question. I am rephrasing my question to make you to understand

How to use TFS , to...

neophilius (6/17/2016)

---

Hi!

I have to consume a Rest API where we have our survey data. Here I want to save the data in my database and update the data every night....

Yes, that an easy and robust way.

Or will an SSIS...

This is somewhat terse – what is your question, exactly?

What problem are you having?

komal145 (6/15/2016)

---

Since Stage table is raw data and destination is key columns we cannot merge Stage and destination.

my package is something like below

Stage(Column1 , column2)

|

|

Lookup1(get Column1key1)

|

|

Lookup2(get Column2key2)

|

|

Destination (...

The standard way of doing this is to load your data into a staging area and then to do a MERGE (which is potentially less expensive than DELETE/INSERT) into the...

Are the MERGE statements going in both directions? I mean, are there queries on server A that update server B and vice versa?

If the updates are only from server A...

tmmutsetse (6/15/2016)

---

i am sure you wanted to see the results being returned by each query.I posted the results for one query and for the second query they are also returned...

tmmutsetse (6/15/2016)

---

They return the following infomation:

SiteName HostName Freespace FreeSpacePerc Color TotalMemory ...

george sibbald (6/15/2016)

---

put an exec in front of dbo.report_stale_open_teller_count

This is because if the execution of a stored procedure is not the only statement in the batch, you need to add...