Lynn Pettis (2/11/2010)

---

I may be confused on how things are applied. Could you take one set of records and show how the business rules work to generate one of...

You can't solve this without a precise and complete definition of 'this year' and 'last year'. They mean different things to different people.

It's more difficult without fixed boundaries but I don't think it's unsurmountable. Thanks for the extra info Elias.

Hi Elias

The code I sent you yesterday is primarily an attempt to identify facilities by means of a single surrogate key, and introduce a parent for common facility/collateral pairs, with...

Hi Elias

This job will be quite a bit easier if you could split table [dbo].[zzzCovers] into three, as follows:

Collaterial information, which should have unique CollateralId.

Facility information, which should have unique...

Can you show what you are trying to do with the aid of a couple of sample tables and a result set?

All the better if the sample data is...

Is this part of a data migration / ETL process?

fmeuriot (2/6/2010)

---

Hi,

I'm new to SQL and have a problem with a query that I just cant seem to be able to solve.

So, I have an Access database containing iclient number,...

Use a column list for each of your three inserts into the temp table so that you know for sure that your query output columns are going into the correct...

Anybody wanna beer? It's friday! My shout. Get yer shoes on. Lynn I'll get you a coke.

sgmunson (2/3/2010)

---

Why? That's not the path this is going to take... The level is only going to be relative to the root level, not to any other value....

Hi Steve

I've had a play with this one as well - obviously - and from what I remember you can get it out in 4 passes: 2, 2, 1, 1.

The...

sgmunson (2/2/2010)

---

...such a solution could solve a rather broad range of similar problems that are traditionally difficult to deal with in set-based code. My guess is that it...

Hi Jorge, can you post the CREATE TABLE statement for dbo.sipDimensionPos please?

Cheers

ChrisM@home

Using all or most of the suggestions so far, and including gadget type depending on the source table:

ALTER VIEW [dbo].[vw_AssetCommonDetail]

AS

SELECT DISTINCT d.[Gadget], d.AssetID, d.Location, d.Tower, d.[Floor], d.Cubicle, d.BaseVendor,...