raj.prabhu001 (8/19/2013)

---

yes i hv two database db1 and db2 and my proc uses tables from the both database and i need to find them .

can u plz suggest the query....

You have abstracted your problem so far that there is not much detail left. Do you actually store aggregate data in the calls table or is it really a table...

raj.prabhu001 (8/19/2013)

---

thnks for help but now i need to modify the same query this query only shows the tables from one database but i need it to run across different...

Walton (8/19/2013)

---

Hi all,

I need a help on getting the distinct set.

My Data look like this:

SET 1

SET ID Product Attribute

1 ...

No need for a case expression here at all. Just convert the value, it will give you the negative values just fine.

CONVERT(decimal (18,2),REPLACE(LTRIM(REPLACE(TestData,'0',' ')),' ','0'))

Stefan Krzywicki (8/19/2013)

---

Sean Lange (8/19/2013)

---

Stefan Krzywicki (8/19/2013)

---

The Dixie Flatline (8/19/2013)

---

Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this...

Minnu (8/19/2013)

---

Hi Team,

am having a online application, while doing some actions like (select drop down, select any item from list), application is taking long time (10 seconds), previously it was...

Stefan Krzywicki (8/19/2013)

---

The Dixie Flatline (8/19/2013)

---

Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this water-cooler question. ...

Rick44 (8/16/2013)

---

Hi. That was just a small example. Yes, there could be years worth of counts. many more that 1 enrolled. Do you want me to send you larger...

Rick44 (8/16/2013)

---

Hi. A count of total clients enrolled during the month.

Total_Clients_Enrolled Month Year

1 ...

OK so what would be the expected output based on the small sample of data you provided?

You do know that you can't pass parameters to a view right?

scott.kitson (8/16/2013)

---

i tried both Sean and Luis suggestions

On Luis's a got a timeout error on the query before i finished adding all the columns . There are 18 columns...

This can get really complicated. Given that your data is what appears to be user entered information you have more challenges than just removing characters that aren't part of the...

Rick44 (8/16/2013)

---

Hi. I inherited a User Defined function I’m trying to modify and having some trouble. :crazy: I would like to modify it into a regular query and then make...