Viewing 15 posts - 5,566 through 5,580 (of 8,731 total)
You're right, it wasn't about performance. It's because the splitter works on a single char basis. Modifying Alan's example could give us undesired results.
SELECT *
FROM dbo.PatternSplitCM('blrah1 \r\ bl\ah2 \r\ blah3','%[\r\]%')
WHERE...
November 6, 2014 at 8:24 am
Here are some examples on how to do it with the DelimitedSplit8k. The function code and explanation can be found in the following article: http://www.sqlservercentral.com/articles/Tally+Table/72993/
SELECT LEFT(Item, CHARINDEX('.', Item)),
...
November 5, 2014 at 5:54 pm
Now, the question would be, do you understand it?
Remember that you'll be the one supporting it. Feel free to ask any questions that you have.
November 5, 2014 at 2:48 pm
Thank you for the feedback. 😉
November 5, 2014 at 2:40 pm
Do you need more help with this?
If so, could you post sample data and expected results?
November 5, 2014 at 2:40 pm
I don't have sample data to test, but this might help you.
WITH AvailableDates AS(
SELECT customer_id,
order_date,
...
November 5, 2014 at 1:57 pm
Do you need something like this?
DECLARE @Team nvarchar(255) = 'TeamA';
WITH Winners AS(
SELECT *,
CASE WHEN Home_Score...
November 5, 2014 at 1:40 pm
It seems that you have a poor design and that's making everyone confused. You should review what's going on here.
That said, this might help you:
CREATE TABLE SampleData(
...
November 5, 2014 at 10:02 am
Note that those functions aren't intended for multi-character delimiters.
November 5, 2014 at 9:53 am
Can you post an example of what you mean by empty last Column?
Is it something like this?
Column1,Column2,Column3
1,Something,
2,Sometext,
Or like this?
Column1,Column2,Column3
1,Something
2,Sometext
November 5, 2014 at 9:13 am
I forgot to include the safety net. 😉
SELECT string, RIGHT( string, CHARINDEX( '/', REVERSE('/' + string)) - 1)
FROM (VALUES('/Product_Images/small/1/10032.png'), ('JustImage.png'))x(string)
November 4, 2014 at 4:10 pm
This might help.
SELECT string, RIGHT( string, CHARINDEX( '/', REVERSE(string)) - 1)
FROM (VALUES('/Product_Images/small/1/10032.png'))x(string)
November 4, 2014 at 3:49 pm
There's a BULK INSERT command in SQL Server. You can read about it in here: http://msdn.microsoft.com/en-us/library/ms188365.aspx
To add functionality using format files, you can read the following article:
http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/
November 4, 2014 at 11:22 am
Are you sure that you're using the same view and not different views with the same name and different schema? Is it possible that the information changed between each query?...
November 4, 2014 at 9:21 am
cbrammer1219 (11/4/2014)
I am subtracting Pending time 735510.30987 from Delivered time 735510.40448 and get call duration 0.09474, but I want to convert this to standard time.
And what do those values mean?...
November 4, 2014 at 9:09 am
Viewing 15 posts - 5,566 through 5,580 (of 8,731 total)