Is this what you are looing for?

SELECT first_table.empid

,second_table.CompanyID

,MAX(DateInserted)

FROM first_table

INNER JOIN second_table

ON second_table.empid = first_table.empid

INNER JOIN valid_companies

ON valid_companies.CompanyID =...

Jeff Moden (1/7/2014)

---

eccentricDBA (1/7/2014)

---

I agree that a DBA should learn how to develop. At the very least they should learn how to use a scripting language (dos batch, bash,...

I agree that a DBA should learn how to develop. At the very least they should learn how to use a scripting language (dos batch, bash, cscript, vbscript, perl,...

Curiae Regis

SELECT name,accdate FROM master.dbo.syslogins

http://technet.microsoft.com/en-us/library/ms178593.aspx

Doppelbock

salesman

Witchcraft

In PowerShell 3.0 and higher you could use the following:

Test.txt

First

something

something else

Last

$filename = 'C:\work\test.txt'

Get-Content $filename -Head 1

Get-Content $filename -Tail 1

Actually I believe the double qoute was your original problem. Bellow I have a simplified example. A double quote is going to cause the variable to be evaluated when...

Tex-166085 (10/22/2013)

---

Hi

I am new to powershell, and am struggling a bit with the passing of an array as a variable. Firstly, I have a function which will return a...

I find this editorial interesting because over a decade ago I the development team I was working on had this exact discussion.

I was a developer at that time and I...

lrutkowski (8/15/2013)

---

Last night we ran into an issue with our dbcc's. On a SQL Server 2005, 9.00.4035.00, we were running our normal dbcc's. We started getting User error...

Jose Ianuck (8/13/2013)

---

I created the TEMPDB01 and TEMPDB02, using this script;

(ALTER DATABASE tempdb

ADD FILE

(NAME = N'tempdb01',

...

"All right, Mr. DeMille,...