ericb1 (5/6/2009)

---

I have an ASPXGridView in VisualStudio (http://www.devexpress.com/Products/NET/Controls/ASP/Grid/)

This control builds grids, which is based off a view I have in SQL2k5. I needed to add a WHERE clause to...

Alvin Ramard (5/6/2009)

---

Lynn, let me know if you understand the OP's last reply in the thread about the rolling 12 months. I don't think he knows what you...

Alvin Ramard (5/6/2009)

---

ericb1 (5/6/2009)

---

sorry about that, I should have given more info. It's actually for another application, which is handling the indexing, so it's not an issue. Thanks...

From the Merriam-Webster on-line dictionary:

I guess it depends. I tend not to apply the CU's unless I have an issue that is addressed by the CU.

Not sure how performant this will be, and it may not be the best way to accomplish it.

create a view that accomplishes the openquery with NO criteria, you are asking...

Bruce W Cassidy (5/6/2009)

---

[font="Verdana"]Does anyone remember a language called Algol? I believe that in the original form, it had no concept of "reserved words", so it was perfectly valid...

Would you please post the code for your tvf?

If I read you right, correct, you can't use a stored procedure in a query like a table. that's why you would need to load the data returned from...

My fault, was looking at something else while typing. Move the last argument to the first, the first to the second, and the second to the third.

You will need to import the data you need from the Sybase database to a temporary or staging table and then use that table in your function(s)/query(ies).

Also, what table(s) does this view access: vWorkflowTransition?

I am basing my assumption that this is a view due to the naming convention used in the name.

sorry, crushed you will be.

Hmm, backwards I should walk with my light sabre out...

Why can't you modify the query?