Jeff Moden (9/19/2010)

---

Now THAT's interesting! Even though the "XML-1 (Split8KXML1 mlTVF)" multi-line table valued still uses more logical reads, it still beat the new...

version 2 resullts attached.

regards Graham

Jeff.....will reun the revised code for you in a moment.

Note on my machine I have SQL throttled at 1GB.

regards Graham

Hi Jeff

Happy to help.

Desktop

SQL Server 2008 R2 Dev ed. 10.50.1600.1

OS NameMicrosoft® Windows Vista Business

Version6.0.6002 Service Pack 2 Build 6002

System Manufacturer Dell Inc.

System ModelPrecision WorkStation 390

System Typex64-based PC

ProcessorIntel(R) Core(TM)2 CPU...

xyzxyzxyzxyz123 (9/17/2010)

---

Now what I want is I want to have tutorname along with subject name saperated by comma in one single record liek below

TutorName ...

Please provide scripts for table structure and details of indexes

regards gah

Mark...surely just the above would have sufficed if you have found your answer?

Your second sentence is far from polite, unprofessional...

any good?

SELECT a.id,

a.code,

a.relt_id

FROM ...

suggest you take a look here

http://www.sqlservercentral.com/Forums/Topic986142-392-1.aspx

seems a remarkably similar question

Assuming that this is an Access question....and using Access 2007.....

Access will allow you to create a primary key on an Access datatype of "text"...defaults to a field size in Access...

any good?

SELECT st.name,

sc.name

FROM sys.all_columns sc

JOIN sys.tables st

ON st.object_id = sc.object_id

WHERE st.name = '<your table name>'

ORDER ...

1-7 8-14 15-21 ...

lets say for example that were no tickets at all on 2010-08-02.....do you want to see all reps with a zero count?

Lucky9 (8/29/2010)

---

I work for a small client and which has around 1000 customers. For each customer we do a survey and we ask questions and customers give answers for each...

Steve Jones - Editor (8/26/2010)

---

gah (8/26/2010)

---

I agree with Steve's...