oscar's blog

How to add DTS to SQL Server Management Studio

There are a couple of ways to access the DTS Import and Export utility in MS SQL Server Management Studio (MSSMS) 2005 and forward.

I am going to give a background on why I am writing about this error.  If you need to know how to fix it, go to the section that says, using p7zip.

The reason I began using a unix emulator (cygwin) was so that I can accomplish row counts on large data files.  The counts needed to be completed prior to being uploaded to a database.

As of this writing, I am pretty new to the linux/unix environment.  At some point in college I had  installed Mandrake Linux on one of my computers.  The most of I ever did on that was spoff text e-mails (to friends and family) and maybe use open office.  But since then I had not really messed with any type of linux variant of any kind, until last Friday. 

I came across this error the other day while creating a stored procedure in Teradata.  In my stored procedure I had a create table as statement with an SQL select statement followed by two SQL delete statements in the body of the procedure.

The way SQL Delete statements were written was the cause of the problem.  Specifically, the way you say not equal to.  In SQL you can say 'not equal to' by typing != or <>.  The Teradata stored procedure preferred the latter, <>.

For example if in your stored procedure you have:

Below are some example graphs of common equations and inequalities that you are likely to encounter.  

The method you use to draw your graph depends on the form of your equation.

slope intercept form:  y = mx + b

standard form:  Ax + By = C

For slope intercept form (y = mx + b) set your x = 0 and by default your y will be equal to b.  This will be your starting point.  From there you can use your slope to plot the next point.  Slope is equal to rise/run or y/x, so you would go up y places on the graph and across x places.  Draw a straight line between your two points.

Usually you want a quick easy response to the problem that you are searching for the solution to on the web, right?  Well here are two common reasons (with example code) why you may be receiving this error:

1.) On your join statement, your ON or AND statements are asking to join columns on a different table other than the two tables that you are originally intending to join.

Example:

Abstract classes allow for other classes to be derived from it.  However, an instantiation of the base class type (i.e. the abstract class) cannot be done.  To declare a class abstract, place the word 'abstract' between the access modifiers and the class keyword. 

Example:

public abstract class Vehicle
{
}

Within abstract classes you can have

 The following situation requires you to create 30 mL of a solution that contains 10% acid.  You have an abundance of 5% and 20 % acid solutions on hand to create the 30mL 10% solution with.  The question is, how many mL of each solution should be mixed together to form the 30mL 10% solution?

We can express the paragraph above by saying: 30mL of 10% solution equals x mL of 20% solution plus y mL of 5% solution.