If you are unable to run this select statement because of permissions, turn this into a stored procedure and then get execute permissions on the procedure if you can.

DECLARE@name sysname,

@db...

sp_helplogins

I'm sure Jeff will have a superior answer, but here is my inefficient answer:

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL DROP TABLE #TempTable

CREATE TABLE #TempTable (

Descr varchar(100)

)

INSERT #TempTable

SELECT 'This is to test...

Here's what I came up with. Thanks Steve!

DECLARE@crlf char(2),

@counter int

SELECT@crlf = CHAR(13) + CHAR(10),

@counter = 10 -- arbitrary number

-- Insert records in temp table

-- Remove hidden characters to get...

The information contained in sysdepends is needed to compare the results found in the requested query. A record will not be added to sysdepends if a procedure makes a...

Thanks! I'll try doing the search you suggested as well as looking into Red Gate's Dependency Tracker.

CREATE TABLE #Persons (

PersonID int IDENTITY(1,1) primary key,

PersonName varchar(20)

)

INSERT#Persons

SELECT 'Bob' UNION

SELECT 'Sally' UNION

SELECT 'Lara'

CREATE TABLE #Products (

ProductID int IDENTITY(1,1) primary key,

ProductName varchar(20),

PersonID int,

ProductDateAcquired smalldatetime

)

INSERT#Products

SELECT 'Fork', 1, GETDATE() UNION

SELECT...

That is absolutely perfect!!! Thanks Jeff.

I never heard of xp_DirTree and did not find it in BOL. How did you learn it? What other secret commands are...

There's nothing here...

The user, who is not using Query Analyzer, is passing the value. If the user passes 'beans' then great, they will get an error message. I believe since...

'' is being treated as 0. That's the problem when i want one result set for 0 and a different one for ''.

Ramesh, this returns all records when 0 is passed.

Jez, a paramater IS passed. If '' is passed, need all records. If 0 or any other number is passed, need the record for that number.

Ramesh, that does not return all records when '' is passed. Please see the third posting in this topic.

Yes! That works for 0. But now I don't get any records when '' is passed.