Database

Blue_Boy wrote:

select
case when [type]=1 then 'MCA' when [type]=2 then 'Another Title' end + ' (' +
coursename +')' as TypeAndCourse
from courses

SELECT [Coursename] + '(' + case when [type] = 1 THEN 'Regular' when [type]=2 then 'Another Title' end + ')' as TypeAndCourse
from courses

Declare @Course table ([Course Name] Varchar(100),[Course Type] Int)
Insert Into @Course
	Select 'MCA',1 Union All
	Select 'MCA',2

;With CTE AS(
	Select [Course Type] = 1,[Course Description] = 'Regular' Union All
	Select [Course Type] = 2,[Course Description] = 'Distance'
)

Select 
		Result = 
		c.[Course Name] 
		+ '('
		+ CTE.[Course Description]
		+ ')'
From @Course c
Join CTE ON c.[Course Type] = CTE.[Course Type]

Select
	Result = 
			Concat(
					c.[Course Name] 
					,'('
					,CTE.[Course Description]
					,')'
				  )
From @Course c
Join CTE ON c.[Course Type] = CTE.[Course Type]

Result
MCA(Regular)
MCA(Distance)

where 
       !string.IsNullOrEmpty(record.Field<string>("userpk")) 
       ? record.Field<string>("userpk") 
       : null

Member 8003276 wrote:

a network related or instance specific error has occured

Bastard Programmer from Hell

a2bj wrote:

you should the check the host, user name and password in your configuration and make sure that they correspond to the information given by the administrator of the MYSQL server

jrahma wrote:

something like this (but throwing error!)

Bastard Programmer from Hell

select ('973' + contact_moblle) AS mobile_number from persons where contact_moblle is not null and contact_moblle != '' and len(contact_moblle) = 8 and left(contact_moblle, 1) = '3' GROUP BY contact_moblle order by file_no

;With CTE AS
(
	Select 
	     Rn = Row_Number() Over(Partition By ('973' + contact_moblle) Order By file_no)
	     ,('973' + contact_moblle) AS mobile_number 
	from persons 
	where contact_moblle is not null 
	and contact_moblle != '' 
	and len(contact_moblle) = 8 
	and left(contact_moblle, 1) = '3' 
)

Select mobile_number
From CTE
Where Rn = 1

select regexp_replace(d_name,'Mc[a-z]', 'Mc' || upper(substr(d_name, 3, 1))) n from
(
select 'Mcfix' d_name from dual
);