Viewing 15 posts - 2,116 through 2,130 (of 3,957 total)
Steven Willis (1/22/2013)
Sorry dwain.c, I didn't test your code, but if you or anyone else cares enough it wouldn't be that hard to test it with the attached testing code.
No...
January 22, 2013 at 4:18 am
mister.magoo (1/21/2013)
DECLARE @t table(Col1 char(1),Col2 char(1),Col3 char(1));
INSERT @t(Col1,Col2,Col3)
VALUES('a','b','c');
SELECT Col
FROM @t as T
CROSS APPLY (VALUES(Col1),(Col2),(Col3)) AS CA(Col);
Silly me. I thought he was trying to split a delimited string....
January 21, 2013 at 6:08 pm
Another option is the paid version of the SQL# CLR library by Solomon Rutzky: http://www.sqlsharp.com/
There are two functions in it: INET_Ping and INET_PingTime that may be of interest to you.
As...
January 21, 2013 at 6:02 pm
Try using DelimitedSplit8K: http://www.sqlservercentral.com/articles/Tally+Table/72993/
January 21, 2013 at 5:51 pm
tyson.price (1/21/2013)
January 21, 2013 at 5:40 am
Mark - I'm not sure why you used two window functions:
WITH SourceRecordset AS (
SELECT [index], workcode, value
FROM (
VALUES(1, 'CL', 5),
(2, 'CL', 10),
...
January 20, 2013 at 6:05 pm
If Mr. Magoo's link doesn't give you any ideas, you might want to take a look at the 4th article in my signature links to retrieve the FUNCTION PatternSplitCM and...
January 20, 2013 at 5:43 pm
Writing the function as a iTVF might improve performance a notch.
-- =============================================
-- Author:ben brugman / dwain.c (sqlservercentral)
-- Create date: 20130118
-- Description:Does replace @in a str@ing
-- =============================================
-- drop function replace2
CREATE FUNCTION...
January 18, 2013 at 5:03 pm
Rats! Now why didn't I think of that?
+1 Peter
January 18, 2013 at 6:10 am
Not a fair race!
You:
- Removed the tool tip column from your INSERTs
- Your INSERTs were missing tons of commas and quotes
- You changed the IDENTITY_INSERT setting
- I think you changed...
January 18, 2013 at 5:46 am
vinu512 (1/18/2013)
I don't think your query would work if I change the data a little.
Try your query with this new data:
Insert Into ES_SubModuleMaster
Select 1,1,'Academic',2013-01-01 00:00:00.0002013-01-04...
January 18, 2013 at 4:46 am
anthony.green (1/18/2013)
If 1, you could look at changing the advanced properties of the step to have a retry attempts value of 2 and a...
January 18, 2013 at 4:41 am
ben.brugman (1/18/2013)
Thanks for your solution, tried to study the solution,'DelimitedSplit8K' is missing.
So I could not try the solution.
Sorry about that. I thought most folks were familiar with this FUNCTION,...
January 18, 2013 at 4:39 am
Probably will run a little faster with dynamic SQL though.
DECLARE @sql NVARCHAR(MAX) = ''
DECLARE @MyString VARCHAR(100) = 'aaabbcdefgh'
;WITH Replacements (n,a,b) AS (
SELECT...
January 17, 2013 at 11:13 pm
Special_replace2 ain't so hard:
DECLARE @MyString VARCHAR(100) = 'aaabbcdefgh'
;WITH Replacements (n,a,b) AS (
SELECT 1, 'aaa|bb|c|d|e|f|g|h','11|2|3|4444|5|6|7|8'),
Transform (ItemNumber, a, b) AS...
January 17, 2013 at 10:57 pm
Viewing 15 posts - 2,116 through 2,130 (of 3,957 total)