Viewing 15 posts - 1 through 15 (of 24 total)
Yes, you are right. This is why I provided a desired output.
Anyway, I did it differently,...
🙂
April 11, 2007 at 7:04 am
Now everybody howl and kneel before Peter Larsson!
Peter, this is very close to what I was looking for. Thank you.
I just have to...
🙂
April 10, 2007 at 8:28 am
Here is the sample data.
In the DesiredOutput you find with bright green background the records where the Exceptions have been aplied. In all other records, the Default ConversionRate has...
🙂
April 10, 2007 at 2:58 am
David!
The first solution is out of the question It is too static solution. If one of the combinations changes,...
🙂
April 7, 2007 at 2:01 pm
Make the account of the SQL Server service domain admin, and you can do whatever you want. Even execute remote .exe files
🙂
April 6, 2007 at 9:16 am
I also vote for Steve's solution. But I would change the second statement using a left join:
insert INTO Table1
(Firm, ID)
select table2.firm, table2.test
from table2
LEFT JOIN table1
ON table2.firm = table1.firm
WHERE table1.firm IS...
🙂
April 6, 2007 at 6:43 am
Could you be more specific? Or could you provide some example?
It seems, that basically you are saying: "I need to order a table, but I cannot use order by on...
🙂
April 6, 2007 at 6:27 am
What about current process/services rights on the other server?
Typical problems in this cases are, that the NTuser under which the process trying to start the job has no appropriate permission on...
🙂
October 20, 2004 at 9:12 am
Hi Mike!
You saved me from a lot of trouble!
For a smaller database it took me a half day to get done this job done "manual".
When I got to a bigger...
🙂
December 15, 2003 at 6:11 am
Ok!
Thank you Antares for your help!
Best regards,
Botond
🙂
July 1, 2003 at 11:21 pm
Ok. Thanx everybody for your help.
But I need some more ideas. The solution I am looking for must be one that is not affecting the code that is already written....
🙂
June 30, 2003 at 12:08 am
Thank you, hurcane, for your help!
It always helps to see some new solutions!
Best regards,
Botond
🙂
June 29, 2003 at 11:46 pm
You are wright. From the example I just gave, this is the conclusion.
But I simplified my problem in this example.
Believe me, in may case SoredProc2 is necessary, because it is...
🙂
June 26, 2003 at 5:15 am
A (primitive) solution could be joining 4 time the table with itself, like this:
select
tbl3.col1, tbl3.col2,
tbl3.col3, tbl4.col4, tbl5.col5, tbl6.col6
from
(select * from #tmp where col3 is not null) tbl3
inner join
(select...
🙂
June 26, 2003 at 3:06 am
Thank you! :))
Your's is faster and much more simple. 🙂
Probably that's why I didn't manage to figure out myself... it was too simple! 🙂
Thanx again for your time!
Best regards,
Botond
Edited by...
🙂
May 22, 2003 at 7:39 am
Viewing 15 posts - 1 through 15 (of 24 total)