Viewing 15 posts - 4,396 through 4,410 (of 5,109 total)
Thanks Drew, but could you please help me understand why below code works? Below...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 2:44 pm
agerard 65681 - Monday, January 23, 2017 9:26 AM
This does discuss how to resolve the problem, did it work for you?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 9:40 am
Luis Cazares - Monday, January 23, 2017 6:44 AMHurry up! The NFL season is almost over. Until then...Go Falcons!
All this time,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 7:04 am
lukaszpiech - Monday, January 23, 2017 5:05 AMI've made a mistake posting in the SQL forums so I am sorry.
No worries, my...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 5:08 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 4:55 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 4:41 am
Maybe not give new users the ability to create polls:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 4:20 am
Not sure if you meant rows, or comma delimited, so here's both:USE DevTestDB;
GO
CREATE TABLE #Numbers (Num INT);
GO
INSERT INTO #Numbers
VALUES (1),
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 4:17 am
--==================================================================================================
-- These variables could be parameters for a stored procedure
--==================================================================================================
DECLARE @pFilePath VARCHAR(8000)
,@pFmtFilePath VARCHAR(8000)
;
SELECT @pFilePath = 'C:\Temp\test_loading_UnixCommandOutput_to_SQL.txt'
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 2:43 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 23, 2017 at 2:29 am
First name - Mary
Middle Name - B
Last Name...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 20, 2017 at 1:56 pm
Sorry, mw112009, but again, Google... SSRS Enable Send subscription by email
I don't mean to be rude, but please try solving your problem first, rather than coming straight to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 20, 2017 at 1:05 pm
Something like this?SELECT LEFT(N.Name, PATINDEX('% AND %', N.Name)-1) + RIGHT(N.Name, CHARINDEX(' ',REVERSE(N.Name))) AS FirstConsumer,
RIGHT(N.Name, LEN(N.Name) - (PATINDEX('% AND %', N.Name) + 4)) AS SecondConsumer
FROM...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 20, 2017 at 12:58 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 20, 2017 at 12:45 pm
What is the full logic here. I was trying to fathom from your figures, and thought that you took the max value, which works for 01 and 02, but not...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 20, 2017 at 12:22 pm
Viewing 15 posts - 4,396 through 4,410 (of 5,109 total)