|
Hello. I run a nonprofit Wordpress-powered website for teachers on a Linux + cpanel server. I've been entrusted with the profiles--i.e., names, service number, address, email, phone number, test scores, etc--of thousands of individuals. All this information...
Started by tfc on
, 6 posts
by 3 people.
Answer Snippets (Read the full thread at webhostingtalk):
Additionally, the database would have to expect certain values.
Or individual user) level is a must.
|
|
I have records (Contacts, Addresses etc.) which should be accessible to any of the following ( incl. combinations , e.g. 2 groups and 4 individuals):
Everybody Members of multiple Groups/Departments Members of a single Group/Department Multiple Individuals...
Started by Alex on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Indicated on the base record ad hoc grants to individual users administrative roles Performance was fine this with a single view of a union of rights based on:
who created the base record the business unit indicated on the base ....
|
|
Hi Folks,
I've some work to do on a largish database which basically requires calling a stored proc with different parameters for every value in a table (approx. 20k entries). I want to do this without blocking on that table or the other tables involved...
Started by Robin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Better to replace the stored proc with a set-based.
That looping through 20000 records is a bad choice.
|
Ask your Facebook Friends
|
I want to run a report to make sure the password of every user is set to expire every 30 days, but the expiration interval doesn't seem to be stored in syslogins?
Started by Sard on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
With records you are looking for (in this case it is sp_addlogin, sp_modifylogin).
|
|
I'm writing a little desktop app that should be able to encrypt a data file and protect it with a password (i.e. one must enter the correct password to decrypt). I want the encrypted data file to be self-contained and portable, so the authentication has...
Started by Matt on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
He doesn't want spend that much time on his next target, so he records the result.
|
|
On Thu, 29 Jan 2009 17:53:00 -0800, JeffL <JeffL@discussions.microsoft.com
I have a union query set up, and I end up with FEWER records than one of the
individual tables it is composed of, which, I think, should NEVER happen.
What am I doing ...
Started by JeffL on
, 6 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Even if there are duplicates, if
query1 gives me 3.8 million records, shouldn't a union between....
I definitely don't want the duplicates.
Queryduplicates
I mispoke earlier, instead of "individual table" I meant "individual query".
|
|
Hi gurus, I have been burned by individual stocks ( mostly tech stocks) over the past years. Now I am thinking to buy individual high dividend yield stocks or dividend stock funds. Would be greatly appreciated if I can be advised as to which is better...
Started by veryseablue on
, 14 posts
by 11 people.
Answer Snippets (Read the full thread at bogleheads):
I cannot honestly think of any good reason....
Would.
Now I am thinking to buy individual high dividend yield stocks or dividend stock funds.
|
|
I have a stored procedure..
Proc: spMyStoredProcedure
Takes a Param:
@List varchar(255)
The @List would be a comma separated list of values i.e... @List = '1,2,3'
(clarity.. a single value of 1 would mean all records with col1 = true)
I have a table with...
Started by madcolor on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
I think this solves the problem:
declare @sql as nvarchar(max) set @sql = 'select * from table where col' + replace(@list, ',', '=1 or col') + '=1' sp_executesql @sql
This is assuming that list is not user-generated, and it's code generated, so I'm not... .
|
|
On Wed, 9 Sep 2009 07:50:13 -0700, ThriftyFinanceGirl <ThriftyFinanceGirl@discussions.microsoft.com
I am working code in the background through a continuous form -- creating
records in another table. What I would like to see is a color formatting...
Started by ThriftyFinanceGirl on
, 6 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
I haven't tested that yet: add a field to your table which
... .
I'm not sure it would highlight a
new record.
In Form_Current, store the PK value of the current record, but it seems to work for me.
TxtCurrentRecord
Visible: No
2.
|
|
On Fri, 31 Oct 2008 07:12:28 -0700 (PDT), "Teresa K." <teresa.kabourek@ngc.com
FMPro V6.04
Windows XP
Been doing alot of searching on this group, and have not come up with
anything like this.
I have a text field that my people enter in all their...
Started by Teresa K. on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
You could still do this, but it would require an extra step in the
middle to process splittng the Text Field and creating new ....
To get the control
number to go with it you might need a calculation
records.
Returns as record dividers.
|
