I'm trying to learn a new skill. I've never used powershell before. I thought using existing cmd batch routines Ive written as a good project to start with.

I use this code to work out Age
DECLARE @DateOfBirth DATETIME = '1980-07-12';
SELECT
 DATEDIFF(YEAR, @DateOfBirth, GETDATE())
 - CASE
  WHEN (MONTH(@DateOfBirth) > MONTH(GETDATE()))
    OR...

Where I work it is casual wear.  We are pretty much free to wear what we want, within reason.  Some people wear jeans, trainers and possibly a rock t-shirt etc. ...

For day in day out coding I prefer a dark background with pastel like code colouring as it is a lot easier on the eyes.  Here's an example of mine.

Thanks for that, but it's not quite there.  I still wish to retain one of the 2 duplicates.  This code removes both rows. I need one of the rows to...

We have a review process here that goes something like this:

* Issue raised by the client
* Incident log is then created
* Development item created and assigned...

That's exactly what I'm going to ask the Python developers to do.

Essentially, the whole process that gets us to this stage is a SQL databse being prepared and migrated from...

OOPs, that's my fault, ignore the commas at the end (i've edited my above post now)

The __clients and __entity_asset tables have no indexes. They get created by a python...

I think i've figured this out. The execution plan suggested the JOINs were the issue so I asked for the TSQL code.

He's got the following no no's as far as...

Thanks guys, I've asked him to get the execution plan.

If I struggle to see the issue, I'll get some DDL together.

I think the correct answer is...

ZZartin (9/23/2016)

---

I'm also one of those people who learns by doing, I can read a book on a subject cover to cover and retain/understand how to apply none of it....

I find I learn more and retain more knowledge through "doing". I watch and read tutorials all the time, and they stick partly with me until I am doing...