How can we help you today? How can we help you today?

Incorrect Translation of SELECT *

The following is what I get when I expand SELECT *:
SELECT
	[Sessions_200401].SESadCost, [Sessions_200401].SesAdGroup, [Sessions_200401].SESadKeyword, [Sessions_200401].SESadSource, [Sessions_200401].SESagent, [Sessions_200401].SesCampaign, [Sessions_200401].SESccid, [Sessions_200401].SESCookiesEnabled, [Sessions_200401].SESCountryCode, [Sessions_200401].SESentrypage, [Sessions_200401].SESip, [Sessions_200401].SESJavaScriptEnabled, [Sessions_200401].SESNetworkPersistentID, [Sessions_200401].SESreferrer, [Sessions_200401].SesServer, [Sessions_200401].SESsessionid, [Sessions_200401].SESSitePersistentID, [Sessions_200401].SESsitid, [Sessions_200401].SEStime, [Sessions_200401].SesXfip]]]]]]]]]]]]]]]]]]]
FROM
	[Sessions_200401]

Notice the excess square brackets.
tmoreau
0

Comments

1 comment

Sort by
  • Bart Read
    Hey Tom,


    Thanks for this, and sorry you're having difficulties. Any chance you could send me the contents of the SQL Prompt schema panel when the Sessions_200401 table is selected in the completion drop-down please? What I need is the CREATE TABLE, ALTER TABLE etc statements so that I can whack this into a database myself and try to reproduce it here. I don't need any data, just the schema will be fine if you could post that up here please.


    Many thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.