It is, but also somewhat frustrating. It seems odd to me that there isn't an automatic session-specific, private temp table mechanism. It doesn't seem like...

You mean create a permanent table that would stay in the database? I could,...

Gazareth (8/9/2012)

---

Sounds like an interesting problem!

I might be oversimplifying this, but is the purpose of each step just to refine the selection criteria (i.e. your WHERE clause)?

If so, would it...

Unfortunately, I don't have all the actions available at once. I need to create the table and return a count to...

myheadhurts (7/30/2012)

---

I wouldn't start splitting out your functionality into separate sprocs in the hope it will improve performance. Spend the time to understand why the slow ones are...

I just tested my original version (with all parameters and the AND/OR constructs) with the RECOMPILE instruction and it uses the indexes, just as when I coded the individual statements...

Thanks, that also helped clear up some confusion about injection...

I've just assembled this:

alter PROCEDURE [srchAkc].spAkcesIDSrch

-- Add the parameters for the stored procedure here

@AkcesitPred varchar(2) = '',

@Akcesit int = 0,

@Rok smallint = 0

AS

BEGIN

SET NOCOUNT ON

-- Direction variable

declare @tw tinyint

set...

Yes, I've done that in...

What do you see when you print sSQL right after this statement?

sSQL = "SELECT * FROM parameters WHERE printer_type & " & pType & " = " & pType...

No arguments from me on this one. I remember in one of my first programming courses, assembly language on a Univac 9300, one of the things the prof stressed was...

djackson 22568 (6/28/2012)

---

I have not used KeePass, but I do use Password Safe. It is a fine product, and the ability to have all my passwords in one place...

I use a system of passwords, generated according to a fixed set of rules, that are easy to remember but impossible to guess. It's easy enough to think up such...

I'm NOT relying on RAID to replace backups. I do backup regularly, just manually and not every day - sometimes days go by with no new data. I'd like to...

I did lose a disk about two months ago, in the RAID 5 set. The server wouldn't let me connect remotely, but otherwise kept running. I and several others from...