Technical Article

RE: Temp Table results

  • Reply

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 […]


Technical Article

RE: Hyper-threading

  • Reply

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


Technical Article

RE: How much do you earn?

  • Reply

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, […]


1 reads

Technical Article


  • Reply

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 […]


Technical Article

RE: Job Permissions

  • Reply

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 […]



Daily Coping 3 Feb 2023


Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023


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...

Read the latest Blogs


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

By jay-125866

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

By MullerN

I am trying to create a natively compiled stored procedure where I need to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers