Do you really need to do all those LTRIM(RTRIM()) function calls in your join criteria? That is one thing that is potentially killing your query.

krypto69 (5/17/2012)

---

Hi,

I'm having some trouble with what I thought was a fairly easy query...

select CMPCOMPANYCODE

,CMPCOMPANYNAME

,CMPCOID

...

mtassin (5/17/2012)

---

Lynn Pettis (5/17/2012)

---

To convert a string version of an IS-8601 date string, two things need to be true. One, you have to have the complete date-time string (tried...

You do realize Books Online can answer your questions if you take the time to read it.

insert into table1 (column1, column2,column3)

select column1,column2,'0' from table2

union all

select column1,column2,'1' from table2;

You find it used off-shore, particularly India: http://oald8.oxfordlearnersdictionaries.com/dictionary/upgradation

We now have, English, American English, and...

mtassin (5/16/2012)

---

CELKO (5/15/2012)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know...

CELKO (5/17/2012)

---

>> ISO-8601 breaks SQL when you try to stick it into a datetime column. <<

We picked one of ISO-8601 formats for SQL. This makes porting code much easier if...

SQLCrazyCertified (5/16/2012)

---

erics44 (5/16/2012)

---

Hi

I have always been under the impression that in tables where there are a lot of inserts a clustered index should be avoided and clustered indexes should be...

AskSSC is more of a simple ask a question and get an answer type site. You won't find the kind of discussions there that occur here on ssc. ...

Andrea Sawyer (5/16/2012)

---

Tried a few things - first I noticed the TEXTIMAGE_ON [PRIMARY] within the PK constraint in the DDL. Since there was no text image, I removed that...

Nope, don't have the Visual Basic.NET documentation available here.

http://blogs.msdn.com/b/psssql/archive/2009/03/03/troubleshooting-sql-server-2005-2008-performance-counter-collection-problems.aspx

Curious, what happens if you leave out the varchar(max) field while moving the data using the import/export wizard?

Need to verify that you are using SQL Server 2000, as this will determine how to approach this.

Lynn Pettis (5/16/2012)

---

Here is my solution. Give it a test. Oh, with the values given by the OP, I get 12:03 not 12:07.

DECLARE @StartDate DATETIME,

...