sql server 2008 - Another Multipart Identifier Could not be bound -


there million of these questions; have just started working sql , can't seem drag answer out of them. don't understand context enough; promise i'll keep simple.

use [metrics] insert dbo.tblsplitdata(splitstring) select * dbo.splitstringcomma(dbo.tblrawdata.delimitedstring) 

i "multipart identifer not bound" dbo.tblrawdata.delimitedstring portion of query.

i've checked spelling (i used ide suggestions insert names, think it's good) , i've gotten statement work in following format:

use [metrics] insert dbo.tblsplitdata(splitstring) select * dbo.splitstringcomma('1,2,3,4,5') 

often "from" statement identified being problem (not identifying tables involved) i'm not sure know how implement that.

if delimitedstring data stored in table dbo.tblrawdata need select table , apply delimitedstring column split string function. seems want following:

use [metrics] insert dbo.tblsplitdata(splitstring) select c.*  dbo.tblrawdata d -- table cross apply dbo.splitstringcomma(d.delimitedstring) c  -- function pass                                                        -- in delimited string 

Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -