middletree (7/8/2009)

---

I agree joins are better. I was just trying to solve a problem. Sadly, I got the same error when I moved the JOIN criteria to the WHERE clause....

Lowell (7/8/2009)

---

there is an optional OUTPUT clause you can use to retrieve all the values that were inserted; typically you insert the output into a temp table and use it...

Multiple post, please post replies here.

Multiple post, please post replies here.

Multiple post, please post replies here.

Anjana (7/8/2009)

---

Hi,

i need to help to decode the timestamp values which are there on my tables.

For example i have a timestamp value like '0x00000000085EBC62'.

I would like to see...

Is it just me or are others having issues when posting replies? I get application failures, but the replies still post. Quite troubling if you ask me. ...

It would help to have the DDL (create table statements), sample data (in a readily consummable format that can be cut/paste/run in SSMS) in order to help you better.

Please read...

It would help to see what you have done so far as we may be able to help you fix your code instead of starting from scratch.

Plus that may help...

Okay. I did some testing while SSC was down. The first part of the code shows how to calcualte the various date ranges. The last part show...

opc.three (7/8/2009)

---

I have alluded to the fact that while much research has been done in the field of linguistics the findings may not be applicable to source code. My original...

So, to paraphrase for one value, given the date 6/30/2009, you want the past 11 months 7/31/2008 - 6/30/2009 starting with the last day of the 12th month?

I'd think...

QA/SSMS/UltraEdit, I have them set to convert tabs to spaces. Thing I found is different people have different tab settings and code can look quite different between the settings....

Another request. Could you comment the code a bit to explain what is going on? Also, table DDL, and sample data (readily consummable, and just enough to test,...

Think, I do, that our True Relational Fanatic may have new persona here on SSC.

Anyone else have thoughts on this? 😉