-- get the first day of the next month of the date specified
SET @NextMonthStart = DATEADD(month, 1, @MonthStart)
-- prove to yourself that these dates are correct (sanity check)
SELECT @MonthStart, @NextMonthStart ;
-----and then:
b.bg_reported_date >= @MonthStart
and b.bg_reported_date < @NextMonthStart
@jcolebrand your logic is faulty. You said "add 300k for the folks that didn't upvote" but you failed to subtract the ones that did for the same reason. @ypercube is suggesting that they would equal out if you accounted for both.
BETWEEN is fine for integers, and whole dates (either DATE data type or when you can trust - and by trust I mean you have constraints and they are enforced). The DATEADD(SECOND, -1 stuff is really dangerous if you are dealing with any time component.
Unfortunately, the suitcase in the corner of the room hasn't packed itself in prep for tomorrows trip so I probably ought to start throwing belongings randomly in that direction until the lid doesn't shut
I wonder if anybody can explain for me what does it mean when we talk about IAM page for a clustered index? Also, what is IAM page number? What is IAM block number?
@MarkStorey-Smith post answer -> request feedback -> leave office on time -> respond to feedback and try to edit on iPhone. many points of failure in there
not to mention all of the fail within the answer itself
I'm trying to quickly determine if two sets of schedules are identical and also generate a key which these unique schedules can be references by. I originally attempted to use HASHBYTES but quickly discovered that you are only able to hash 8000 characters and I have a significant number of dateti...
I have a column named MR which is a varchar. When I run a query with an ORDER BY it doesn't seem to be ordered correctly.
select MR, LName, FName from users
where MR between 'MR20001' and 'MR20002'
order by MR
Results:
MR20001 | LINA | MARY
MR200011 | TEST | CASE
MR20002 | KO ...
Just hockey. Well, and I had an argument yesterday with Allen White, who feels hockey should be banned from hockey. He is at this game. I found it funny that there was a fight 3 seconds into the first period. :-)
Please demonstrate how LEN() is faster than CONVERT(SUBSTRING()), as I seem to have done the opposite. If you're going to discredit other answers please have some data to back it up. — Aaron Bertrand15 mins ago
hi everyone i have a problem when calling a function with composite type parameters can anyone help? Here is the question http://stackoverflow.com/questions/14454763/function-call-with-composite-type-parameters-in-postgresql-9-1-casting-issue
It won't be a bug: it's a flaw in your logic.
If you're looping, then it's possible that you are opening transactions on top of another transactions. That is, @@TRANCOUNT keeps incrementing. You may be incorrectly looping on say, a client timeout, that doesn't actually disconnect.
In your loop,...
as @gbn suggested earlier, please consider flagging this for over here if you are 3k+ on SO
hopefully this is not a duplicate question as I searched a lot for this..
I need to get the record from one table where date between June-31-2011 and June-31-2012.
the problem is that the result is just only display the records of year 2012 although the table has records for year 2011.
below is ...
I'm having problems with my differential backups, as explained in a question I posted yesterday here. Should I post a new question asking specifically about how to fix my differential backups? Or edit my existing one?
I have a function in Postgesql 9.1 called fun_test but it has an input parameter that is a composite type, i keep on getting an error of casting when i call it what could be the issue?
CREATE OR REPLACE FUNCTION netcen.fun_test(myobj netcen.testobj)
RETURNS boolean AS
$BODY$
DECLARE
tmp_code ...
On the subject of dates, a relatively unknown Oracle thing is: select DATE'2012-02-03' from dual; - It's ANSI syntax. Saves messing around with TO_DATE
I have a function in PostgreSQL 9.1 called fun_test. It has a composite type as input parameter and I keep getting a casting error when I call it.
what could be the issue?
CREATE OR REPLACE FUNCTION netcen.fun_test(myobj netcen.testobj)
RETURNS boolean AS
$BODY$
DECLARE
tmp_code smallint;
cur...
No, I need you to be able to troubleshoot what else is running on your system. I'm trying to give you pointers on where to look but I can't sit here all day hunting and pecking with you. — Aaron Bertrand49 secs ago
they basically said with a cut'n'paste job like this (rather than a question tailored to a specific site) they are usually willing to send it to the more specialized site so if you spot any more please flag them on SO for a mod and link to the dba version if you don't mind doing that :)
@ConcernedOfTunbridgeWells well writing to_date('20130101','YYYYMMDD') gets pretty quick after you've done it for the millionth time, but I resent the extra CPU cycles for calling the function ;)
@Zane that happened to me once, VW Touareg. When it finally turned over the dash was lit up like Christmas - engine light, oil was frozen, brake fluid was frozen, transmission fluid, anti-freeze - I think the only thing that wasn't lit up on the dash was the temperature gauge - I don't think it was built to measure that low.
@CadeRoux that may be a bit harsh. I say strap him to a data entry terminal, tie his hands to the chair, and put a pencil in his mouth so he can click 'Y' repeatedly.
Aaron, I updated the question with the solution. This is just a look-up table and is not tied to any particular database. I hope that helps. — jp2code48 mins ago
@AaronBertrand curious you say that.... I have a theory about this. Oracle is treated better in corporates coz of how much it costs and how much tuning it needs. Any tom dick or harry can't start fannying around with it like they do wth MSSQL
Canada has it right. Every single car sold (since the 80s I think) must have a block heater and must have daytime running lights. And there is a premium on houses with outlets outside to plug the block heater in...
@gbn oh ... i got myself backward again. i forgot you were in malta and i assumed it was "summer time" (for some reason i thought you were southern hem.). that's a perfect summer temp for me.
@swasheck Thing is, as long as we provide our service over the Internet, the best place for our gear is next to the internet exchange points, anyway. Impractical and really no need to have offices nearby.
@Roy lots of Malta based companies do that. UK or Swedish parent company, some business folk there, code monkeys in malta, kit in London or Amsterdam etc
@AaronBertrand That's a kid swimming in about 10 inches of (very cold) water. But it was warm enough for shorts. Luckily my kids didn't fall in, but this kid just wouldn't listen to his mom and got wet and then decided he would just keep getting wetter.
Egads. This guy says he is getting a PK violation error trying to kill spids:
Its give me error "Violation of PRIMARY KEY constraint 'PK_tbBillerList'. Cannot insert duplicate key in object 'dbo.tbBillerList'."
God help me with this prob....
:) — Sagar Upadhyay31 mins ago
tb = table, get it? In case you didn't know you were selecting from a table, it has a helpful prefix - the more you type those extra two characters, the less likely you are to forget it's a FUCKING TABLE
@AaronBertrand last time I went off using standard approved programmer workplace language, a bunch of mods I didn't recognize swarmed in here and deleted them.
@gbn And none of that nasty smell floating over from France?
@Lamak I am not sure. But when the review queues were opened up there were people approving junk edits. Upvoting crap questions/answers to work towards badges
We are developing a .NET application with a SQL Server back-end. The client requests the ability to dynamically add custom attributes to entities after the application has been deployed.
As suggested in a similar question we could create a table which would then contain a row for each custom att...
I went to a Late Answers review queue that had four items in it and started reviewing the first one by editing it into shape rather heavily.
By the time I was done, someone else had reviewed the same post simply by upvoting it, so I only got a "Next" button, not an "I'm done" button. My edit st...
@gbn @zane Actually, I've worked with an app that solved that problem, but basically by fully normalizing the data structure.
Basically, the app was designed to load and store flat files for email marketing, so it could be any number of columns with varying data types. Stuff was stored in the database as name value pairs, basically unpivoting everything. It was fairly elegant and worked pretty well.
I had a friend who installed a TV in his bathroom. He said it was so when friends were over for the big game they would never miss a beat. I think he had some intestinal issues.
And by "installed in his bathroom" I mean every bathroom in the house, and not just placed on a cabinet or hung up on the wall, actually built into the wall
Okay, so after spending a few hours on this, and following numerous online tutorials, I still cant get this working.
Basically, I have the Combobox displaying a <> option. But for the report, it doesn't actually return anything. It's just simply there for aesthetics at the moment. How do I...
I caught myself saying "records" when I should have said "rows"... then I got scared and fixed it as fast as possible so I wouldn't make Aaron cringe...
While reviewing code that determines who should receive mailings due to regulatory reasons, I noticed there's a branch of logic that isn't right. Each week for the past let's-not-say-how-long, we've sent a 4 page letter to these individuals. I can't believe they haven't contacted us saying STOP
So I purchased a new truck two weeks ago. Went ahead and went with Lojack for an extra $10/month in my load. Just updated my insurance and having Lojack dropped my insurance by $20/month. Winning!
@billinkc Good. Busy. Was spending more time on here between November and January but then got slammed past 4-5 weeks. Coming out of that rush soon, I hope :)
@MikeFal I still need to finish the original mission. I stopped at the final because what, you couldn't go back and get all the stuff once you finished or something like that. Been forever since I've even hit bnet
@billinkc Yeah, I haven't touched SC2 in forever. Played the campaign, some games vs. the computer with my pals, but never really much cared for ladder play.
@MikeFal We got the Wii U for Christmas, just finished Skylanders. I got a beta invite for Ingress which I think provide an an excellent for combining gaming with real world exploration. It's basically 4square crossed with Species (the movie).
My theory is that I will now start running different routes in the morning based on available stuff from the game.
@swasheck I've heard that hardcore folks wanting to do anything on Android install the android tool kit and then run a phone emulator. Blue stacks or something like that
@CadeRoux I bricked my phone 4 hours before the invite came and Sprint won't let me turn the old one back on without a plan change so I've only been able to try it out at places with open wifi
Of course, I'm almost to level 8. We had a lot of excitement last night. Someone came through with two accounts - looks like a shill and I reported it, but who knows what's going on. Really screwed with Enlightenment in town more than Resistance, but I reported them anyway.
@billinkc They came through as Resistance and wiped out all the enlightenment portals, then switched over to Enlightenment account and deployed. Then repeated in another section of the French Quarter. Totally wiped out an Enlightenment farm of a half-dozen L5/L6 portals
I couldn't live without my smart phone now. Having google maps handy, using it as my portable music player, having web access almost anywhere......love it
Isn't that part of the arrangement? The corp pays for my phone and service and let me use it for whatever, in return I'm usually available outside office hours
I don't mix work/personal phone stuff. Mostly because my company reserves the right to wipe everything from the phone they supply me for security reasons.
It's annoying to carry two phones, but I'll suffer due to the control it gives me. Plus, I really don't like the iPhone (now that I'm using one) and vastly prefer the Droid interface.
@MikeFal that's fair. i just lay low. those who need the number have the number. everyone else is relegated to email or calling my wife to get ahold of me
@Roy Interestingly enough, our mobile phone policy explicitly prohibits use of cloud sharing/storage systems, such as iCloud, Skydrive, Google Drive, and Dropbox.
SO rep math is silly. I don't care about 20 rep but if you don't give me an upvote because I'm over the cap, then later you take away up-votes from a deleted question, the upvotes I wasn't allowed before should be adjusted.
@MikeFal We don't have that policy, but then we provide Software as a service and expect customers to trust us with their data... Talk time is less of an issue than display time, I think.
The worst is when there is a downvote (or multiple), or a user was removed, or a migration, right before 0:00 UTC. I've had cases where it reduced my rep for the day by over 100, yet I had more than 10 up-votes that I didn't get credit for.
I'm bitching here and not on meta only because I know better than to suggest the current algorithm is stupid.
For me it's ok - UTC for today ends at 7 or 8 PM for me, depending on DST, so "today" ends right about when I'm sick of the computer on most days anyway.
@AaronBertrand This question makes me want to ask your opinion on the way that SQL Server uses the DATEDIFF function. Do you agree with the result of SELECT DATEDIFF(YEAR,'20121231','20130101') being 1?
In the process of some age calculations. I'm a bit of a novice when it comes to SQL but I've been tasked with singling out persons who will turn 65yrs old as of 31 March 2013. So far I'm able to calculate age based on given DOB, however I'm having issues singling out these persons. I'm thinkin...
@Lamak I certainly do. DATEDIFF measures the number of intervals that have been crossed, not the absolute distance. Since it returns an integer, how else would you expect it to deal with DATEDIFF(YEAR, '20120101', '20121231')? If that should round up to 1, when do you stop rounding up to 1? All the way back to July 1?
@AaronBertrand I kinda like it, let's me tell management something they want to hear in a matter of seconds. Just has me worried when it's not complaining about something :)
I need to check a condition before inserting a row into the table. Is it possible in codeigniter?
I wonder if anybody can explain for me what does it mean when we talk about IAM page for a clustered index? Also, what is IAM page number? What is IAM block number?
I have a column named MR which is a varchar. When I run a query with an ORDER BY it doesn't seem to be ordered correctly.
select MR, LName, FName from users
where MR between 'MR20001' and 'MR20002'
order by MR
Results:
MR20001 | LINA | MARY
MR200011 | TEST | CASE
MR20002 | KO ...
It won't be a bug: it's a flaw in your logic.
If you're looping, then it's possible that you are opening transactions on top of another transactions. That is, @@TRANCOUNT keeps incrementing. You may be incorrectly looping on say, a client timeout, that doesn't actually disconnect.
In your loop,...
I have a function in Postgesql 9.1 called fun_test but it has an input parameter that is a composite type, i keep on getting an error of casting when i call it what could be the issue?
CREATE OR REPLACE FUNCTION netcen.fun_test(myobj netcen.testobj)
RETURNS boolean AS
$BODY$
DECLARE
tmp_code ...
Okay, so after spending a few hours on this, and following numerous online tutorials, I still cant get this working.
Basically, I have the Combobox displaying a <> option. But for the report, it doesn't actually return anything. It's just simply there for aesthetics at the moment. How do I...
In the process of some age calculations. I'm a bit of a novice when it comes to SQL but I've been tasked with singling out persons who will turn 65yrs old as of 31 March 2013. So far I'm able to calculate age based on given DOB, however I'm having issues singling out these persons. I'm thinkin...
