Viewing 15 posts - 196 through 210 (of 2,458 total)
-- Itzik Ben-Gan 2001
September 28, 2017 at 4:42 pm
-- Itzik Ben-Gan 2001
September 27, 2017 at 5:51 am
-- Itzik Ben-Gan 2001
September 26, 2017 at 12:03 pm
You are all over the place here. As xsevensinzx said, some examples/visuals would be helpful. Also, a better explanation of what you mean by, "Up until now, we used a...
-- Itzik Ben-Gan 2001
September 24, 2017 at 11:13 am
NEVER be so as to STUPID say "Before I will start Google.."; This just ended your care\er because anyone hires you, they will see this posting and know.
Everyone...
-- Itzik Ben-Gan 2001
September 21, 2017 at 2:18 pm
SQL Server is so weird sometimes.
select 'a'+++++++++++++++++++++++'b'++++++++++++++++++++++++'c'
returns abc.
-- Itzik Ben-Gan 2001
September 19, 2017 at 4:44 pm
I don't fully understand the req but here's some sample data and some t-sql code which might point you in the right direction.
-- sample data
declare @order...
-- Itzik Ben-Gan 2001
September 19, 2017 at 10:31 am
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @TXML...
-- Itzik Ben-Gan 2001
September 19, 2017 at 9:31 am
As drew said, you are likely dealing with a non-space whitespace character; what Luis posted will help you identify what that character is.
This can easily be resolved using...
-- Itzik Ben-Gan 2001
September 13, 2017 at 12:10 pm
Expanding on Jeff's comments - this is one of those things that's worth understanding as FOR XML can be a complicated topic. Wayne Sheffield's article, Creating a comma-separated...
-- Itzik Ben-Gan 2001
September 12, 2017 at 1:23 pm
I'm not a DBA anymore (SQL Developer.) In high school I was studying to be an artist but chickened out only because of fear that I would not make any...
-- Itzik Ben-Gan 2001
September 7, 2017 at 12:50 pm
-- Itzik Ben-Gan 2001
September 7, 2017 at 12:37 pm
-- Itzik Ben-Gan 2001
August 30, 2017 at 2:55 pm
-- Itzik Ben-Gan 2001
August 30, 2017 at 1:50 pm
-- Itzik Ben-Gan 2001
August 24, 2017 at 3:22 pm
Viewing 15 posts - 196 through 210 (of 2,458 total)