Viewing 15 posts - 1,651 through 1,665 (of 2,894 total)
Yes, you can:
declare @Portolio table (Id int, AcquisitionDate date)
insert @Portolio select 1, '1 Jan 2011'
insert @Portolio select 2, '1 May 2011'
insert @Portolio select 3, '15 Apr 2011'
select p.Id, p.AcquisitionDate,...
May 3, 2012 at 5:56 am
When I looked first it did looked strange, but in few seconds...
see:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET DATEFORMAT DMY
DECLARE @TABLE1 AS TABLE
(VALUE INT)
INSERT INTO @TABLE1
SELECT 1 UNION ALL
SELECT 2 UNION...
May 3, 2012 at 5:02 am
hmsanghavi (5/3/2012)
Now i want to update that datatable records in existing sql database table.
By this I am doing bulk update.
please let me know how can I...
May 3, 2012 at 4:20 am
kate-395233 (5/3/2012)
This is how I modified it (I don't have access to the master db) - and added more rows
DECLARE @count INT
SET @count = 1
DECLARE...
May 3, 2012 at 4:16 am
You can use "on-fly" table which can provide you with continues numbers. Any would do, I've used sys.columns... :
SELECT ORDER_NUMBER, PRODUCT_ID, 1 QTY, VALUE/QTY VALUE
FROM @SPLITROW sr
JOIN (SELECT ROW_NUMBER()...
May 3, 2012 at 4:08 am
What have you drawn to them? I can only guess...
But I know for sure what I would draw... :hehe:
May 3, 2012 at 3:38 am
...
Hope you catch my drift.
try this: http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 1, 2012 at 10:01 am
Jeff Moden (5/1/2012)
capn.hector (5/1/2012)
Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to...
May 1, 2012 at 9:58 am
capn.hector (5/1/2012)
Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!="...
May 1, 2012 at 9:12 am
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is...
May 1, 2012 at 8:54 am
How many do you need?
May 1, 2012 at 7:17 am
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where...
May 1, 2012 at 7:17 am
Phil Parkin (5/1/2012)
You can deduct whatever you want from whatever you like.
This could come in very useful. I'd like to deduct all the French people from the city I...
May 1, 2012 at 7:01 am
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where it is...
May 1, 2012 at 6:53 am
no probs at all, if I'll have a time I'll help.
May 1, 2012 at 6:10 am
Viewing 15 posts - 1,651 through 1,665 (of 2,894 total)