Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jql
Starting Member
30 Posts |
 Posted - 2011-01-28 : 05:42:24
|
| Hi, i have created a query that uses the FOR XML path to get a list of dates in one field but the query is now taking nearly 2 minutes to run. is there a way of speeding this up?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-01-28 : 05:59:31
|
quote:
Originally posted by jql
is there a way of speeding this up?
Yes!
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
jql
Starting Member
30 Posts |
Posted - 2011-01-28 : 06:06:04
|
| gonna tell me then? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-01-28 : 06:10:50
|
Without seeing the source data and your existing code? It's not possible because it's only going to be a guessing game.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
FOR XML path query speed