You can define and use the alias [Set Disc] in the same statement using the following model SQL:

SELECT

[Set Disc] * 2 AS [New Disc]

FROM

(SELECT Value * 0.10 AS [Set Disc]...

If you want a site that does not give the very wise warning from MS, then check http://www.sql-server-performance.com/rd_traceflags.asp 

This just tells you what various trace flags do, but it is up...

If Unix System Services (USS) are enabled on the mainframe, then FTP is a recognised mainframe command.  BTW, it is all but impossible to run a mainframe nowadays without having...

Our standard is to have a windows domain group holding the DBA accounts, and give this group Sysadmin authority in SQL.  Having done that we delete the BUILTIN/Administrators entry.  We...

In my opinion, SQL batch job security is a total mess. 

If you do not have the SQL Agent proxy account enabled, then only members of sysadmin can run xp_cmdshell. ...

I have moved system databases, but not where replication is involved.  However, I do not see how replication will care where the database files are physically located.  One of the...

There were some MDAC issues, as W2003 MDAC is at a higher level than we were migrating from.  There were also some problems with a few apps moving from VB6...

In the statement below from Aaron you should use UNION ALL, not UNION.  A UNION on its own ALWAYS forces a sort to remove duplicates regardless of if duplicates actually exist.  A...

If you upgrade your production environment to W2003 before you upgrade Dev, you are asking for downtime.

We had some application coding issues when we upgraded, but these got found and...

"And honestly, I think an online community can't help you much with this question. That depends on too many factors in your company. And almost always it is a rather...

My preference is to keep everything under transactional control.  This normally means everything in a database, but also allows for MQ (etc) messaging.

If you have mixed flat file and database...

What DBMSs do you already have in-house?  If you only have SQL Server, go with that.  The support costs of bringing in anything else will outweigh any other advantages, unless...

The following partial example only has one pass through your CRM_CFM table, which should perform faster...

SELECT

 CASE

   WHEN CM_SHURA = 5 THEN RIGHT(CM_SADE,5) 

   else 0 end as amount1,

 CASE

   WHEN CM_SHURA = 1 THEN...

I think this can be done in 1 SQL statement.  I suggest you build the statement bit by bit, until you have what you need.

The first stage is probably to...

It is difficult to tell exactly what you want.  I think you should be able to get what you want in one SQL statement. 

My suggestion is to build your...