jzieleniuk (5/19/2015)

---

Hi All,

So I have a list of directories:

D:\Data\Load\customer1\Archive

D:\Data\Load\customer2\Archive

D:\Data\Load\customer3\Archive

D:\Data\Load\customer4\Archive

We receive files with spaces and i want to replace those spaces with dashes, but i want to only...

Rod at work (5/18/2015)

---

Agreed. I know it's possible to search for PowerShell tutorials, etc., but it...

I agree with learning PowerShell, VBScript...not so much.

Coming from a *nix background I have done a LOT of scripting and have found that PowerShell is fairly useful. PowerShell is...

From article:

. I think SSIS will continue to be one of the most valuable tools in SQL Server (along with lots of demand for work), but it still needs improvement...

It might be.

As part of the Epic install a SQL Server or Oracle database is set up for reporting/querying.

The ETL administrator is responsible for migrating data from Cachè to SQL...

valeryk2000 (5/8/2015)

---

Thank you.

Currently we place queries into vb code (or use vb code to call stored proc from the source database) and get the resultsets (using ADO) that are inserted...

I have not used Cerner, but I have used Epic so I'll take a stab at this.

I will assume that you are thinking of converting from one EMR to another.

Epic...

I have been stuck in a MS environment way too long and my thought process has devolved because of it.

I would have never bothered with trying to write dynamic SQL...

Thanks for the feedback.

I thought of something like this, but was having trouble translating it to dynamic SQL.

I have to make this generic enough to pull from any of the...

jwiseh (3/3/2015)

---

I have had jobs working with SQL Server and MySQL, so I can't really speak much to the Oracle front.

To expand on sql-lover's comment, support is a huge...

sql-lover (3/4/2015)

---

podmate (3/4/2015)My bias is showing as I come from the Unix/Linux world and have trouble with the very limited options (mostly pointy/clicky stuff) available in the MS world. ...

Having worked with all three databases as a developer/junior DBA/leader/architect, I'll throw in my 2 cents.

I would recommend using SQL Server only when you are stuck on a Microsoft only...

Phil's suggestion works.

Thanks for the assistance.

Don't know why I couldn't think of this.

The reason that the second query returns zero data (as compared to third query) is because you have assigned the variable the value 'q246_pantilla_normal' (used in first and second queries)...

I am seeing a new behavior in 2012.

Intellisense will pop up, but the drop down list is blank. There are entries in the drop down list that you can choose...