Viewing 15 posts - 196 through 210 (of 8,731 total)
I'm wondering if that value should be a NULL. Otherwise, it wouldn't make sense to have information from the Middle Age or Mayan civilization.
March 1, 2019 at 10:55 am
Here's an example on how to get a percentage of data that is not numeric. It can also help with all the conversion to numeric columns that has been suggested...
February 27, 2019 at 1:17 pm
Have you tried creating persisted computed columns that would serve as flags to identify valid rows? Just one column per table could give you the functionality and won't have a...
February 26, 2019 at 12:51 pm
SELECT COLUMN1...
February 25, 2019 at 2:48 pm
patrickmcginnis59 10839 - Monday, February 25, 2019 1:27 PMTechnically the semicolon IS following the previous statement %^)
Exactly, following the previous statement,...
February 25, 2019 at 1:39 pm
CREATE PROCEDURE dbo.MyProcedure @StartDate Datetime, @EndDate Datetime, @ReportingPeriod varchar(254)
As
...
February 25, 2019 at 9:25 am
February 25, 2019 at 8:49 am
February 25, 2019 at 8:35 am
By the way, an INSERT INTO...VALUES won't have problems with Parameter Sniffing, so you don't need to use RECOMPILE.
Have you considered not having lots of tables with uniqueidentifiers as...
February 22, 2019 at 7:18 am
February 22, 2019 at 7:13 am
If that query returns the correct result, I would just suggest to change the scalar UDF into an Inline Table-Valued Function. There's an explanation on how to do it in...
February 20, 2019 at 12:32 pm
as1981 - Tuesday, February 19, 2019 12:49 PMHello,Thank you. That gives me the result I need.
Thanks
That's good to know, but do you...
February 19, 2019 at 1:28 pm
Something like this could work if I understood correctly.
SELECT u.ColumnName,
u.ColumnValue
FROM tabDemo
CROSS APPLY (VALUES( 'Product Group', ProductGroup), ('Contact Type', ContactType)) AS u(...
February 19, 2019 at 10:09 am
Viewing 15 posts - 196 through 210 (of 8,731 total)