Viewing 15 posts - 2,266 through 2,280 (of 2,452 total)
Jeff Moden (9/19/2010)
gah (9/19/2010)
version 2 resullts attached.regards Graham
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 19, 2010 at 9:55 am
version 2 resullts attached.
regards Graham
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 19, 2010 at 9:22 am
Jeff.....will reun the revised code for you in a moment.
Note on my machine I have SQL throttled at 1GB.
regards Graham
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 19, 2010 at 8:59 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 19, 2010 at 2:00 am
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 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2010 at 8:51 am
Please provide scripts for table structure and details of indexes
regards gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2010 at 8:28 am
Mark Enloe (9/15/2010)
Manu-J... thanks for your straightforward, helpful response.
Mark...surely just the above would have sufficed if you have found your answer?
Your second sentence is far from polite, unprofessional...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 15, 2010 at 3:24 pm
any good?
SELECT a.id,
a.code,
a.relt_id
FROM ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 15, 2010 at 12:55 pm
suggest you take a look here
http://www.sqlservercentral.com/Forums/Topic986142-392-1.aspx
seems a remarkably similar question
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 15, 2010 at 11:49 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 8, 2010 at 12:56 pm
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 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 4, 2010 at 11:06 am
1-7 8-14 15-21 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 1, 2010 at 11:37 am
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?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2010 at 11:18 am
Lucky9 (8/29/2010)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 30, 2010 at 11:38 am
Steve Jones - Editor (8/26/2010)
gah (8/26/2010)
Steve Jones - Editor (8/26/2010)
Excellent job of writing and enjoyable to read. I am looking forward to the rest of the series.
I agree with Steve's...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 26, 2010 at 11:45 am
Viewing 15 posts - 2,266 through 2,280 (of 2,452 total)