Viewing 15 posts - 496 through 510 (of 5,502 total)
Let's assume the requirement to store the file in a table is really required (instead of just the insert of a link to the file system...).
If it needs to be...
March 14, 2012 at 1:53 pm
Something like this?
SELECT
A.Account,
A.Symbol,
SUM(CONVERT(INT, A.exeQty)) / 2,
CASE
WHEN SUM(CONVERT(INT, A.exeQty)) / 2 < 1000 THEN 'Chunk 1'
WHEN SUM(CONVERT(INT, A.exeQty)) / 2...
March 11, 2012 at 2:38 pm
There's a missing GROUP BY:
SELECT
A.Account,
A.Symbol,
SUM(CONVERT(INT, A.exeQty)) / 2
FROM
( SELECT
RPM.Account,
RPM.Symbol,
...
March 11, 2012 at 2:29 pm
duplicate post. no replies please.
Discussion already started here.
March 11, 2012 at 9:59 am
duplicate post. no replies please.
Discussion already started here.
March 11, 2012 at 9:58 am
duplicate post. no replies please.
Already discussed here
March 11, 2012 at 9:56 am
duplicate post. no replies please.
Already discussed here
March 11, 2012 at 9:56 am
duplicate post. no replies please.
Already discussed here
March 11, 2012 at 9:55 am
I wonder if the following scenario should be implemented, too:
One person can play different instruments in either the same band or in different bands (e.g. Bass guitar and Acoustic guitar).
March 11, 2012 at 8:19 am
From my point of view there's no valid argument for comparing Excel and a relational database (or the baby version of it AKA MS ACCESS):
Excel is a bunch of spreadsheets...
March 11, 2012 at 7:49 am
It seems like you also decided not to use the split function based on the link I referenced in my signature.
How do you expect us to help you if you...
March 11, 2012 at 5:06 am
I already did. See the code snippet above. It returns almost exactly what you're looking for.
It shouldn't be too hard to adjust it to your needs.
March 11, 2012 at 4:44 am
I've asked you to run the code I posted. Why don't you just do that?
The code you've posted is different.
If you complain the code doesn't work, it might very well...
March 11, 2012 at 4:37 am
Please post the code you're running.
The code runs just fine on my system.
March 11, 2012 at 4:13 am
Using the DelimitedSplit8K function refernced in my signature I would start with
DECLARE @RowColumn VARCHAR(30)
SET @RowColumn ='1_2|2_3|1_3'
SELECT
Itemnumber AS adbid ,
LEFT(item,CHARINDEX('_',item,1)-1) AS [row] ,
STUFF(item,1,CHARINDEX('_',item,1),'') AS [column]
FROM ...
March 11, 2012 at 4:08 am
Viewing 15 posts - 496 through 510 (of 5,502 total)