Distributed Queries

Technical Article

TOP N with variables

  • Topic

I want to be able to select the top n results from a results table in a stored procedure but depending on the event I want to vary how many 'n' is. I thought that this would do the trick: CREATE PROCEDURE sp_best ( @NumBest [int], @Entry [int]) AS select top @NumBest Results.RunNo, Results.Points FROM […]

2001-11-15

Technical Article

SQLMail and Lotus

  • Topic

Hi all, I've made SQLMail send mails to my Exchange server and Outlook2000. But, my corporate is using Lotus. How do I send mails to my corporate mailboxes. Thanx in advance Parasu Parasu Raman

2001-09-05

2 reads

Technical Article

collation error

  • Topic

We are using Win NT and SQL server 2000 When I run a stored procedure, I get Server: Msg 137, Level 15, State 2, Procedure pr_delopp, Line 29 Must declare the variable '@oppid'. This is because variable @oppid is declared as @OppID (different case). The SQL server 2000 installation which is on my own machine […]

2001-07-19

2 reads

Blogs

New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters

By

My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Read the latest Blogs

Forums

Case statement with time

By pedroccamara

Hello everyone I hope everyone's ok. I have this query and I'm trying to...

what are the best books to become a SQL developer?

By vpmaciel

what are the best books to become a SQL developer?

what are the best books to become a DBA SQL?

By vpmaciel

what are the best books to become a DBA SQL?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers