We held a series of interview at my work recently and gave the candidates a short (15 question) written test. At the top of the question paper was written:-

"If you...

potted

You're welcome. You will still have to resolve the lack of decimals places you want to display.

Quick and dirty way of doing it - see example below :-

DECLARE @A INT,

@b-2...

Hi Brett,

is this:-

SELECT ID,layer SUM(test*duration) AS Result FROM test WHERE test >1

/

SELECT SUM(test) FROM test

GROUP BY ID.layer

what you've tried so far? Only reason I'm asking is I found

SELECT *

FROM...

Dumplings

Agreed - to clarify; I was only looking at the data values returned, not necessarily the row order.

I was attempting to resolve the join issue - not the order which...

If the data is stored as in my example, it will return the desired results

You need to have the relationship in the data so that you can write a query and return the desired result.

Have a look at the following code and see what...

Essentially - you can't.

The tables need to have a common element for you make the association between them - the tables shown don't.

If on the other hand Table A...

Nice and straightforwards - thanks

GilaMonster (2/12/2014)

---

I've just spent part of the morning (teaching database design today) explaining why a business requirements document needs to be specific and detailed (and telling horror stories of times...

Straight forward one today - thanks Steve

Grant Fritchey (2/11/2014)

---

No, there's no formatting of any kind built into SQL Server Management Studio. It does have syntax coloring, but that's it. Any formatting has to be done through...

BWFC (2/11/2014)

---

martin.whitton (2/11/2014)

---

Here in...

Nice question

Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England