sample code to replace carriage returns and linefeeds from a column

generic and will go through all columns - test conditions for property.name can allow you to restrict the replacement just...

ram302 (6/11/2016)

---

Hi all,

I'm trying to replace text in a CSV.

The CSV line looks something like this:

"Field One","Field Two","Field

Three","Field Four"

So I tried something like:

(Get-Content $csvfile) -replace "Field`n", "Field" | Set-Content $csvfile

But...

very raw example

insert into table7

select column1

from OldTable1

where columnx = someconditionvalue1

order by desiredordercolumns

insert into table24

select column1

, column3

, column9

from OldTable1

where columnx =...

tomd-982312 (6/8/2016)

---

drew.allen (6/7/2016)

---

This type of processing is referred to as RBAR (Row By Agonizing Row), because it is a HORRIBLY inefficient approach in the vast majority of cases. Why don't...

assuming that what you say is fully correct and that you are using the CRM SDK to extract the data from CRM then it would seem that someone managed to...

phanithota26 (5/28/2016)

---

Hi All,

My SSIS package getting blocked at Pre Execure for more than 14 hours which is not at all acceptable in real time.

My source pulling 90 millions of records,...

Hi Mike,

group by cube and group by rollup do not give same results. so cube is the correct one for this purpose.

as for why the 3 num and not just...

I would also try the following sql to see what you get.

select top 10 tbl.BusinessDate

from dbo.TableNameT1 tbl

where tbl.BusinessDate < '17530101'

you may have two possible issues on your table

column may have a default other than null and if so that is what you are getting

whatever method you are...

code formatted for clarity and the incorrect alias fixed for year part of date

Answer in english even though I am Portuguese so others may benefit of the answer if it...

SQL-DBA-01 (5/10/2016)

---

Hi,

When I try to run the below command, the variable ($pk_key2) comes as NULL.

Can you suggest if something is going bad?

[string] $pk_key2 = invoke-sqlcmd -query "SELECT column_name FROM...

issue is using Oracle.ManagedDataAccess.Client; -- don't use the managed class.

Example from John should work but it will be slow depending on the volumes.

if you can it might be better to...

DiabloSlayer (5/9/2016)

---

Hi There,

My mistake, I just went back and checked, the hours are like '3.5' and '4' instead of 03:30 and 04:00 as initially stated.

So when I ran the

convert(datetime,STARTDATETIME)...

Ah.. if it was that easy.. 1 to 1 mapping.. (sigh).

On the migration I did 1 segment was converted to 200+ Tables, each with their own set of primary key...

the original developer has most likely defined a expression to build the connection string - on the properties of the connection, look for expressions and see what is there.

Most common...