Background: I am in the process of creating a database which contains medical information (patient-specific, likely identifiable). The treating doctors shall have access to the database via a user-friendly web frontend. I am currently thinking of Perl + the Dancer framework for the front-end part...
@bluefeet You wrote "edit" in the first paragraph. Twice! Granted, one of those was a noun, but still...
I stopped reading there and up-voted.
Even though up-votes on those answers are utterly pointless.
For reference: if someone hands me a link to someone's post that they want deleted and suggests I fix it somehow, I decline the flag and laugh. If you post proprietary data on SO and don't know how to edit it out, you're screwed anyway. So the folks thinking "hand it to SE" is a valid answer to that question are delusional.
@bluefeet I'll happily go out of my way to help someone who honestly wants their private data off the 'net. But using it as an excuse to destroy other peoples' work is beyond the pale and I treat it as such.
Hye programmers.
I need to install Microsoft server 2012 adv. I have checked my requirement and updates. Everything seems to be fine. However when i run to install the file, at the middle of installation suddenly the wizard closed. It happen after this wizard.
I think maybe is because of it s...
@ErikE EXCEPT ALL would seem handy, INTERSECT ALL probably less so. For instance, if set A has 3 (X,Y) rows and set B has 2, the INTERSECT ALL result would contain 2 but I can't yet see how that would be more useful than 1, since I can't distinguish the two instances anyway.
Presently it would make more sense to me to ROW_NUMBER duplicates in both sets then either EXCEPT ALL or INTERSECT ALL them to have meaningful results.
EXCEPT ALL can be useful to determine if one set has more duplicates than the other, too.
I want to compare Actual table with @TableType_TVP IF Duplicate Row Exist
Create procedure sp_InsertintoTable
@TableType_TVP TableType_TVP READONLY
AS
IF(Duplicate Row not Exist then)
Begin
INSERT INTO ActualTable
Select * from @TableType_TVP
Select Inserted row count also
...
@Marian The mods (Aaron or JNK, can't remember) have advised on not to edit spam content. it's easier that way for others to recognize it's spam. And when it's deleted, it's not visible anyway, except to 10k users: dba.stackexchange.com/questions/50594/…
The easiest way to get the result would be to use an aggregate function along with a CASE expression to convert the rows of data into columns, but you could also apply the PIVOT function.
select date,
placementname,
campaignid,
impressions,
clicks,
sum(case when activity = 'Mobile Book...
Mail
Mailid
-------------------------------
venkattaramanan1985@gmail.com
madanraj@gmail.com
Expected output
Name DomainName Extension
------------------- ---------- ---------
venkattaramanan1985 gmail com
madanraj gmail com
I am trying to run an .exe as a command in a SQL Server 2008 Agent Job as another user. I see that this can be done by going to the Job's Step properties-Advanced' option however I have no option to set 'Run As'.
Anybody know where this is?
I am trying to run an .exe as a command in a SQL Server 2008 Agent Job as another user. I see that this can be done by going to the Job's Step properties-Advanced' option however I have no option to set 'Run As'.
Anybody know where this is?
What is the point? Why not just vote for the nominees who you want and the highest "n" get elected?
It's not like nominees have an election campaign (actually we are heavily restricted in character count), and there's no "super Tuesday" or any of the other USA-centric election components.
Where...
@FreshPrinceOfSO Hola Tim Post having your wifey picture when she sleep.......i send you? she is nice...you house must lock very good you know great mexico we take wife and kid — Bando el narcoz killer1 min ago
Why, do my where clauses here get ignored, it's summing invoices regardless of the valued entered as parameters, spent hours on this and going mad!
/****** Object: StoredProcedure [dbo].[usp_custom_dash_Metric_InvoiceSpend] Script Date: 02/19/2014 14:15:31 ******/
SET ansi_nulls ON
go
S...
I just found this question where the OP has used VB.Net as one of the tags. The question does not contain any code, and does not relate directly to VB.Net - The question is applicable to WPF and the .Net framework in general, but not specific to either C# or VB.Net.
There is (currently) only a s...
@TimPost Hola little Timmy having your wifey picture when she sleep.......i send you? she is nice...you house must lock very good you know great mexico we take wife and kid — Bando el narcoz killer1 min ago
@FreshPrinceOfSO Hola timmy timmy having your wifey picture when she sleep.......i send you? she is nice...you house must lock very good you know great mexico we take wife and kid — Timmy Wifey28 secs ago
@LowerClassOverflowian You have no idea some of the comments that I have received when people are clued in to the fact that I am a woman. They range from shock to very sexist. — bluefeet54 secs ago
When you say my name it could be either (well depending on where you're from), but it always amazes me when Starbucks etc. write "Erin" on my cup. I mean, did you see me standing in front of you when I ordered my coffee?
@bluefeet sorry. I think you were the first female I ever encountered here. :-\
Definitely not. The community's sexism is inherited from the rest of society. The best analogy I have for this is the following:
A young boy and his father are in a car accident. The father dies at the scene. The boy is transported to the hospital, taken immediately into surgery... but the s...
So, basically it's laziness. Let the bulk of the filtering work be done by people who care a bit to make the final choice simpler, then when the votes really count let the community at large piggy back off the work already done. People are people I guess :/ — Bohemian4 hours ago
so, if you don't understand the reason for the primary phase of the election, then it's laziness?
@Bohemian Please answer the questionaire or withdraw your nomination. I've really been taken back by your recent meta question and comments. I really wish these could be visible under your nomination. — FreshPrinceOfSO10 secs ago
@ypercube I added it as a comment there because it was a reply to his comment, not directly focused on the question. But you are right, I could've added it as an answer instead....for some reason I try not to post answers on meta though
I really wish down-votes cost more rep. It's silly that +8/-8 = +24 rep. Like the other one, he'll leave that there until it starts getting him negative rep.
aaaand, now that I read my comment again I realize that I'm a broken english user.....why did I write "this whole process is incredibly value" instead of "this whole process is incredibly valuable"?, sigh
@Lamak that's better than what i'd type in any other language (except maybe german ... which is my best second language but you're better at english than i am at german)
@SimonRigharts ... apologies. i've been taken ill for the last few days and haven't really spent a lot of time online. do you have all that you need? jonathan kehayias has a lot of really good information. if you want something more then i'd be happy to work something up for you
So I was about to execute a SELECT ... INTO OUTFILE to generate a CSV, but the lead programmer won't let me run that and wants me to pipe the results to Java and have Java generate the CSV. He won't give me a reason, so I was wondering if there is some kind of performance issue with running SELECT ... INTO OUTFILE or some other reason that might justify this..
@Lamak It's not hooked up yet. They (independent contractors) just came to do the wiring yesterday throughout my complex (I live in a rowhouse). They apparently didn't finish so they are coming back today. I think Google will actually come by next week to officially hook me up.
I didn't know all of this yesterday because my landlord is horrible at communicating
@AaronBertrand I have a really bad lead programmer, he doesn't communicate with any of us and just tells us not to do stuff, but I want to improve as a developer.
@swasheck I've watched a grand total of two episodes of Breaking Bad since resuming my service in January (I was off of Netflix for several years, pre-dating streaming in fact). And I think my usage pre-dated the recent hubbub about it. Didn't notice any problems, but that series is not hi-def, so doubt I would anyway.
@FreshPrinceOfSO Verizon keeps begging me to pay $10 more a month for 50mb down. Wife's work pays, so I don't care, and would, but I just don't think I would notice a difference between 42 and ~50. I'm not downloading a whole lot of stuff, ever.
We'll go to the Lux once in a while, it's a premium theater with seat service, and catch a current flick. The movies I tend to watch at home are either the occasional on-demand (which Nicole's work also pays for) or whatever's on that I can sort of half-watch while doing other things.
There are times when I would be constantly looking for questions I could answer well and other times I attempted to answer anything at all (that didn't go so well usually).
So here it goes; Reddit has 1 thing going for it that I don't think Jeff Atwood will ever have. trust in the cloud.
That's...
Unless you specifically opened an account to post this rant, it doesn't appear that you have any ties to the community so how can you comment so strongly on something you aren't involved in? — bluefeet40 secs ago
A variation of this I find annoying, and which isn't exclusive to tools, is "Which is faster, x or y?"
Not because it's opinion-based. For the most part, with enough fixed criteria, it's actually very easy to prove which one is faster. But without those fixed criteria, it can very much be It Dep...
@bluefeet Aye, and glad to see you're above 5k on the primary
The real trick will be having those same people vote you to one of their three choices and not just assume that you might get elected by everyone else. That's happened once or thrice.
Mostly because people don't understand how the voting on SO works
@AaronBertrand Yup, but that's what will kill them in the end. My current gig is looking for ways to replace Oracle because of how stupidly expensive it is
What are the IO Bottlenecks in sql server. How to find queries or objects causing any Bottlenecks and how to reduce without loosing any data in production.
@FreshPrinceOfSO ok, do you have an idea what results the query is supposed to return? Or has nobody ever waited for the query to finish? Surely the person who wrote the query knows what it was supposed to return...
I mean, I could point you to cupcake recipes, but that would probably take you at least 275.9 minutes - unless you have all the ingredients handy and your oven is pre-heated.
I have the SQL Server Service Manager running everytime I startup Windows XP, the reason I want to fix BDE Administrator is because I have a Business Software th — Doomineer23 mins ago
th... that question reads like such a trainwreck. I'm torn between knowing more about it vs backing away softly
@FreshPrinceOfSO unless it's very very explictly named then just put it up on a private gist
The only reason I wouldn't want to be super explicit with the product at my job is because we're financial and could be compromised for funds transfers to external accounts.
But you would have to know a lot about the app in the first place to do that, and we're pretty security conscious
Hye programmers.
I need to install Microsoft server 2012 adv. I have checked my requirement and updates. Everything seems to be fine. However when i run to install the file, at the middle of installation suddenly the wizard closed. It happen after this wizard.
I think maybe is because of it s...
I want to compare Actual table with @TableType_TVP IF Duplicate Row Exist
Create procedure sp_InsertintoTable
@TableType_TVP TableType_TVP READONLY
AS
IF(Duplicate Row not Exist then)
Begin
INSERT INTO ActualTable
Select * from @TableType_TVP
Select Inserted row count also
...
The easiest way to get the result would be to use an aggregate function along with a CASE expression to convert the rows of data into columns, but you could also apply the PIVOT function.
select date,
placementname,
campaignid,
impressions,
clicks,
sum(case when activity = 'Mobile Book...
Mail
Mailid
-------------------------------
venkattaramanan1985@gmail.com
madanraj@gmail.com
Expected output
Name DomainName Extension
------------------- ---------- ---------
venkattaramanan1985 gmail com
madanraj gmail com
I am trying to run an .exe as a command in a SQL Server 2008 Agent Job as another user. I see that this can be done by going to the Job's Step properties-Advanced' option however I have no option to set 'Run As'.
Anybody know where this is?
What is the point? Why not just vote for the nominees who you want and the highest "n" get elected?
It's not like nominees have an election campaign (actually we are heavily restricted in character count), and there's no "super Tuesday" or any of the other USA-centric election components.
Where...
Why, do my where clauses here get ignored, it's summing invoices regardless of the valued entered as parameters, spent hours on this and going mad!
/****** Object: StoredProcedure [dbo].[usp_custom_dash_Metric_InvoiceSpend] Script Date: 02/19/2014 14:15:31 ******/
SET ansi_nulls ON
go
S...
Definitely not. The community's sexism is inherited from the rest of society. The best analogy I have for this is the following:
A young boy and his father are in a car accident. The father dies at the scene. The boy is transported to the hospital, taken immediately into surgery... but the s...
What are the IO Bottlenecks in sql server. How to find queries or objects causing any Bottlenecks and how to reduce without loosing any data in production.
