Viewing 15 posts - 1,171 through 1,185 (of 2,894 total)
aaron.reese (9/20/2012)
I do have to agree with the byte-bloat issue.
Can anyone beat this? its from the NHS clinical data set upload for patient details
<personGenderCodeCurrent>M</personGenderCodeCurrent>
There is nothing wrong with that!
XML is...
September 20, 2012 at 7:27 am
Phil Parkin (9/19/2012)
preetid2 (9/19/2012)
Thanks Phil! this worked perfect!I feel like I have entered a parallel universe.:alien:
I knew that! Your avatar makes everything right! What a solution!
:hehe::hehe::hehe:
September 19, 2012 at 2:12 pm
...
I want the xml to look like this:
<PartsList>
<123>
...
It is not valid XML. You cannot have element named as number....
September 19, 2012 at 12:04 pm
Phil Parkin (9/19/2012)
Eugene Elutin (9/19/2012)
SELECT Col1, Count_Rec
FROM (SELECT Col1, Col2, Count(*) AS Count_Rec
...
September 19, 2012 at 11:45 am
GSquared (9/19/2012)
Eugene Elutin (9/19/2012)
...I just afraid that we scare Joe even more now...
I don't think you'll scare him. Maybe offend, but not scare.
...
I...
September 19, 2012 at 11:40 am
Yes it is possible, but what it will give you?
SELECT Col1, Count_Rec
FROM (SELECT Col1, Col2, Count(*) AS Count_Rec
FROM MyTable...
September 19, 2012 at 10:20 am
And another thing to mention for MERGE is that SQL Server kind of splits the data into up to three "streams" and executes INSERT, UPDATE and DELETE (if required).
So,...
September 19, 2012 at 10:17 am
ScottPletcher (9/19/2012)
Eugene Elutin (9/19/2012)
...
ISO currency and Country codes are a prime example of an when the natural key (ISO Code) can be used as an Identity column and Primary Key.
...
You...
September 19, 2012 at 8:47 am
Jeff Moden (9/18/2012)
Eugene Elutin (9/18/2012)
Please ignore this stupid remark!Easy, big guy. You're right but that's something that he would say. 😉
I've spent 5 minutes to choose the word...
September 19, 2012 at 6:20 am
...
ISO currency and Country codes are a prime example of an when the natural key (ISO Code) can be used as an Identity column and Primary Key.
...
You wouldn't call it...
September 19, 2012 at 5:09 am
CELKO (9/18/2012)
September 18, 2012 at 8:06 pm
CELKO (9/18/2012)
I do order some items from different countries including non-US, but order numbers looks the same to me. Have Amazon registered international order numbering standard?
I don't know,...
September 18, 2012 at 7:54 pm
CELKO (9/18/2012)
I have a product_sku CHAR(10) s table and a storage product_sku CHAR(10) s table.
No, you do not. A table has a key and you have none. What...
September 18, 2012 at 7:26 pm
HowardW (9/18/2012)
GSquared (9/18/2012)
September 18, 2012 at 10:56 am
...
3) What are your "multiple reasons" for not using an identity column?
...
I've worked once on similar system. All "multiple reasons" I have heard from original designers definitely didn't justify custom...
September 18, 2012 at 9:43 am
Viewing 15 posts - 1,171 through 1,185 (of 2,894 total)