Post reply

Retrieve employee data without using stored procedure and c

  • May 20, 2011 at 6:27 am

    #1327605

    odanwada (5/19/2011)

    without using stored procedure and temp tables

    I've been watching this one too...but the requirements scream "homework" to me, where the teacher wants you to use a specific set of rules to learn a concept.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 20, 2011 at 6:45 am

    #1327632

    odanwada (5/19/2011)

    I dont know exactly why my manager is asking like that.. but he strictly told that do not use SPROCS, Cursors or Temp Tables...

    I think my manager wants the solution in different ways..

    I would absolutely find out why you can't use stored procedures. It doesn't matter for the solution you're looking for, but it also doesn't make any sense.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 20, 2011 at 7:19 am

    #1327666

    Lowell (5/20/2011)

    ... the requirements scream "homework" to me..

    Obviously not screaming loud enough for me to hear, doh! :blush:

    Nigel
    How to post questions

  • May 22, 2011 at 10:07 pm

    #1328277

    Thanks nigel this solves my problem...

Viewing 4 posts - 16 through 18 (of 18 total)

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