bpowers (9/21/2009)

---

If a user has permission to a program there is not a null value. There is no placeholder whatsoever. So, I can not use "permission is null" in a...

admin is on the right track;

i think you might need to start with a base table of all users, then join it to this table to generate your list;

something like:

Select...

OK, I don't think i would ever implement something "automatic" like this, because I strongly beleive that scripts have to be tested more than once to make sure they are...

also note you cannot have a GO statement inside your IF statements BEGIN /END block...

your example for part one would not be valid, it would have to be like this:

IF...

definitely a permissions issue;

there's several ways to set up how to get to the view, and it depends on how it's set up.

in my example below, because i decided...

In my opinion, functions are OK if you are getting a single row of data. but if you are getting more than one row, a functions should be replaced with...

does wrapping it in brackets help? plus it needs to be a 4 part name...server.database.owner.object:

does this work:

SELECT * FROM [VSMIADBGP01].[LPB_GreatPlainsUtils]..[vwADB_LPB_CONSOLIDATED_ACCOUNT_DIV_DEPT_BRANCH_YEAR_2009]

--or

SELECT * FROM [VSMIADBGP01].[LPB_GreatPlainsUtils].[dbo].[vwADB_LPB_CONSOLIDATED_ACCOUNT_DIV_DEPT_BRANCH_YEAR_2009]

i'd do it almost the same as the thetodaisies,just changed it to be ready for more dates to exclude:

valuedate NOT IN('20070731','20070724' )

way to go for posting the test data!

the trick is to join the table against a copy of itself.

the join condition is the orderlineid's must equal, but the statusID for...

i fiddled with COLLATE but couldn't find anything that works, so i reverted to a tally table to test true/false for High Ascii characers.

someone might have a better solution, but...

uogmsmith (9/17/2009)

---

Right, But once the data is put into the table, how do you keep it going to manipulate it? Trigger? Daisy Chained SPROC(Nesting)? Functions? know what I mean?...

sample data below, i was trying LIKE '%[^A-Z,a-z] %' but that's not working for me yet; still playing

create table names(

namesid int identity(1,1) not null primary key,

TheName nvarchar(60) )

insert into names(TheName)

SELECT...

also SQLRecon; it uses a combination of different techniques to find all the registrations, their versions, and more...even identifies blank "sa" password installations.

yeah with my method, it requires some disipline to create an extended property for all objects subject to versioning; it's a bit of a pain sometimes. if there's no current...

this might help:

if you have a stored procedure that returns a resultset, wether one row or a million rows, you have to define a table(probably a temp table) to capture...