• Sony Francis @EY (11/26/2012)


    ... I dont knw the table structure.

    ...

    If you don't know the table structure, how are you going to write a query against it?

    You can easily review table structure using

    EXEC sp_help [tablename]

    If your table is not from dbo schema, use this:

    EXEC sp_help '[schemaname].[tablename]'

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]