Hi!! Thank you all i found by my own after some tests thanks for the ideas
Ok i think i got it! And if i want to Add Table from another Table NumberC. For example: InsInsert Into NumberB(NumberB.*,Field80)...
Çé If i have 2 tables with names NumberA and NumberB and fields the same. For Example: NumberA: Value1,Value2,Value3,Value4,............Value60....
Because if i have a contion if else after i want to compare 2 variables
Ok thanks!!! So i cant return more than 1 result into variable??
Ok but if i have different tables for example: Declare @Result as float Select @Result=(T1.Field1+T2.Field2) From Table1 As T1, Table2 As T2...
Çé Sorry wasnt very specifiec! I mean i have 2 queries: 1)Select(T1.Field1+T1.Field2+T2.Field1+T2.Field2) From Table1 As T1 ,Table2 as T2...
Ok thanks a lot yes sorry i had forgot @! I have one more question if table Numbers have 3 records the above can work? It will print 3 results one...
Çé!!!! One question: If i have a query with calculations like this: Declare Result as float Result=Select (Number.Field1+Number.Field.2) From...
Hi one simple question how i can set a Table as something !!!?? For example Values as vl !!! How i can do that at start of queries or stored...
Again me one problem with if and else and one if i use top 1 it work but i get wrong results if i use top 3 its correct but then i get the same...
Ok it worked with top!!! Sorry i wasnt very specifiec!!!!!One more question!!!! When i use if else and i have may rows after if and many rows after...
I didnt get that what you mean!!! I use insert into but i have to put 3 results
No i have to return 3 valuess but i will try with top and i will see
My error is the above: Server: Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery...
sorry i cant be more specifiec!!!! I want to ask something else!!! I used if((....) >= (.....))else .... and it said to me in error i cant use if...
Oh god i know its tables it was an example to make you understand!!! I know how i will make the calculations between the 2 tables... My Problem is...
Hi i have 2 tables A and B.......With same fields!!!<br />For Example: A.Number1,A.Number.2 and B.Number1,B.Number2<br /><br />Now<br />i want to...
i didnt get it very good
Çé If i have to tables with Names: Values1 and Values2 The 2 tables have the same named 30 fields!!!! So i will use the tables like...
Separate names with a comma.
