What?
There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. ...
What?
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code.
Why?
I'm working with a system which stores XML strings ...
... it took to setup a website previously, and will plan the same again). My 15 years of web-development experience allow me to reduce the risk of nasty surprises and also allows me not have to Google search ...
...
Method #1:
Important! It took me two days to realize that underscores are not accepted in the type name (despite copying "custom_field.php" and wanting to call my type "user_projects")!!! My recommendation ...
... day. This meant that if in the old system, there was 1 row with an employee who took 2 days off, we would want 2 rows for that date for the same employee in the new system.
What we have:
SELECT
...
...
The TRIM in SSIS does not appear to get rid of new line and carriage return symbols!!! Use the Replace(String, "\r", "") and Replace(String, "\n", "").
Feedback
This solution took me two days ...
... dates one which was imported as a string (DT_WSTR) and another as a integer (DT_R8).
Why?
It took me a long time to figure this and it was only by trawling through columns that someone mentioned ...
...
Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would initially display properly but then the white background would disappear ...
Why?
Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite ...
What?
So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting ...
How to Display Report Execution Time in SQL Server Reporting Services 2008 R2
So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...
... this somewhere on my site, so it took a while again but I've posted my finished query here:
The base query to list mediawiki articles
Page ID, Title, Content, Category
SELECT
p.page_id AS ...
I'm storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround.
So this is regarding an error when trying to ...
... as these may affect the way the program takes a screenshot (shouldn't but these can sometimes confuse the program)
Rant
It's flimsy, crude but does what it has to do. The program itself too ...
... list of rules that must be followed:
I took this from Direct Admin but it has some useful guidelines for these kind of issues:
How to setup the Mail System
1) hostname must not match any domain ...
...
I can't really have a go at customers as it took 4 IT technicians deliberating over 30 minutes (remote support so we weren't there in person): The computer had two CD-Roms. The user put the disc in on ...
... of this.
March 2011 San Francisco, CreativeMornings (creativemornings.com) was Mike Monteiro, Design Director, and co-founder of Mule Design Studio (muledesign.com). This event took place on March ...
... rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows
This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes ...
This is just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL ...
... morning following someone else's complicated connection using SQL Server Management Studio and would not recommend anyone to go through the same rubbish.
I just took a step back and thought this through ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.