Hi, I would like to sort my Select statement with a unique sort, meaning I would like to put the data in a certain sort order neither ascending or...
Thanks Adriaan. Let me figured out if I can do this. If not, let me figured out whether I have a choice to skip this.
You can refer to topic with topicID = 19140. Thanks.
Okay, here is goes. I just figured out how to 'select' two columns from the same one column with different requirements. Now, I would like to create...
DECLARE @Var4 TABLE (RowNr INT IDENTITY(1,1), PopTotal INT) DECLARE @Var6 TABLE (RowNr INT IDENTITY(1,1), PopTotal INT) INSERT INTO @Var4 (PopTotal)...
IT WORKED. THANKS A BUNCH!!
It is giving me an error "Line 10: Incorrect syntax near '.'" I don't think it can take the PopTotal variable from the @Var4.
I have to tried your code and integrated into the my sql database. But, I would really want to say thanks. Whether it works or not, the help was...
Thanks Adriaan for your thorough explanation. Would you be able to do what you written on SQL 2000? I am having problems with the client app present...
I am still figuring this out...... This has cause a lot of stress and time.
Thanks KH for the help. I see where you are going to. However, I am not allow to add another column in the database. I should not edit the database,...
Dinakar, I followed your post and I got this error message "Subquery returned more than 1 value. This is not permitted when the subquery follows =,...
I thought of case too. But, I don't think it helps because for case, you need to provide a value to be included into the column of each rows. Plus, I...
I need to make a "select" statement that will create two columns with different requirements. My Database is like this. PopTotal Variance 2...
Separate names with a comma.
