|
|
-
ErikEckhardt Commented 6 Months ago through Just Learned | 1 Point
@Reuven is correct, and the original post has an error. However, the point being made is still valid, if only the error will be fixed.
Just change `INSERT #temp1 VALUES(3)` to use #temp instead, and then adjust the wording "while the query with EXIST...
|
-
ErikEckhardt Liked 6 Months ago through Just Learned | 1 Point
Any SSRS report is not re-displaying the changed information when running the same report back-to-back, even though the report itself is set with the following in the SSRS setup:
Always run this report with the most recent data, Do not cache temporar...
|
-
ErikEckhardt Learned 6 Months ago through Just Learned | 1 Point
Any SSRS report is not re-displaying the changed information when running the same report back-to-back, even though the report itself is set with the following in the SSRS setup:
Always run this report with the most recent data, Do not cache temporar...
|
-
ErikEckhardt Commented 7 Months ago through Just Learned | 1 Point
Using regex to validate email addresses is very difficult. The regular expression you presented does work in many cases but is very basic.
One example is that `+` is a valid character in an email name. You are going to make a lot of gmail users mad i...
|
-
ErikEckhardt Commented 7 Months ago through Just Learned | 1 Point
I think the real issue here, as another person has said, is the lack of proper aliases.
This problem of not using aliases and mistakenly getting an outer reference can happen anywhere an outer reference is allowed:
In the in ON clauses of joins re...
|
-
ErikEckhardt Commented 7 Months ago through Just Learned | 1 Point
Dishdy,
Convert your image column to `varbinary(max)` and you can `HASHBYTES` it all you like!...
|
-
ErikEckhardt Commented 7 Months ago through Just Learned | 1 Point
Unmatched:
SELECT *
FROM
#temp1 T1
INNER JOIN #staging_temp2 T2
ON T1.id = T2.id
AND NOT EXISTS (
SELECT T1.Name, T1.City
INTERSECT SELECT T2.Name, T2.City
)
Mat...
|
-
ErikEckhardt Commented 7 Months ago through Just Learned | 1 Point
This does work but can be slow for large data sets. May I recommend Itzik Ben-Gan's method when needing a huge number of rows:
WITH S1 (N) AS (SELECT 1 UNION ALL SELECT 2),
S2 (N) AS (SELECT 1 FROM S1, S1 B),
S3 (N) AS (SELECT 1 FROM S2...
|
-
ErikEckhardt Commented 9 Months ago through Just Learned | 1 Point
@Eric Thank you. A SQL 2012 instance is coming to my company in the near future, but not yet... so I am lamentably lacking in some of its features....
|
-
ErikEckhardt Commented 9 Months ago through Just Learned | 1 Point
@Eric Thank you. A SQL 2012 instance is coming to my company in the near future, but not yet... so I am lamentably lacking in some of its features....
|