Some memory aids for me so that I don't have to keep looking them up:
/*
.joe_subtable td
.joe_subtable i
.joe_subtable .jst_label
.joe_subtable .jst_pre
.joe_subtable .jst_fn
*/
MySQL ...
What?
This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code.
Why?
I ...
... data but the same length and the same type of data.
Why?
The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The ...
...
(LENGTH(TRIM(TRANSLATE(:ParameterToCheck, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ' ')))) AS NotAlphaNumeric
FROM
...
-- Transact-SQL
-- 0 if is alphanumeric, 1 or ...
...
This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer literate so the SQL query had to do the bulk of the work. The SQL query we ...
... this
I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX expressions" but ...
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 ...
... but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the Transact-SQL query:
CASE DATEPART(DAY, [MyDateValue])
WHEN 1 THEN 'st'
...
... Union or MoneyGram. These services are not meant for transactions between strangers. In our experience they’re favoured by fraudsters. One popular trick is to ask you to prove that you have funds by sending ...
... under this section in, or with, or specifically for use in, a User Product, and the conveying occurs as part of a transaction in which the right of possession and use of the User Product is transferred ...
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.