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 |
|
starnold
Yak Posting Veteran
83 Posts |
 Posted - 2008-10-16 : 05:58:07
|
| I have the below script that I am trying to run but keep getting an error. The data looks like the below:ID SystemName KEY Value1 miv3demo Discoverer_CoreOptions Selection,Cube,Chart1 miv3demo Discoverer_PlugIns DecisionTree,MapSELECT T.[ID],T.[SYSTEMNAME],T.[KEY],F.[VAL]FROM USERCONFIG TCROSS APPLY dbo.ParseValues(T.[VALUE],',')FMsg 102, Level 15, State 1, Line 3Incorrect syntax near '.'. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-16 : 06:46:09
|
| its working for me. which tool you're using? |
 |
|
|
starnold
Yak Posting Veteran
83 Posts |
Posted - 2008-10-16 : 06:50:21
|
| Microsoft SQL Server Management Studio 9.00.3042.00Microsoft Analysis Services Client Tools 2005.090.3042.00Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)Microsoft MSXML 2.6 3.0 4.0 6.0 Microsoft Internet Explorer 7.0.5730.11Microsoft .NET Framework 2.0.50727.1433Operating System 5.2.3790 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-16 : 09:05:47
|
Which tool are you using when running the query below?SELECT T.[ID],T.[SYSTEMNAME],T.[KEY],F.[VAL]FROM USERCONFIG TCROSS APPLY dbo.ParseValues(T.[VALUE],',') AS F
E 12°55'05.63"N 56°04'39.26" |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
|
|
starnold
Yak Posting Veteran
83 Posts |
Posted - 2008-10-16 : 09:09:27
|
| that never worked either :-( same error |
|
|
|
|
|
|
|
|
ParseValues Script