Jeff Moden (3/1/2013)

---

I'm not poking holes here so go easy. Considering another conversation about not so obvious code, wouldn't the concatenation method of adding...

winmansoft (3/2/2013)

---

I have a query like

UPDATE a

SET oldRemarks1.modify('insert <Value_Py>{sql:column("b.collection_date")}</Value_Py>

after (/Root/Row[3]/Item)[1]') from b

where a.[Date]='31-May-2004' and ...

Actually, yes. Don't use a cursor. Oh, wait, you would like some actual code here wouldn't you?

Okay, we can that once you post the DDL (CREATE TABLE statements)...

Just a little vague, what are you asking?

Look at using the OUTPUT clause when inserting the parent records to capture the information you need to insert the child records.

Hard to give more with so little information to...

Based on the following from MSDN, what other errors are there in the SQL Server Error LOG?

Error 3041

Severity Level 16

Message Text

BACKUP failed to complete the command %.*ls

Explanation

This error indicates that...

mehta.saurabhj (3/2/2013)

---

The sql code to find odd number of records is:

select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);

But if I do the foll code for odd...

Okay. Taking this just a little bit further, I have added one more test to the suite, I hard-coded the calculation being done by the functions. I have...

Haven't heard back so was wondering if the information provided was helpful or not,

You may want to read the following articles:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

mehta.saurabhj (3/2/2013)

---

...

mehta.saurabhj (3/1/2013)

---

@lynn thank you for your answer it helped me but i have a doubt which is that why does not this happen in case when the alias is outside...

With a stapler?

Not what I meant by history. I meant a history of the fragmentation on the indexes. My first thought is that nothing happened on certain days because nothing...

ScottPletcher (3/1/2013)

---

Jeff Moden (3/1/2013)

---

ScottPletcher (3/1/2013)

---

Code reuse is another tricky subject. It generally gets talked about far more often than it is genuinely done. A few developers are bad...