For those new to message boards please try to follow a few simple rules when posting your question.
Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
Keep the subject line brief, but descriptive. eg "File Serialization problem"
Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
No advertising or soliciting.
We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
Sorry, I started using it for a training app and chucked it because I am so reliant on stored procs it irritated the hell out of me. Coding up all the queries in c# as strings was excruciating. I would seriously look at EF if I had to use it, and I hate EF!
Never underestimate the power of human stupidity
I have used it a small amount and it seems fairly good as a database engine.
As an afterthought, if you write your code in a layered manner you should be ably to create something that is database agnostic. You could then experiment with different databases to see which one suits your needs.
“That which can be asserted without evidence, can be dismissed without evidence.”
If I've understood your question properly, you're looking to concatenate row values rather than PIVOT them.
This article[^] covers most of the options. For example, the black-box XML method:
SELECT',' + Site
FROM YourTable As I
WHERE I.DataPoint = O.DataPoint
FOR XML PATH(''), TYPE
-- Remove the first comma:
, 1, 1, ''
) As Sites
YourTable As O
Thank you, but, no. Not concatenation.
I need the CH and KC to be the column headers.
What I have is 1400 data points and 4 sites; in theory, all sites SHOULD have the same datapoints, but... they don't.
I need to create a matrix of datapoints and sites to show what is there and what isn't.
What I've presented is the simplified version, but the concept is correct.
Could you help with XML select. Below is my xml however it won't select correct value.
DECLARE @input AS XML
SET @input =N'<?xml version="1.0" encoding="utf-16"?><NewDataSet><GroupID>111111</GroupID><GroupID>111111</GroupID><GroupID>999999</GroupID><GroupID>777777</GroupID></NewDataSet>'SELECT
Ppl.GroupID.value('(@GroupID)', 'VARCHAR(6)') AS'GroupID'FROM
@input.nodes('/NewDataSet/GroupID') as Ppl(GroupID)