Viewing 15 posts - 1,501 through 1,515 (of 8,731 total)
Best option, stop getting values like that.
Alternative option, try the following code:
SELECT ID, CustomFields,
ISNULL(SUBSTRING( s.Item, 7, NULLIF(CHARINDEX('"', s.Item, 7), 0)-7), '') AS CustomId,
March 6, 2017 at 11:23 am
Hello
I am trying to get an output that will show me:
Total number of deliveries missed...
March 6, 2017 at 7:34 am
March 6, 2017 at 7:05 am
March 3, 2017 at 12:58 pm
March 3, 2017 at 12:54 pm
March 3, 2017 at 12:22 pm
March 3, 2017 at 12:17 pm
Here's an alternative. I'm not sure which would perform better as both have issues that can slow them down.
WITH CTE AS(
SELECT ColumnA, ColumnB, OtherData1,...
March 3, 2017 at 12:10 pm
March 3, 2017 at 11:52 am
Here's an option that can be easily converted into an Inline Table-Valued function.
DECLARE @String AS VARCHAR(100),
@Search_String AS VARCHAR(100),
@Ocurrence int;
...
March 3, 2017 at 11:50 am
adonetok - Friday, March 3, 2017 9:13 AMThe reason of using temp tables is for reporters only.
I'm sorry, but this makes no...
March 3, 2017 at 11:34 am
Change the * to include the columns you need separated by commas.
Avoid using FORMAT as it is very slow and use CONVERT instead.
March 3, 2017 at 11:07 am
March 3, 2017 at 10:13 am
Viewing 15 posts - 1,501 through 1,515 (of 8,731 total)