Hi Jeffrey,

Actually, this is quite complex (in my mind anyway), because of the multiple records per customer needing to be on alternate lines. I'm assuming that you have data that...

Come to think of it, why use dynamic SQL at all? You can simply pass the variables to a standard select query with the use of a "like" predicate, without...

Hi Marcelo,

You might want to look up "Full Text Index" in BOL. That should be perfect for what you're trying to do.

Overview:

http://msdn.microsoft.com/en-us/library/ms142571.aspx

Searching multiple values:

http://msdn.microsoft.com/en-us/library/ms142583.aspx#Using_Boolean_Operators

Regards, Iain

Beat me to it John, lol 🙂

You might want to read this btw, it's very useful...

exec (@d) - note the brackets

Hi Bill,

One thing you might like to try is to pre-calculate the two correlated subqueries that you're using to generate criteria and hold the values in variables.

Also, a...

Actually, having re-read your original post, you're looking for the biggest percentage drop, not absolute value drop. To get that, use the following:

;with cte as (

select gpa.tradedatetime as start_tradedatetime

, gpb.tradedatetime...

Hi keymoo,

The query posted gives all drops over the period. You should read each result as:

Between the tradedatetime in column 6 and the tradedatetime in column 2, the value of...

lol 😀

:w00t:

Hi Bill,

Your problem here is that you're running the same queries over and over and over and over again to get your output. Given the complexity of the query and...

Had a quick look on msdn, Microsoft suggest not touching the tables at all:

Do not modify the metadata of management data warehouse tables unless you are adding a new collector...

see below

I don't think so. Because SQL can't know the content of the two fields in your computed column until it computes them, the expression will always be non-deterministic, persisted or...

Hi,

This is probably due to your use of a computed column. From BOL:

Your computed column is non-deterministic (even though it's persisted),...