I...

Next time, supply the code required to create some test data - it makes it easier for others, so they'll be more willing to help. It also reduces the chances...

Alvin Ramard (3/29/2010)

---

BrainDonor (3/29/2010)

---

Alvin Ramard (3/29/2010)

---

Jeff, I just read your comment about the MS 70-433 book. I happy I did not order the MS one.

Now if that other 70-433...

Paul White NZ (3/29/2010)

---

BrainDonor (3/29/2010)

---

How many other countries change their clocks forward in the Spring? I've woken up in the dark for the first time in weeks and my brain...

Alvin Ramard (3/29/2010)

---

Jeff, I just read your comment about the MS 70-433 book. I happy I did not order the MS one.

Now if that other 70-433 book would just...

Jack Corbett (3/29/2010)

---

BrainDonor (3/29/2010)

---

How many other countries change their clocks forward in the Spring? I've woken up in the dark for the first time in weeks and my brain is...

How many other countries change their clocks forward in the Spring? I've woken up in the dark for the first time in weeks and my brain is complete mush.

BrainDonor (3/29/2010)

---

Because you have a number and a character field to compare, SQL...

Because you have a number and a character field to compare, SQL will...

Bhuvnesh (3/25/2010)

---

@BrainDonor

WHERE

(@CompanyLetter = 'ALL')

OR

((@CompanyLetter =...

Trybbe (3/25/2010)

---

hi I have the same problem except my case statement should look something like this:

Select distinct staffno

from dtiheadcount dt inner join reportingstructure re

on dt.costcenter = re.costcenter

Where period =...

Yet another way:

--CREATE TABLE tblCompany(

--CompanyIDint,

--CompanyNamevarchar(max),

--Activevarchar(5),

--LastModifieddateTime

--)

--INSERT INTO tblCompany(CompanyID, CompanyName, Active, LastModified)

--SELECT 1, 'A Company', 'Yes', '01 MAR 2010'

--UNION

--SELECT 2, 'Another Company', 'Yes', '01 MAR 2010'

--UNION

--SELECT 3, 'Yet Another Company', 'No', '01...

Perfect, thank you very much.

BrainDonor

And here's another one:

http://www.sqlservercentral.com/Forums/Topic888739-10-1.aspx

The MS book for 70-433 also contains a CD with practice tests on it.

BrainDonor.