toparsi (10/7/2009)

---

Also, my question would be , is there any way of not allowing this in the development or production environment without using check contraints on the table as they...

Assuming @A will always be a positive number you can change

where ((avg_cost - std_cost)*in_stock >= @A

or (avg_cost - std_cost)*in_stock <= -1* @A)

to

where (ABS((avg_cost - std_cost)*in_stock) >= @A)...

Global answer: yes.

The major question would be: Why would you do this?

A relational database is designed following a simple pattern:

- data in a row belong together

- data in...

Simple answer: yes.

Example (using AdventureWorks):

DECLARE @xmlstr nvarchar(1000)

SET @xmlstr =

(SELECT top 1 *

FROM HumanResources.Shift

FOR xml auto, elements)

SELECT @xmlstr

/*Result...

You might want to have a look at Jeff Moden's article regarding Dynamic Cross Tabs [/url].

If you need further assistance please provide sample data as described in the link...

Please read and follow the recommendation shown in the link in my signature.

Your sample data seem to be incomplete:

- Values for ParentFleetID are missing

- There is no relation shown between...

duplicate post.

please continue discussion here .

kabaari (9/29/2009)

---

Ok, this is close to what I am looking for. I need to return each date once but aggregate my Units Produced.

SELECT DATEADD(wk, DATEDIFF(wk, 6,...

grahamcoombes (9/28/2009)

---

Why do I want to read a forum where the "answer" is, you don't need to. Great contribution. Maybe if I can justify my stupid needs to...

Triple +1 post.

Discussion already started here and

here .

Triple +1 post.

Discussion already started here and

here .

Triple +1 post.

Discussion already started here and

here .

You might want to have a look at the following article:

http://www.sqlservercentral.com/articles/Crosstab/65048/

Obviously, the data in tableA do have unique values in the primary key field, whereas tableB doesn't.

Try the following:

SELECT PrimKey, COUNT(*) FROM TableB

having COUNT(*) >1

GROUP BY PrimKey

This query should result...

If you look at the upper right hand side of your post you'll find a button named "EDIT ///".

So, this site has an option to edit your posts.

However, you cannot...