July 21, 2011 at 2:42 pm
Welsh Corgi (7/21/2011)
I saw an example where this issue is related to alias and I also believe that I saw an issue with the columns not in the schema.
So between Lutz and I we may have pinpointed to possibilities. 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 21, 2011 at 2:44 pm
This is from Symantec if I am not mistaken and they are changing their Schema name to something else.
-Roy
July 21, 2011 at 2:46 pm
Sean Lange (7/21/2011)
Welsh Corgi (7/21/2011)
I saw an example where this issue is related to alias and I also believe that I saw an issue with the columns not in the schema.So between Lutz and I we may have pinpointed to possibilities. 😛
Yep. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 21, 2011 at 3:12 pm
Yes, this is from Symantec. Their script is having all syntax errors, I made them fix to some point and got through those errors.
Finally I have fixed the problem, thank you all for your inputs and solutions.
July 21, 2011 at 3:13 pm
gopalchalla (7/21/2011)
Yes, this is from Symantec. Their script is having all syntax errors, I made them fix to some point and got through those errors.Finally I have fixed the problem, thank you all for your inputs and solutions.
:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 21, 2011 at 3:20 pm
Welsh Corgi (7/21/2011)
gopalchalla (7/21/2011)
Yes, this is from Symantec. Their script is having all syntax errors, I made them fix to some point and got through those errors.Finally I have fixed the problem, thank you all for your inputs and solutions.
:w00t:
😀
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 6 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply