Looking at for a moment but gotta break it down. One thing thou.

In regards to the contact view which you listed as coded

Select * From Openquery(Service, "Select * From dev_rede.tbl_Contacts")

Do...

Just for the sake of testing the problem try it instead with the TOP x syntax both 100 or less and higher than 100 to see if the same issue...

Please do not cross post. Duplicate thread please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7459&FORUM_ID=5&CAT_ID=1&Topic_Title=how+to+find+sortorder%2Cchar+set%2Ccollation+seq+%3F&Forum_Title=Administration

Moderator please lock or remove thread.

"Don't roll your eyes at me. I will tape them in place." (Teacher on...

Use sp_helpsort.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

This should do the trick.

SELECT

salesx.sales_item,

salesx.Item,

salesx.Qty,

CAST(((salesx.Qty / TSPI.TotQty) * 100) AS NUMERIC(10,2)) As Prcnt

FROM salesx

INNER JOIN

(SELECT sales_item, CAST(sum(Qty) as NUMERIC(10,5)) TotQty FROM salesx GROUP BY sales_item) as TSPI

ON

TSPI.sales_item = salesx.sales_item

"Don't roll...

Is the rate can potentially change then it is not considered a good idea to use such a PK-FK relationship. In you case I would create an int column set...

It is by some considered bad and they would opt for a INDENTITY column. I and many others however prefer not to waste space and indexes on something we want...

Sorry, feel like an idiot, can you post the query code itself. Makes it easier to understand the Execution Plan.

Thanks

"Don't roll your eyes at me. I will tape them in...

quote:

---

Antares686,

I'm not sure I know how to play with the Fill Factors, they are all currently defaulted to 0%,...

You cannot set process priorities, at least not yet in SQL.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

What type of timestamp is it. SQL stores most all date time values as an integer in the background. The presentation layer converts to the local time zone based on...

Where do you see the login? How are you trying to drop it? And are you sure you are dropping it from the right database when you do so?

"Don't roll...

That fix pertains to using the Microsoft OLEDB for Oracle driver and not the Oracle OLE driver. The meesage pump from Oracles driver has a huge tendency with this error....

Alright here is the work I started and for the most part I know it was working, I just did not finish out some special stuff. Take a look at...

Indexed views are a SQL 2K item, not available in SQL 7. Also, views are slower than SProcs for thre most part since they cannot take advantage of stored execution...