Notwithstanding Eirikur's statement re same first names

WITH x (ID,FirstName,LastName,UserName,RowNum) AS (

SELECT e.ID,e.FirstName,e.LastName,LEFT(e.FirstName,t.N)+e.LastName,

ROW_NUMBER() OVER (PARTITION BY e.ID ORDER BY LEN(LEFT(e.FirstName,t.N)+e.LastName) ASC)

FROM #Employee e

JOIN master.dbo.Tally t ON t.N BETWEEN 1 AND LEN(e.FirstName)

WHERE...

COALESCE(NULLIF(foo,'')+','+newvalue,newvalue)

DECLARE @HashTable TABLE(HashTable nvarchar (255),TABLE_NAME nvarchar (255));

INSERT @HashTable

EXECUTE sp_MSForeachdb 'IF DB_ID(''$'') > 4 BEGIN; USE [$]; EXECUTE sp_MSForeachTable ''SELECT CheckSum_Agg(Binary_CheckSum(*)) AS HashTable, ''''[$].?'''' AS TableName FROM [$].?''; END','$';

SELECT *...

Was experimenting a bit but could only come up with

cross join distinct list of COMPANY,AREAS,PRODUCT,MARKET,SUBTERRITORIES with range of YEAR and MONTH (using tally table) and left join original table

😀

IF OBJECT_ID('TempDB..#testtable','U') IS NOT...

I am currently migrating 69 dev databases to new...

Ditto 😀

p.s. I starting programming circa 1973 :w00t:

Grant Fritchey (10/3/2016)

---

Hugo Kornelis (10/2/2016)

---

Eirikur Eiriksson (10/2/2016)

---

BLOB_EATER (10/2/2016)

---

Into my 19th hour for the weekend shift decided to google (Gone off bing) well know SQL Server people and found this (attached).......

BLOB_EATER (9/29/2016)

---

so....I will be doing a presentation in front of 40 people soon, I was wondering if the vets here have any advice? Practice in front of a mirror? smile?...

The problem is not with ADP-000077S or ADP-000077F but with AE-000077S and AE-000077F

Unless the format of AE is different to ADP then the AE substrings should be 4,6 not 3,20

What...

Date format default interpretation is dependant on the language specified for the login.

p.s. That is string interpretation.

David Burrows (9/19/2016)

---

Ed Wagner (9/19/2016)

---

ChrisM@Work (9/19/2016)

---

You're going to need a pair of those. The OP (or should that be "perp"?) has been...

Jeff Moden (9/19/2016)

---

You've forgotten the "Modenism" that encompasses all of those... "Moroff". This is a person that doesn't even merit being called a "Moron" because they're more off than...

Ed Wagner (9/19/2016)

---

ChrisM@Work (9/19/2016)

---

You're going to need a pair of those. The OP (or should that be "perp"?) has been posting for...

Your format and data do not match

The position of CITY and COUNTRY_CODE is different

The last entry in the format file needs have \r in the terminator not \r

All the data...