mike 57299 (7/14/2010)

---

Actually, I am the vendor and I don't have the time right now to rewrite all the code to handle identity columns. Currently, the code has to...

Thanx, Jeff! :blush:

Btw: What feature of your magic decoder ring are you going...

mike 57299 (7/14/2010)

---

I have legacy code that does not allow for identity columns, thus I have a table that holds the last "PK" value. I am getting occasional update...

David Levine-327541 (7/14/2010)

---

Hi all..

I have a table that has a char(20) field. I need to hit this table (and field) from an external BI application.

Usually, we will create a...

What exactly are you trying to do?

I don't see the input parameter @table_name being used anywhere.

The condition WHERE gpk_pk = 'HOLDER' will fail since gpk_pk is an INT data type.

The...

What is the value of STATISTICS_NORECOMPUTE for the index in question?

It seems like the index distribution statistics are not recomputed...

How did you add the indexes (using T-SQL, SSMS->NEW INDEX or...

I'd use a different concept:

Instead of using the function dbo.fn_ConvertToBusinessDate(pl.date) I probably would use a calendar table and join the productLine table to it.

I would consider normalization of aztec.dbo.ProductTaxRules (preferably...

Jeff Moden (7/13/2010)

---

...

Dang, Lutz... looks like I'm going to have to turn the "doesn't use RBAR, KISS it instead" crown over to you, Lutz. Very well done.

What's next... ...

Please provide some sample data to populate the tables you provided the DDL for.

That would allow us to see the results you're getting with your current query.

What we also would...

How about the following solution?

SELECT 5/(ISNULL(NULLIF(EXPECTEDDURATION,0),1))

The NULLIF() function will return NULL if EXPECTEDDURATION is Zero. Fortunately, a devision by Zero is allowed and will return NULL. But since you don't...

cold_blue (7/12/2010)

---

Hi Lutz,

View table seems like not practical in my case.

In my stored proc, it used to calculate the value

1. by its own table's columns

2. update the cost column. Scenario:...

Well, that's what usually happens if someone post ready to use sample data and expected results - exactly like...

priya__ (7/12/2010)

---

Thank you so much!!!!!!

This is exactly what I wanted..the results are PERFECT!!!!!!!!

I really don't know how this is working but your code is fetching( in seconds :-)) what I...

This approach might perform better:

SELECT

textID,

STUFF((SELECT '-' + Typetext FROM test t2 WHERE t2.textID = t1.textID FOR XML PATH('')),1,1,'') AS [TypeText]

FROM test t1

GROUP BY textID

If...

I second Wayne: there is nothing provided to support the missing row needs to be between 6 and 7. It could be between 5 and 6, too (assuming the time...