Viewing 15 posts - 16 through 30 (of 81 total)
Are you able to help on this?
Greatly appreciate !
March 7, 2018 at 4:21 pm
so far i try to find max values from the string,
select firstname,
lastname,
firstname + '.'+lastname + cast(max(test)+1 as varchar(10))as number
March 7, 2018 at 3:42 pm
March 7, 2018 at 2:58 pm
March 7, 2018 at 2:49 pm
March 7, 2018 at 2:36 pm
March 7, 2018 at 1:22 pm
Jon.Morisi (7/6/2016)
There is a difference between an Alwayson Availability Groups and a alwayson failover cluster. It sounds like you're asking about the...
July 6, 2016 at 5:37 pm
John Rowan (5/5/2016)
May 5, 2016 at 11:35 am
Thom A (5/5/2016)
May 5, 2016 at 10:29 am
g.britton (10/7/2014)
You can also specify collation when you set the variable, e.g.
set @Foo = 'bar' COLLATE Latin1_General_CS_AS_KS_WS
I try as below
Select * from Openquery([AAA],'select [STARS].[dbo].[func_ConvertText](''abcd'')')
declare @blah varchar(100)
set @blah=(select...
October 7, 2014 at 1:39 pm
g.britton (10/7/2014)
COLLATION! That's a likely suspect. Can you find the collation of the databases where it works and compare it to those where it doesn't?
works
Latin1_General_BIN -...
October 7, 2014 at 1:28 pm
g.britton (10/7/2014)
Can you post the function? I'm wondering if it returns NVARCHAR and the problem you're seeing is in converting it...
October 7, 2014 at 1:18 pm
g.britton (10/7/2014)
1. please post the different results2. is it possible that the remote table was updated between the two queries?
Hi
Thanks for Quick reply.
I posted outputs.
Thats not a table, thats...
October 7, 2014 at 1:09 pm
Would the smallest number be "1" and the largest number be "14" for the following?
7,3-4AB1-3CD1-2,14EF(Y)
Yes you correct the max number is 14
is anyone have solution for this?
April 30, 2014 at 10:02 am
Viewing 15 posts - 16 through 30 (of 81 total)