mister.magoo (10/20/2016)

---

I was wondering whether all this complexity is worth it...just to run a dtsx? But I'm not a DBA, so I assume this is a small part of a...

Oh Magoo, you've done it again! 😀

That worked perfectly. Now I wonder what would they prefer, if the Powershell option or the bat file option.

Here's the ps1 final script .

param($dtsx...

Persisted computed columns only make sense when the computation is expensive or when an index is needed. If that's not the case, persisting the computed column makes little sense.

Exactly what DesNorton mentioned. I just wanted to add something about the performance.

The FORMAT function has been proven to be very slow. It's up to 40 times slower that previous...

Brandie Tarvin (10/19/2016)

---

Have you tried renaming the folders to use underlines instead of hyphens?

I think the hyphens are the problem. That powershell might see them literally as a switch "notifier"...

The article that I posted does exactly what you're asking, put the columns as rows. There's no magic way to do it without coding. Here's an example that might have...

Check the following article:

http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

Can anyone help in a Powershell issue I'm having?

If I can't find a solution, I'll have to convince my lead to use bat files.

Add this to your stored procedure and keep a single call to the database instead of 3.

DECLARE @Bcp NVARCHAR(200);

SET @Bcp = N'bcp [St].[dbo].[TmpTNVINTRInfo] out "C:\tnvintrailer\tnvin_' + CONVERT(NCHAR(8), GETDATE(), 112 )...

What happens when you get a row from Spain? or Portugal? or any other country in Europe?

You need to create a Countries table to store that information and, preferably, a...

Martini

I totally agree with Sean. The column should be a varchar as it's just a number to identify the employee. It could be an integer if it's an integer somewhere...

Something like this?

CREATE TABLE #tmp( output nvarchar(max));

INSERT INTO #tmp

--Change Path

EXEC xp_cmdshell 'dir C:\Users\lcazares\Documents\Statement.pdf /TC'; --Uses /TC for creation date

SELECT CAST( LEFT( output, 10) AS datetime)

FROM #tmp

WHERE output LIKE '[0-9][0-9]/[0-9][0-9]/[0-9][0-9][0-9][0-9]%';

DROP TABLE...

Here's another option. It considers that the address can be identified by the first 8 characters. You can adjust that value.

SELECT *, LEFT( a.address, CHARINDEX( LEFT( a.address, 8), a.address, 2)...

Here's an option, but it's not perfect as it won't get the first row because it's not completely duplicated.

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

E2(n) AS(

...