Post reply

Put 4 tables in 1 table.. HOW to do that?

  • August 15, 2013 at 5:43 am

    #1641742

    Jeff Moden (8/15/2013)

    I would hope not. There's no join criteria in the FROM clauses causing HUGE 4 way Cartesian Products.

    Thank for pointing that out. I was so focused on the errors that I didn't even take a closer look at the CREATE VIEW statement the OP posted Today @ 11:51:03 AM

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • August 15, 2013 at 6:40 am

    #1641767

    How about reading the error message? It says that there is no column name for column 1. So you need to add one. Since there an operator (COLLATE) the column is a nameless expression and you need to provide the name.

    And, as Jeff said, posting error message or code as graphics in attachments, is a really bad idea.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply