Viewing 15 posts - 766 through 780 (of 927 total)
Koen Verbeeck (1/31/2014)
GAURAV UPADHYAY (1/30/2014)
[font="Verdana"]Yes you can run all insertions in parallel. Be sure to drop all indexes on the table before running the import and recreate them afterwards[/font]
I think...
January 31, 2014 at 12:09 am
simple math isn't it :Wow:
nice question , thanks for sharing
January 30, 2014 at 11:56 pm
SELECT X.PRODUCTNAME, X.PRICE, X.STARTDATE, X.MAXENDDATE, X.FLAGACTIVEPRICE
FROM (
SELECT ProductName
, Price
, StartDate
, EndDate
, FlagActivePrice
, ROW_NUMBER() OVER ( PARTITION BY ProductName, Price order by ProductName) as rownum
, MAX(EndDate) OVER ( PARTITION...
January 30, 2014 at 11:08 pm
twin.devil (1/21/2014)
You might want to check out Jeff Moden's excellent article on Running Totals http://www.sqlservercentral.com/articles/T-SQL/68467/After doing this, if you have any more problems, come on back
As i mentioned about the...
January 21, 2014 at 10:55 pm
its all on assumptions really ... i hope i get close
Item No : 6000350
Item Type : 'K' means its a Group of items, which means
if this item...
January 21, 2014 at 10:11 pm
You might want to check out Jeff Moden's excellent article on Running Totals http://www.sqlservercentral.com/articles/T-SQL/68467/
After doing this, if you have any more problems, come on back
January 21, 2014 at 12:00 am
An example would help us a lot.
January 6, 2014 at 12:29 am
you can do this
SELECT *
FROM Students2000 a
WHERE NOT EXISTS ( SELECT 1
From Students2005 b
Where b.Name = a.Name
AND b.TotalMark = a.TotalMark
)
January 5, 2014 at 11:56 pm
Bill (DBAOnTheGo) (12/31/2013)
There are only 10 types of people in this world.
+10 🙂
January 1, 2014 at 4:43 am
you just need to make sure that this procedure is not in use in any other procedure beside that no harm using this approach.
December 31, 2013 at 4:34 am
raghuldrag (12/31/2013)
10Friut 1300 1
10Milk 2900 2
30Milk 6000 2
i wanna...
December 31, 2013 at 2:50 am
Viewing 15 posts - 766 through 780 (of 927 total)