want to know the quries - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

want to know the quries

Author

Topic

Naresh.Chepuri
Starting Member

1 Post

Posted - 2013-04-02 : 23:25:07

1)i want to know the query never place in the order

customer table Order Table

CustID Custname orderID CustID
1 Naresh 1 1
2 suresh 2 2
3 bharat 3 1

Answer:Select Custid From Customer where custID Not In (Select Custid from order table)

Please confirm the answer correct or not

2)i want to know the query managername,empname

employee table

empid empname managerID
1 Naresh 2
2 suresh 1
3 rakesh 2

3)ssis package:

i have 10 tasks 5 tasks are success and 5 tasks are failed

if the task is success the task will commit . if the task is is failed the tasks will roll back

Ans:-by using transctions is possible.

Thanks and Regards
Naresh Chepuri

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-03 : 01:23:56

why not test with sample data and see if you're getting correct output?
That way you will understand for yourself whether its correct or what went wrong etc. That will be more beneficial to you that someone else suggesting you.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources