SELECT

sa.schoolc sch#,

s.schname AS School,

Have_logged_In = COUNT(CASE WHEN u.logindate IS NOT NULL THEN 1 END),

Not_logged_In = COUNT(CASE WHEN u.logindate IS NULL THEN 1 END)

FROM

users AS u

INNER JOIN stugrp_active AS...

bdohmen (10/4/2007)

---

Or, you can highlight the cells you want to change, right click and choose format. Select the Custom Category. Then in the Type: field, type in a...

Close, but results in a cartesian product.

CREATE TABLE #test (dialId INT, projectId INT)

INSERT #test

SELECT 1,1 UNION ALL

SELECT 1,1 UNION ALL

SELECT 1,1...

So are there only duplicates in the table or can there be triplicates, quad's etc...?

Sent you a PM

I'm assuming one of these "ProjectID" fields resides in a different table?????

The above statement will never return a record because ProjectId will always ProjectID.

What is...

OOPS, My previous formula was wrong. "=RIGHT(TEXT(A1, "0000000"), 7)"

OK, so are you using excel to help in creating SELECT or UPDATE statements.

If so, then the above will work and...

What are you trying to accomplish? Not the adding leading zeros part, but what are you doing with the data after adding the zeros?

Enter the formula in ONE cell at the top of the list, click enter. Select the cell with the formula in it. Click and HOLD the bottom right corner of...

=LEFT(TEXT(A1, "0000000"), 7)

=TEXT(A1, "0000000")

will convert a value of 452 in cell A1 to 0000452.

Is that what you need?

That only returns them. If you need to update the field....

First, what is the datatype of the column? If it's numeric, then I'd suggest leaving it alone and using a...

SELECT

LEFT('0000000' + CAST(yourNumber AS VARCHAR(7)), 7) AS formattedNumber

FROM

....

And if you haven't used the ROW_NUMBER keyword, take a dive into it. I've found it to be pretty useful. :w00t: