This is definitely going to be my last post on this thread because I am getting an ache from having my tongue in my cheek for so long 😛

...are not...

For anyone who thinks that an infinitely recurring number can simply be redefined as another number, I ask this question:

Does PI (3.14159 etc ) which never repeats = 3.141.... (which...

Michael Valentine Jones (6/2/2011)

---

mister.magoo (6/2/2011)

---

0.999.... = 1 ? No. There I said it.

One is a series of 9s preceeded by a ".", the other is a 1.

You can decide to...

Sure, SELECT TOP(@myVariable) etc. works just fine

Stephen Ward (6/2/2011)

---

I see what you mean about Atomic transations and agree.

I suppose this update statement isn't an 'all or nothing' situation but if I'm to break it down...

Amy.G (6/2/2011)

---

I would like to join two tables. If there is no match for one column, I would like to say join with another column. When I use an OR...

0.999.... = 1 ? No. There I said it.

One is a series of 9s preceeded by a ".", the other is a 1.

You can decide to treat them as equal...

I have to agree with opc.three that rollbacks in triggers are not to be encouraged, however you are stuck with this apparently....so

Those triggers do need to be changed, but you...

The syntax error is because you have missing brackets before imgUrl and name.

However, you are also using the wrong path to the image nodes...

Try this:

set nocount on

declare @feed_raw ...

agustingarzon (5/31/2011)

---

I'm attaching the actual exec plan and the view def, hehehe go nuts !

What do you mean with un-3part named tables ? All the tables are in the same...

Please read this other thread : http://www.sqlservercentral.com/Forums/FindPost1117192.aspx to see if that helps you ...

Hi, please try this function.

CREATE FUNCTION BomExplode (@product NCHAR(20))

RETURNS TABLE

WITH schemabinding

AS

RETURN (

WITH cte (product,component)

AS

(

SELECT product,component

FROM dbo.ProductAssembly

WHERE product=ISNULL(@product,product)

UNION ALL

SELECT cte.product,PA.component

FROM dbo.ProductAssembly AS PA

JOIN cte

ON cte.component = PA.product...

You are welcome, thanks for the feedback.

flash.rsn (5/29/2011)

---

Dear LutzM

Actually purpose of this trigger is to deal with dates, for more detail; this tables contains different dates such as date_added, date_modified,date_created etc, e.g. date_created is empty and...

You cannot set filters on a trace you haven't created yet...move the filter setting until after the sp_trace_create.