Partially. We need the DDL for the table(s), create statements. Sample data for the tables, in the format of insert statements that can be cut, paste and executed...

Try this code:

select

a.cuslink,

a.sequence,

a.effdate,

a.site

from

#list a

inner join (

...

BigSam (10/28/2008)

---

We have used SQL Profiler with the Tuning template to create a number of files we've used as input to the DTA tool. We see recommendations to create some...

Here is the jist of what you need. First, you need to create a Tally table in the database. It is simply a table of numbers from 1...

Agreed. Others may have the same question as you did.

I'd go a little further:

update dbo.YourTable set

description = replace(description, 'Jasper...

We had a similiar issue here on a couple of servers. You can rerun the install, but there is one more step in the install process for an upgrade...

Please take a few minutes to read the following article.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Follow the guidlines provided in the article and provide use with more information so that we may better assist you in...

Here is a better question, what version of SQL Server 2000 are you upgrading, Standard or Enterprise? If you are upgrading from SQL Server 2000 Enterprise Edition, you need...

Comes down to personal preferences and coding styles. Neither way is right or wrong, just different.

😎

shane.barney (10/28/2008)

---

What I am referring to is the this part of the code:

insert into #TempTable

select 1,1,'Bob Smith' union all

select 2,1,'Dow Jones' union all

select 3,2,'Roberta Smith' union all

select 4,1,'John Dow' union...

You might try searching this site for this to be sure, as I know I have read it somewhere, might even have been a Question of the Day.

You need to...

Just use that as the working title. :w00t:

Steve could always retitle it prior to publishing.

😎

Not a problem, I just thought I might have missed something somewhere. So, should this be written up as counter-point article to the one that started this?

😎

True, but when you script the create statement or edit the table in the designer in SSMS, the columns are listed in the order you defined them in the initial...