That's what I really hated when I was professionally developing.

Commonly you don't have the time to implement an efficient solution, but rather an effective one.

It's was one of the...

quote:

---

One issue is that we get relatively few responses to polls. Any ideas for improving the response rate? We considering making it...

I think DTS s*cks...but it would be an good option, I guess.

Maybe you should start this thread again in the DTS section.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, it is!

That's why such things should be carefully planned.

Hey, after all, you don't do this every day, or?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

something like

CREATE TABLE MyUniqueTable

   (UniqueColumn   UNIQUEIDENTIFIER      DEFAULT NEWID(),

   Characters     ...

Don't mix up SQL and the relational model! That are two different pairs of shoes (can I say so?).

I think SQL Server does quite a good job on implementing SQL...

sorry, lost track yesterday evening....

You might also want to consider eliminating this varchar(1) thing on NAME_MI

Frank

http://www.insidesql.de

http://www.familienzirkus.de

The results would be the same. However, try to create a view without specifying TOP 100 PERCENT.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Is this a one-time action or do you need to do this on a regular basis?

I thought of utilizing something like this

http://www.sqlservercentral.com/scripts/contributions/225.asp

or that

http://www.sqlservercentral.com/scripts/contributions/592.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Apart from this lesser flaw (IMHO) try to run the given alternatives from QA. Only one should create the view.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Could you please start the thread again in a more appropriate forum category?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Mainly because the view is syntactically not correct.

You're referencing a column articleid in the ORDER BY that seem not to exist in the underlying table.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

There are several scripts on this site that let you split a string into pieces. Because you have different delimiters I would look for a function where you specify which...

Jonathan,

the paper is about SQL7. I thought the query optimizer hase greatly improved between these versions. Is it still valid for SQL2k?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

SELECT yourcolumns FROM yourtable WHERE yourdatecolumn BETWEEN GETDATE()-365 AND GETDATE()

If you must take care for leap years you should use DATEADD. Works also with negative numbers as interval.

Frank

http://www.insidesql.de

http://www.familienzirkus.de