Comments by Zerotimedev

Zerotimedev 2-Oct-14 23:28pm View

cheers ill stick with the console app thanks

Zerotimedev 2-Oct-14 21:30pm View

i was trying to work out ways to make deployment easier basically, i dont think hosted servers will really allow for a batch file or windows service to run on their end. Any other ideas?

Zerotimedev 2-Oct-14 21:30pm View

i was trying to work out ways to make deployment easier basically, i dont think hosted servers will really allow for a batch file or windows service to run on their end. Any other ideas?

Zerotimedev 2-Oct-14 21:07pm View

so i should just not use these packages like hangfire etc... and run as a sceduled console app or even a windows service instead?

thats what i was originally thinking but thought i might investigate these other solutions.

Zerotimedev 18-Sep-13 2:02am View

You could create a LoanResults table, then run a query to insert the results of your query into that table.

Im still not 100% sure if its what you are after, but I still think if you wish to keep the data then you need somewhere to store it and if you are happy using tables and SQL then you can just store it in a table. Then you can either run queries from those tables and report from that.

Hope it helps...

Zerotimedev 17-Sep-13 17:41pm View

Deleted

Forever? So would you not write them back to a table if you are using SQL only, using an 'insert' query like this

http://www.w3schools.com/sql/sql_insert_into_select.asp

Otherwise you would write code to read the results into whatever format you are after...

Zerotimedev 17-Sep-13 17:33pm View

Lol thats kool but I was expecting these to run in a single query not 2. If this statement is to be split up then I would recommended a transaction anyway.

Zerotimedev 17-Sep-13 7:57am View

I'm the same I tend to always use a left outer join and work left to right. :)

Zerotimedev 17-Sep-13 7:23am View

I read this like 3times and I'm still not 100% sure what you are after. What do you mean by hold? Do wish to retrieve one set of results into memory then select from that or something completely different ?

Zerotimedev 16-Sep-13 3:47am View

Have you tried disabling all the other events except one to start with or even outputting results from each event to ensure the right events and code is running. Maybe something is running more than once. Not sure but sometimes the simple things are worth checking.

Zerotimedev 15-Sep-13 23:18pm View

yep got that working, thanks, sometimes just need a suggestion to wake ur brain up lol thanks...

:)

Zerotimedev 15-Sep-13 22:58pm View

i think from the tests i tried it needs to be set as the 'from' table to update. If you needed to reference another table then you would inner join to that, otherwise if you need to update 2 tables you will probably just need a second update query.

Zerotimedev 14-Sep-13 5:35am View

Worked great thanx for the help

Zerotimedev 13-Sep-13 2:36am View

that looks like what im after, thanks i will give it a crack shortly :)

Comments by Zerotimedev (Top 14 by date)