RE: Temp Table results
Thanks Guarddata. I'll fire up QA and see what type of results I can come up with.
2003-07-08
Oracle
RE: Temp Table results
You can reference the temporary table the same as a permanent one within the procedure. Your "SELECT * FROM #CashIn" would produce a recordset. Test it by running the stored procedure from Query Analyzer. If you need to deal with the rows one at a time, you could use a CURSOR (see books online) but […]
2003-07-08
2003-07-08
RE: Hyper-threading
HI Steve, I haven't done any benchmarking myself but I remember an article telling that hyperthreading gives you about 1.2 times the performance of a single CPU. Unfortunately I can't find the site at the moment, but if I find it I will post the link. M
2003-06-24
RE: How much do you earn?
Hi racosta, quote: jaja, don't worry guys, here in Argentina I earn 8k only. And it is considered a very good salary. Things are not goin right here, but we do what we can. I know. I've signed some Argentina bonds for my fixed income portfolio. and pray that there will be no default! Cheers, […]
2003-06-19
1 reads
RE: CITRIX SNAFU
When he logs in to Citrix, he is effectively running a program on that system. Whatever account (including domain) he's using to log on to the Citrix server is the account that's going to be making the SQL Server connection. Does the account he's using through Citrix have permissions in the database? K. Brian Kelley […]
2003-06-12
RE: Job Permissions
Though sp_start_job defaults to the public role, a user needs to be able to see the job in order to start it. A user can normally see a job if one of the two are true: (1) User is a member of the sysadmin role. (2) User owns the job. However, in order to support […]
2003-05-21
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Extended Events to capture query causing tempdb log to get full
Hi! Query store provides information on workloads on tempdb How\Steps to setup Extended events...
How to append data to the previous row
Hi, I have a table that stores event transactions, the sample data see the...
Replacement for char and ascii functions in natively compiled stored procedures
I am trying to create a natively compiled stored procedure where I need to...
Ask SSC