Viewing 15 posts - 631 through 645 (of 682 total)
Hi Carl,
I'm not sure I realised before that you weren't the original poster
I'm not that familiar with BULK INSERT, but I just looked...
March 8, 2006 at 11:01 am
Jonathan,
I'd only recommend using a cursor in this situation if you want poor performance and derision from most people on this site
The...
March 8, 2006 at 2:59 am
Ang,
That was a fun problem
Here's something for starters for you to play with. It should give all possible journeys - but might need...
March 7, 2006 at 5:53 am
Rajesh,
Is this what you want?
--This SQL script is safe to run
--Create table and data
DECLARE @Product_feature TABLE (Product_id VARCHAR(2), Feature_code VARCHAR(2))
March 7, 2006 at 3:35 am
There are a few methods - none of which is that straightforward, but do the job. I've used one method as an example below
March 7, 2006 at 3:29 am
Once you've got your 1 column table to SQL, you can try a variation of this kind of thing (just try running it and you should get the idea
March 6, 2006 at 1:22 pm
Hi all,
I started playing with the PARSENAME way of doing this (for fun, and taking into consideration what's been mentioned), and got a bit carried away.
I'm not certain it...
March 6, 2006 at 12:23 pm
This kind of thing has been discussed many times before on here. Here's one simple way (as an example)...
CREATE TABLE #T1 (name SYSNAME, par INT IDENTITY(1, 1))
INSERT INTO #T1...
March 3, 2006 at 7:17 am
Unless there's more to the problem than you've described, I'd solve it using VBA, rather than T-SQL (in which case this is the wrong forum, so apologies).
Something along the lines...
March 3, 2006 at 7:10 am
Just working on that now...
March 2, 2006 at 1:08 pm
This does the trick:
--This code is safe to run
DECLARE @Animals TABLE (ListOfAnimals VARCHAR(100))
INSERT INTO @Animals
SELECT 'cat, dog, mouse' UNION ALL
SELECT ' mouse,dog,...
March 2, 2006 at 12:46 pm
Galahad,
Ray's right that you need to post more information about your problem. How do you know, for example, that rows 1, 3 and 5 (or 2, 4 and 6) in your...
March 2, 2006 at 11:15 am
I see paramind - that's what you're thinking. In that case, I guess changing...
INNER JOIN (SELECT s1.Orderref, SUM(ISNULL(s2.Quantity,0)) AS [Summ]
...to...
INNER JOIN (SELECT s1.Orderref, SUM(ISNULL(s2.Quantity,0)-ISNULL(s2.[Scheduled Amount],0)) AS [Summ]
...might do...
March 1, 2006 at 8:57 am
Well, I prefer David's method. A little tweak to seems (to me) to meet all the requirements (including the priority one)...
SET @Material = 'MATERIAL1'
SET @Qty = 350
UPDATE a
SET a.[Scheduled Amount] =...
March 1, 2006 at 7:53 am
I think the '<=' should be a '>=', but Sergiy's solution is a good one.
January 13, 2006 at 7:03 am
Viewing 15 posts - 631 through 645 (of 682 total)