Viewing 14 posts - 16 through 29 (of 29 total)
for some reason when I am doing a "select @@version" it's giving same last line on both SP3 and SP4 servers
The last line is shown like "Enterprise Edition on Windows...
January 17, 2006 at 10:14 pm
while checking the servers again I think the servers that have latest SP4 are giving "T" in the last column while others (that do not have SP4) are giving "NULL"
Although...
January 17, 2006 at 10:03 pm
On SELECT from view its the same result on all serves (as mentioned above)
SELECT * FROM test_view1
test_id some_test_value
----------- ---------------
200 T
January 17, 2006 at 9:43 pm
Sorry, while asking question I should have said "T" instead of "Y"
so the correct question, based on the sample data, should be:
WHY IS IT SHOWING "T" FOR SECOND COLUMN...
January 17, 2006 at 9:34 pm
One more clarification in the above example both "table1 and table2" are views, if that makes any difference.(sorry I should have named them differently in the previous example intead of...
January 5, 2006 at 10:55 am
Thanks PW
Appreciate your help.
December 21, 2005 at 2:44 pm
Thanks R. Brush.
I understand and I agree with what you described. But what I didn't know until I encountered this problem was that the view keeps the column position/number and...
November 23, 2005 at 8:43 am
One way that I can think of is to Use a UNION clause. Use whatever condition is needed in the first and then add UNION with required message and remaining...
November 22, 2005 at 3:53 pm
Thanks for all the help.
Unfortunately changing the application or it's architecture is not an option at this time for me. One thing though this is not a public web site...
October 11, 2005 at 2:19 pm
Thanks for the help "yaweah" and "Lowell". This definitely helps.
October 4, 2005 at 5:15 pm
I am sorry I think I put this question under "SQL Server 2005 (Yukon)" but actually I wanted to do above thing in "SQL server 2000"
October 4, 2005 at 10:01 am
Thank you so very much for your help RGR I really appreciate it.
Regards
October 3, 2005 at 9:53 am
Thank you very much RGR. This definitely helps.
I am having a little problem right now because of the "group by" clause because I am using it in a WHERE clause in...
September 28, 2005 at 1:42 pm
Viewing 14 posts - 16 through 29 (of 29 total)