Okay, off topic but I need to ask. Where did you purchase your copy of SQL Server 2008 Developer Edition, and how long did it take for you to...

At this point, I'd like to to point you in another direction for a moment. Please take the time to read this article, http://www.sqlservercentral.com/articles/Best+Practices/61537/.

Follow the guidelines in it and...

Change this:

to this:

SET @DisplayNo = 'CNST'

SET @DisplayNo = '%' + @DisplayNo +...

Jeff Moden (10/7/2008)

---

Heh... what an idea... maybe I'll title it "Porkslinger: Have Chops, Will Travel." ...

Actually, I believe that indexes will help. I can't remember where I read it, but I believe that there has been improvements in the query engine in SQL Server...

I can see why this runs fast:

It won't select...

Or you can do something like this in SQL Server 2005/2008. (Pardon my use of the * in the query).

create table dbo.MyUsers (

UserID varchar(25),

...

Truncating or deleting data from the tables will not drop the indexes you create. If you drop the tables themselves every day, then you'd lose the indexes you create.

😎

How about the following:

declare @timeint int,

@dateint int;

set @dateint = 20081003;

set @timeint = 70004;

select cast(cast(@dateint as char(8)) as datetime) +

...

lucassouzace (10/2/2008)

---

I would like to know whether in a CTE is possible define sub-queries?

for example:WITH CTE1 as ( Select AddressID from Person.Address

where AddressiD in ( select ProductID from Production.Product)

Error:

Msg 156,...

Still need the DDL for the under lying tables to the view.

😎

I just wanted to be sure. We have WSS installed on one of our development servers, and I have to shutdown the Windows Internal Database to run the Surface...

Can you provide the DDL (create statement) for the tables including collation for character columns?

😎

Curious, is there any other software installed on the system? In particular, I am wondering if the Windows Internal Database (aka SQL Server 2005 Embedded Edition) is installed on...

Unfortunately, we aren't mind readers. The help you get is only as good as the information you provide with your question.

I suggest you read the article in Jeff's signature...