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

My Badges

Request Friendship



Upload Image

39 years old
Ahmedabad (Gujarat-India)
Male

My Sections

Mitesh Modi
18 · 10% · 3082

Mitesh Modi's Home

My name is Mitesh Modi. I live in Ahmedabad, India. I work as Software Developer at Tulshi ICT Solutions Ltd.
  • Question of the month April 2014 - When will INNER JOIN become CROSS JOIN?

    Mitesh Modi Commented 3 Years ago through Blogs
    Sorry I misunderstood. INNER JOIN ON 1 = 1 will evaluate True for every combination of rows in the two tables. This is the same as a CROSS JOIN SELECT t1.\*, t2.\* FROM t1 INNER JOIN t2 ON 1 = 1...
    Madhivanan JR
    2 · 40% · 13039
  • Question of the month April 2014 - When will INNER JOIN become CROSS JOIN?

    Mitesh Modi Commented 3 Years ago through Blogs
    SELECT t1.\*, t2\.* FROM t1, t2 WHERE t1.id = t2.id **If a WHERE clause is added, the cross join behaves as an inner join** [http://msdn.microsoft.com/en-us/library/ms190690.aspx][1] [1]: http://msdn.microsoft.com/en-us/library/ms190690.aspx...
    Madhivanan JR
    2 · 40% · 13039
  • Logic creation

    Mitesh Modi Commented 4 Years ago through Ask
    <pre> DECLARE @VSTNNO VARCHAR(20) DECLARE @Cnt INT DECLARE @AWBNo INT DECLARE @FStCode INT = 2 DECLARE @TStCode INT = 3 DECLARE @MaxSTNId INT SELECT @MaxSTNId=MAX(STNID) FROM GVSTNDetails WHERE FromStoreCode=@FStCode ...
    kapilkk
    1810 · 0% · 11
  • how to handle this error

    Mitesh Modi Commented 5 Years ago through Ask
    string str1=""; string str2 =""; When you assign null to the variable you're telling the compiler to back off because you know better than him so he should not complain about this. This is probably due to the fact that assigning null is conside...
    niya
    530 · 0% · 71
  • Date format

    Mitesh Modi Commented 5 Years ago through Ask
    use stored procedure to pass date. from your client application convert your string date input to datetime object and pass that object as parameter of date type. Not use string parameter to pass date.Instead use date or datetime type parameter...
    strivesupport
    646 · 0% · 54
  • Maxrecursion

    Mitesh Modi Commented 5 Years ago through Ask
    DECLARE @i int= 5 DECLARE @Query NVARCHAR(MAX) SET @Query = N' ;WITH cte AS ( ... ) SELECT * FROM cte OPTION (MAXRECURSION ' + CAST(@i AS NVARCHAR) + ');' EXEC sp_executesql @Quer...
    Thina25
    489 · 0% · 79
  • Compare a row with the previous row

    Mitesh Modi Commented 5 Years ago through Ask
    Hi, Try this query with cte as ( select *,row_number() over(partition by address,latitude,longitude order by address,latitude,longitude) as rno from address ) select * from cte where rno=1...
    Praveen
    85 · 2% · 664
  • Doubt SQL Query

    Mitesh Modi Commented 5 Years ago through Ask
    Hi, sample table is same as used by chintak select UID,DateValue,Description,CategoryID, sum(Amount) as InAmt,sum(amt) as ExAmt from ( select UID,DateValue,Description,CategoryID, Amount,0.00 as amt from @TblIncome union all ...
    gurusamy
    9 · 16% · 5043
  • Can anyone tell me the uses of SSIS?

    Mitesh Modi Commented 5 Years ago through Ask
    check this below link may help you. [http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/4691fe01-79ca-4c09-8569-8e61d4b398ff/][1] [http://msdn.microsoft.com/en-us/library/ms137795(v=sql.105).aspx][2] [http://social.msdn...
    Thina25
    489 · 0% · 79
  • Appending a text file to another

    Mitesh Modi Commented 5 Years ago through Ask
    first of all get all the file list from different directory in one temp table with two column name FilePath and filename then sort all data by filename. Now you only have to merge file with same name...
    nikeshv
    1573 · 0% · 13
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.