Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

Request Friendship



Upload Image

Chennai, India
Male
Madhivanan
3 · 40% · 12936
  • IIF Vs CASE expression

    Madhivanan Posted 1 Years ago through Blogs | 10 Points
    create table #genders (gender bit) insert into #genders (gender) select top 10000000 checksum(newid())%2 as gender_flag from sys.objects as so1 cross join sys.objects as so2 cross join sys.objects as so3 cross join sys.objects as so4 decla...
  • Efficient filtering with HAVING Clause

    Madhivanan Commented 1 Years ago through Blogs | 1 Point
    Thanks. I actually meant what you said "Find the customers who have made any purchase but have never purchased an air conditioner". If I want to use alternate method, I would use the following select cust.cust_id from #customer...
  • Efficient filtering with HAVING Clause

    Madhivanan Commented 1 Years ago through Blogs | 1 Point
    Hi ErikEckhardt, Thanks for your points on table scan. I think you should use the NOT EXISTS to get the correct result. Here is your modified code select sales.cust_id from #sales_details as sales inner join #pr...
Previous | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.