Viewing 15 posts - 376 through 390 (of 844 total)
I would suggest replacing the double quotes in your SQL statement that pulls the data instead of trying to do it in SSRS.
July 19, 2018 at 8:03 am
Here is my thoughts on what this converts to, sort of. See comments for questions I had. This is not a one-to-one conversion, it is my thoughts on the equivalent...
July 17, 2018 at 2:35 pm
If they are new columns and your existing data will not be filled with valid data, then I would opt for creating a new table. If for your existing data...
July 13, 2018 at 12:39 pm
July 11, 2018 at 2:59 pm
I would rather see some fields have a NULL value rather than spaces or -1. This allows me to use ISNULL or COALESCE to assign a different field or value. ...
July 6, 2018 at 8:04 am
June 28, 2018 at 8:29 am
June 28, 2018 at 8:25 am
Have you tried to change the SQL to do an INNER join on your table dbo.tbl_termcode? I would think that would be faster than in the WHERE clause.
June 27, 2018 at 3:00 pm
Not sure what you are trying to accomplish here. If you are trying to compare a date on the table to be < June 21, 2018 at 2:27 pm
June 14, 2018 at 12:09 pm
June 13, 2018 at 9:06 am
My concern is the environment, what affect this will have on sea life? Let's quit using the oceans as a dumping ground. I know there is no visible waist, but...
June 13, 2018 at 8:05 am
June 12, 2018 at 2:40 pm
I was of the same thought as Steve and Jeff. But recently I've started using the MERGE statement, so far "knock on wood" I haven't ran into any issues.
June 12, 2018 at 10:56 am
Is this what you are after? SELECT ID, name, createdDate
FROM @sample
UNION ALL
SELECT NULL, NULL, NULL
June 7, 2018 at 2:32 pm
Viewing 15 posts - 376 through 390 (of 844 total)