to actually be helpful im going to point you to another link. again from sommarskog.se

http://www.sommarskog.se/dyn-search-2008.html

it addresses variable search conditions in a very well thought out manner.

Lynn Pettis (7/26/2012)

---

Did you take a close look at how Jeff's split routine was modified?...

im getting a little confused, can you post DDL Sample Data and the expected output based on that sample data?? it would really help to have both the input...

anthony.green (7/26/2012)

---

Thanks Gents, been one of them days and nothing gone right so far, so my heads not in the game.

Gone with John's responce as its the simpler to impliment,...

at my shop we have nightly backups of our database restored to the same server under a different name. if something happens from the time of the last backup...

vchandm23 (7/25/2012)

---

CREATE PROCEDURE [dbo].[myProc]

@whereSql nvarchar(256)

AS

EXEC('SELECT [fields] FROM WHERE ' + @whereSql)

GO

From stackOverflow website. This is what i was looking for. I am sharing this here...

I would love to see the tests on that statement. ...

SQLCrazyCertified (7/24/2012)

---

capn.hector (7/24/2012)

---

it depends on how the user selects the columns they want. i would do any actual dynamic query creation with a stored procedure API level and validate...

n.heyen (7/24/2012)

---

Thank you Cap'n Hector,

I was sort of afraid that was the answer. I can create a db user and grant permissions. That works, I was just hoping there was...

For my own curiosity what is this part of the code doing:

select @random = convert(int,(((1) - @currLen) * RandomValue + @currLen))

from dbo.vwRandom;

Im guessing vwRandom is a view but the question...

in order to grant permissions to an object the server user must exist as a user in the database (unless when trying the same thing i missed something). the...

it depends on how the user selects the columns they want. i would do any actual dynamic query creation with a stored procedure API level and validate any input...

bill.schoonmaker (7/24/2012)

---

I did a bit of digging and found this script, located here - http://sequelserver.blogspot.com/2011/06/lists-user-login-attempts-to-sql-server.html

DECLARE @TSQL NVARCHAR(2000)

DECLARE @lC INT

CREATE TABLE #TempLog (

...

Honda

The grant command is what you are looking for

http://msdn.microsoft.com/en-us/library/ms187965.aspx

i may look at a custom database role so you do not have to grant every thing to multiple users. only...