create table mstsubs (subjects varchar(200))
insert into mstsubs(subjects) values('aaan')
insert into mstsubs(subjects) values('baan')
insert into mstsubs(subjects) values('caan')
The output should be
I am using the following query but not working out.
from(select 'Select' as subjects union select subjects from mstsubs
union select 'All' as subjects union select subjects from mstsubs)x
order by case
when subjects = 'Select' then 0
when subjects='ALL' THEN 1
Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!
I've encountered valid database schemas that do not have a primary key. For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis. However, occasionally due to user error or a scheduled task…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes.
Assigning simple products to configurable: We assigned simple products…