Jeff Moden (9/14/2010)

---

Agreed. SELECT DISTINCT usually indicates that more than 1 of the exact same row was created. That usually means the join criteria was NOT sufficient or...

I tried to understand where the difference between the two "UNION'ed" statements is, but I couldn't figure it out.

First I thought GLCr and GLDb were alias for different tables, but...

What error message do you get?

Why do you convert a date format to varchar followed by an implicit conversion back to datetime due to the month() function? Wouldn't month(Startdate))...

Why do you need to compare it to StartDate, EndDate instead of StartMonth, EndMonth?

If the latter, you could compare it without any data type conversion. (not that I like storing...

rikku0801 (9/13/2010)

---

It's actually for a computer science project. Our teacher deliberately asked us to ask around forums for help in answering this query. The other student, was I think a...

You could try OneNote (addtl. software for your MS Office bundle) or EverNote (equivalent freeware tool).

This is the major cause for the poor performance:

That's the...

The basic concept doesn't sound like RBAR (if done without any kind of a loop). However, it might be better to check for duplicates during signup process and not batch...

please provide sample data so we have something to test against (xml string, table def of target data, some sample data and your expected output).

Will the following work?

IF REPLACE(CAST(@xml.query('data(part/measure/note/pitch/step)') AS VARCHAR(10)),' ','') ='AFFG'

PRINT 'true'

ELSE

PRINT 'false'

Is this a theoretical question or do you have to deal with a real-world scenario?

If the latter, you could test the effect by using two scenarios and compare the execution...

It's impossible to give any advice based on the limited information available. There are just too many questions:

How long does it run when started from BIDS?

What other activities do take...

Your cast statement in the WHERE clause will return a format like 'Sep 9 2010 8:59PM'.

Hence the messed up order.

Did you try using the same CONVERT statement in...

dbowlin (9/9/2010)

---

Apologies. I have had similar problems, I should have thought of this before my answer.

Usually when I run into this, I have to go back to...

David Burrows (9/9/2010)

---

sangeethu (9/9/2010)

---

Hi Lutz,

Thanks for the reply. I have gone through Cross Tab and Dynamic Cross tab and found that it involves aggregation of a column. But in my...