May 16, 2016 at 2:30 pm
I have a script that is building dynamic sql.
It generates this statement
SELECT * into [Feeds].ABC.aTabletemp
FROM [Staging].Legacy.aTable
What it builds in the Feeds database is
ABC.ABC.aTabletemp
I have tried qualifiying the schema and table name and about everything else I can think of and still getting a duplicate schema name as part of the table name, any ideas.
May 16, 2016 at 2:44 pm
Kinda hard for anyone to have any idea without seeing the script.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 16, 2016 at 3:21 pm
Why would this statement not recognize the schema name as the schema and utilize it as part of the table name, the table name is ABC.aTabletemp
May 16, 2016 at 3:24 pm
John1.5.nlt (5/16/2016)
Why would this statement not recognize the schema name as the schema and utilize it as part of the table name, the table name is ABC.aTabletemp
Don't expect answers without showing us the script! All you're gonna get is guesses!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 16, 2016 at 3:33 pm
I have shown you the sql and I have shown you the results.. the script is irrelevant, I can execute the sql and get the same results.
So why dont you stop trolling and find something better to do.
May 16, 2016 at 3:41 pm
John1.5.nlt (5/16/2016)
I have shown you the sql and I have shown you the results.. the script is irrelevant, I can execute the sql and get the same results.So why dont you stop trolling and find something better to do.
Suit yourself. You won't get much help with that attitude!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply