Viewing 15 posts - 16 through 30 (of 66 total)
Thanks for the question learnt something new ..
July 8, 2013 at 11:59 pm
Create Procedure [procedureName]
As
-- your query goes here
GO -- end of procedure
July 5, 2013 at 6:41 am
asifejaz (7/4/2013)
This will solve it but urpose is not achieved. i am using a cursor to fetch records with combination of primary...
July 4, 2013 at 11:49 pm
MarkusB (10/11/2011)
Very good question even though I missed the point that INTERSECT precedes EXCEPT
now its a complete Ans ...
July 4, 2013 at 5:05 am
7 points WOW .
i was so nervous between the click and result :w00t:
July 4, 2013 at 4:43 am
You have a huge data
why you don`t want to use Database SQL Server , Oracle etc 😀
you don`t want to update insert delete select on the tables or what ?
June 27, 2013 at 1:18 am
GilaMonster (6/18/2013)
You need to examine the procedures using the EMP table and see what columns they're using.http://www.sqlservercentral.com/articles/Indexing/68439/
Thanks GILA for sharing all three article 🙂
June 26, 2013 at 3:12 am
so in the product table we have 2 million records..so what is the best way to replace the product sub query
Please reply
Can you cut down...
June 25, 2013 at 12:14 am
Mate sorry but your question is so confusing 😀
could you explain it
in another fashion.
here is your all three tables
Create Table #A( ENTERPRISE_MAIN_CODE INT , ENTERPRISE_SUB_CODE INT , ENTERPRISE_DESCRIPTION...
June 20, 2013 at 3:31 am
Viewing 15 posts - 16 through 30 (of 66 total)