I don't see any way to easily distinguish between the end of a field and the end of a record using this file format. That's going to cause problems...

WHY? How are you planning on using these aliases? Any queries written using these aliases would be virtually impossible to read. You're better off using aliases that...

This only works if the hire...

A more useful statistic for comparing two queries is the number of reads. If you SET STATISTICS IO, TIME ON and then run both queries, you will be able...

GuruGPrasad (2/17/2012)

---

Hi kshitiz,

But we have converted the date to format 103 then why its not formatted.

And also when using getdate() its formatting but when we give the date its...

SQL Kiwi (2/16/2012)

---

I'm not sure I would...

T-SQL is not a reporting tool, yet you are trying to use it like one. What you are trying to do would be relatively easy in a reporting tool,...

R.P.Rozema (2/15/2012)

---

Combine the both solutions. Take Paul's DENSE_RANK() to generate a unique name per 'group' and add another column, using my ROW_NUMBER() suggestion to give each individual member of the...

I agree with Sean that you'll probably want to use a calendar table.

There are also problems with your posted code. You're trying to convert a date to nvarchar—which is...

There are essentially two different options: XQuery and OPENXML. There are plenty of examples in BOL and online. If you need help with a specific problem, you'll need...

There's not much we can do without sample data and expected results. Check out the following link: Forum Etiquette: How to post data/code on a forum to get...

asita (2/13/2012)

---

select chl.GuaranteeCode GuaranteeCode , bal.GuaranteeCode as BalanceSheetGuaranteeCode

from dbo.Guarantees chl

left join dbo.Guarantees par on par.HyperionEntityId = chl.ParentHyperionEntityId

left join dbo.Guarantees gpar on gpar.HyperionEntityId = par.ParentHyperionEntityId

left join dbo.Guarantees ggpar on ggpar.HyperionEntityId...

This forum is for programming in T-SQL using the XML datatype. It is not for troubleshooting installs of third party products.

Try this link http://lmgtfy.com/?q=error+25541+office+2010

Drew

I find that row number works better when you have a single table that you are trying to pull the most recent record from. When you have multiple tables,...

SQL Kiwi (2/8/2012)

---

drew.allen (2/8/2012)

---

Using EXCEPT should give you the same results, is probably...