Viewing 4 posts - 1 through 4 (of 4 total)
Interesting, I never realised that you could order by a column alias.
I have to admit that I assumed that the same principle of not being able to use column aliases...
March 4, 2014 at 3:23 am
SQL Server 2012, with the SSIS Package being created in Visual Studio 2010
January 3, 2014 at 2:02 am
Lowell (1/2/2014)
can you add CLR procedures?
I've not thought of that, but I'll have a look at that later. I'm not 100% sure that I'll be able to create CLR...
January 2, 2014 at 3:35 pm
Luis Cazares solution works for me. Thanks!
Luis Cazares (12/2/2013)
You could use an ESCAPE character.
End SQL:
DECLARE @Table1 TABLE
(
Column1 VARCHAR(32) NOT NULL PRIMARY KEY
);
INSERT @Table1(Column1)
VALUES
('abcdef123'),
...
December 3, 2013 at 3:57 am
Viewing 4 posts - 1 through 4 (of 4 total)