The silence is deafening. Did any of my posts help you with your problem?

NewBie23 (4/30/2011)

---

I understand Lynn. I told you that I was new. Here is what I have

SELECT region.name, count(employee.employee_id) as Num

FROM employee INNER JOIN

region ON employee.regionid = region.regionid INNER JOIN

sale...

NewBie23 (4/30/2011)

---

I am sorry Lynn . Below is all the info you require.

/****** Object: Table [dbo].[sale] Script Date: 04/30/2011 02:01:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE...

For some date manipulations, please look here.

The following is untested but may help you with your problem. Hopefully you are using SQL Server 2008 (this is the forum you posted in) or at least SQL...

NewBie23 (4/30/2011)

---

Hi,

I am new to SQL and I am still learning SQL. Please help me with this query . Here is the situation

...

PhilM99 (4/28/2011)

---

I don't want to be a DBA. I'm a developer. But I find myself hosting and managing a few small databases for the applications I wrote for my clients....

Can't see what you see. Sounds like you may be querying a view with an order by declared in the view. This works in SQL Server 2000 but...

Curious, are you also using SSIS? If so, where do you store the packages, SQL Server or File System?

The only way to guarantee order in a result set is to include an ORDER BY...

Indexes do not ensure that data is returned in sorted order. To ensure that a dataset is sorted you need to include an ORDER BY clause in the outer query...

Okay, I'm sorry but this statement really doesn't make an sense to me....

Syed Jahanzaib Bin hassan (4/23/2011)

---

overhead on the same database

Database snapshot fetch the data from the primary database,It will affect the performance of the database and overall performance of the server

Regards,

Syed...

And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.

Be careful. You may want to be sure to specify the schema_name for the tables, particularly if you have multiple schemas in a database and there may be tables...