winston Smith (10/16/2009)

---

serious apologies for posting this question. was making it much more complicated that it should be.

its

select max(OrderID),OrderStatus from #orderline

group by OrderStatus

I was trying joins and subqueries and a...

What do you mean Top 1 by status? What is the desired output, how can we choose which of the row to return by status? Do you want the latest,...

What type of file are you using? I know I had problems in the past, when trying to read tab delimited files, so here's what I've come up with:

I read...

Well then, don't use the variable, it was only for the demo. Use your column name instead, and select it directly from your table.

Does this help?

DECLARE @str NVARCHAR(10)

SET @str = 'ABCDEFGHI'

SELECT substring(@str, 1, len(@str) - 3) + ' ' + right(@str, 3)

Ok, first, you have several indexes that use the column fCompanyID as the first indexed column, and that includes different columns along with them. That is useless if your clustered...

You are in sql2005? Click include actual plan, in the toolbar, and right click the execution plan, save as, and add to a zip, to post here, we will be...

How many rows is returned, of the 300 000 rows, and, why do you call it so much, is there a possibility to return all rows at once, so the...

Well, Happy to have helped, I wasn't so sure of the requirement, seeing how only the top clause was missing! 😀

Have a nice day,

2Tall (10/7/2009)

---

I have been asked to write a report that amongst other things returns the TOP 5 Suppliers based on the number of invoices they have submitted.

The basic query is...

Hi,

I am not aware of a technique to completely cache the results of a query. Here's what I suggest you though:

1. Post the query with the DDL of the tables,...

Grant Fritchey (10/2/2009)

---

repent_kog_is_near (10/1/2009)

---

I have some 110 new SPs and Functions in a Development Database; they need to be moved to the testing Database in another server. I have the...

Blehh... well thanks! Hehe! :hehe:

Well, if you really want to use the exists clause, you need to add a condition with the first table #T1.

Here's how you can do it:

SELECT *

FROM #t1

WHERE...

Hi Mike, there is no "Easy" way of doing this through SSMS, but here's what I've recently seen in use on a production environment:

You can use the SQLCmd mode (Query...