Find 5 Random Users, Where Profile.Gender = Female

Dec 30, 2007

Hello there,
I'm a new one to asp.net, so I need some help, and hope someone out there wanna take the time to help me, with my problem..
I had set up a Custom "Membership", you know click on a file, and it create a database ASPNETDB...
There I need to find 5 random users where they are e.g. females..
Right now I can find 5 random users, but I dont know how to put in there Where statement, because I need to read something from thier profile?

This is my code so far: SELECT TOP 5 [UserName] FROM [aspnet_Users] ORDER BY NEWID() 

Then I have to put in WHERE (profile.Gender = female)
<--- But how do I do that?

Hope you wanna, and can help me,
Regards Jeppe Richardt

PS,
Im using the language vb.net

View 6 Replies


ADVERTISEMENT

SQL 2012 :: Find Profile Name In Stored Mail Profile That Already Exists

Jan 22, 2015

We have a previous SQL 2012 cluster that emails us when a new database is added. I am unable to figure out why we get this error any time we add a new database to it, and also it prevents us from adding a new availability group to this cluster because of this error.

I also am unable to figure out what profile it is talking about as this was setup before me and I am not a DBA.

View 9 Replies View Related

Help! I Need To Find Users W/ The Same &#39;Type&#39;

May 30, 2001

We are evaluating users. We need to isolate certain users and certain groups. I can not figure out how to use a stored procedure or a script to filter a list of ALL users with the same 'Type'. Does this make sense? Any advice would be appreciated. I am on a deadline here and i could use any input u might offer. I can always TYPE them in using the EM - Security - Login, but I thought that there might be an easier way to do it.
Thanks! Billy

View 4 Replies View Related

How To Find Out List Of Users

Aug 4, 2015

Also , is it true that Grants to service accounts should go through roles as it is against audit & compliance standards? If yes, than how to find out the list of users who has direct grant to a service account ?

- Then how to revoke this grant from service account and than how to grant through the role ?
- Is there a script that i can run and find the list of users in each SQL server instance ?

View 0 Replies View Related

Gender Of Names

Jul 18, 2006

Does anyone know of a way to identify the gender of a person's name in a table? I have found an application that does it but I have to export it and use another program to analyze the data and then importing it back into SQL. We have a table that has a list of customers names that we use to market and we need this tool to analzye the customers by gender.

Thank you in advance for your help.

View 3 Replies View Related

Where To Find The The Allowed Users Of SQL2000

Aug 24, 2005

Hi all, I am brandnew with SQL2000, so sorry in advance forstupidities....SQL2000, SP3, running on a SBS2003-server with WindowsSharePointServices.I want to make a dataconnection (from within the LAN with InfoPath) froma client to this server. I got the error that whether the server doesnotexists (it does) or no permission. Where can I find (in SQL2000) whichusers have access to the databases ???Help is appreciated, Ger.*** Sent via Developersdex http://www.developersdex.com ***

View 2 Replies View Related

Searching And Finding The Information Users Really Want To Find

Dec 26, 2005

Hi,
Imagine that I have a select something like this
select * from T where T.Name Like '%Maria%'
"Maria" would be what the user what to find. But for example in spanish we use í, ó, ú, ü... The same happens in french, german...
The user want to find Maria and does not care if another user (or himself) has inserted the client as Maria, María, Marïa or whatever.
Of course one solution is putting in the DB only the simple characters (a,e,i,o,u) and look for  these, replacing the "strange" chars  in the application to the "normal" ones. But if we want to be professionals we would need to insert in the DB the name in their original spelling (the image is the most important!)
Any idea, help or reference?
Thx in advance and happy new year.
David

View 2 Replies View Related

Cant Seem To Find IUSR_MachineName In Users Using SQLEXPRESS 2005

Feb 4, 2006

Hello,I have an ASP web app with an SQL back end. I am currently migrating to anew Windows 2003 Server machine and SQL Server 2005 Express. When I importthe old database, I'm trying to grant the IUSR_MachineName account access tothe database, but I can't seem to find that user account. I'm clicking newusers, and when I type this user in, SQL doesn't recognize it, and when Iclick "Browse" all I see is BUILTIN/Administrators, BUILTIN/Users NTAuthority/System SA (which is not in use) and a long name that includes alot of dollar signs, the machine name and SQL express in it (it's a bigcryptic looking thing). Any idea how I get this to work again?Thanks!

View 2 Replies View Related

Retriving Gender From Database In A Radio Button

Mar 10, 2006

i am storing gender in the database.i want to retrive it in one of the radiobuttons for male and female already present on the form . how can i?

View 1 Replies View Related

DB Design :: How To Format Bit Data Type For Gender Field

Jun 23, 2013

I'm designing a database that stores personal details of students and teachers for a school. I, wish to know if a there is away of formatting the bit data type to male/female. Cause i am only able to achieve 0 and 1 in this data type. So is there any way to change it, or is there any other data type suitable to provide only two options Also the database should be protected in a way that students may not be able to view or change. Only teachers/admin have the right to access/modify the data.

View 6 Replies View Related

Returning Random Records And NOT Similar (random Questions)

Jul 20, 2005

Hi,I need to extract randomly 5 records from the table "Questions". Now I useSELECT TOP 5 FROM Questions ORDERBY NEWID()And it works. The problem is that I need an additional thing: if SQLextracts record with ID=4, then it should not extract record with ID=9,because they are similar. I mean, I'd like something to tell SQL that if itextracts some questions, then it SHOULD NOT extract other ones.How can I do it?Thanks!Luke

View 1 Replies View Related

SQL Server 2012 :: Conditional Logic Function To Return VARCHAR Value With Gender

May 4, 2015

I'm trying to convert the query immediately below into a function with the conditional logic to return a VARCHAR value with the gender: male, female or unknown.

SELECT empid, firstname, lastname, titleofcourtesy,
CASE
WHEN titleofcourtesy IN('Ms.', 'Mrs.') THEN 'Female'
WHEN titleofcourtesy = 'Mr.' THEN 'Male'
ELSE 'Unknown'
END AS gender
FROM HR.Employees;
GO

Below is the conditional logic function I'm trying to create to replicate the logic above.

CREATE FUNCTION dbo.Gender
(
@male AS VARCHAR(10),
@female AS VARCHAR(10),
@unknown AS VARCHAR(10)
)
RETURNS VARCHAR(10)

[Code] .....

View 6 Replies View Related

URGENT - Random 10 From Random 20 (2 Tbls)

Oct 14, 2004

I'm using ASP and SQL Serv 2000. What I need to get from 2 tables (company & customers) is random 10 customers from random 20 comp.
Anyone got an idea how to do this??? I've spent 2 days trying to get stored proc. or T-SQL to work, but nothing good came out of it. I can get 1 comp and 10 cust, but not a grouped list of 20 comp. w/ 10 cust. each.

Help is greatly appreciated.

View 1 Replies View Related

Reporting Services :: Adding (new) Child Domain Users To SSRS As System Users?

Jul 28, 2015

We have an existing SSRS server, and have just created a new child domain. We'll be migrating users from the parent to the child, and want to add the users of that new domain with access to SSRS. In the parent domain they are able to access, but after migration with the child domain account, they cannot.

I have added the group CHILDDomain Users with a system user role on SSRS, and PARENTDomain Users was already there.

Is there any additional step I should/could take to get this active?

View 5 Replies View Related

Why Out Of The Blue Would VPN Users Be Unable To Connect To Database And Local Users Are Unaffected?

Mar 6, 2008

I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!

View 6 Replies View Related

SQL Security :: Did Not Create Any New Users And There Are No Other Users Listed In Accounts Section

Sep 28, 2015

I am trying to revert back to Windows 7 after upgrading to Windows 10, however it will not let me and the following message occurs: "Remove new accounts.Before you can go back to a previous version of Windows, you'll need to remove any user accounts you added after the most recent upgrade. The accounts need to be completely removed, including their profiles.You created one account (NT SERVICEMSSQLSERVER) Go to Settings> Accounts> Other users to remove these accounts and then try again".However I did not create any new users and there are no other users listed in the Accounts section.

View 2 Replies View Related

Sql Profile

Apr 3, 2000

Hi,
This is Raj..could anyone pls explain the sql profile and how we will set the row-level locks as a dba.Sorry it is a silly question but sometimes these questions are bugging my mind.
Thnak u in advance.

--Raj

View 1 Replies View Related

Stored Procedure To Get All Users Or All Users Of A Specific Country

Apr 30, 2008

hi alli've got two tables called "webusers" (id, name, fk_country) and "countries" (id, name)
at the meantime, i've a search-page where i can fill a form to search users. in the dropdown to select the country i included an option which is called "all countries".
now the problem is: how can i make a stored procedure that makes a restriction to the fk_country depending on the submitted fk_country parameter?it should be something like
SELECT * FROM webusers(if @fk_country > 0, which is the value for "all countries"){    WHERE fk_country = @fk_country}
who has an idea how to solve this problem?

View 9 Replies View Related

SELECT - Profile

Feb 17, 2007

I use the default database called "ASPNETDB.mdf" that is automatically created in Visual Studio Express 2005....
There is an table called "aspnet_Profile" that holds the profile-properties, UserID etc.
There is also another table called "aspnet_Users" that holds all usernames, UserID etc...
No to my problem:
I have a SqlDataSource-control and want to select all users that have the property profile.Color = "Blue"....
How can I write the SQL-part for that?  

View 2 Replies View Related

Profile GUID

Apr 13, 2007

I am using a SqlDatasource and need to set a SelectParamter to the ProviderUserKey (The GUID of the user when Profiles are enabled)
 Can anyone tell me whether it is possible and How?
I am currently using the session state to store it in and then using the session=... to get the value into the parameter.
Is there a direct way of passing this value into a SelectParameter when using a SqlDataSource?
Thanks in advance.

View 3 Replies View Related

SQL Mail Profile

May 27, 2001

Hi,
Is it necesarry that to run SQL Mail, you need MS Exchange Server as the mail server? Our mail server is MDaemon 2.8. Can anyone tell me what would be the mail profile for MDaemon?
TIA
Wilson

View 1 Replies View Related

MS SQL Profile Issue

Sep 16, 2003

I am using MS SQL 2000 profile function to monitor the a report process. (VB + Crystal+MS SQL)

I notice there are some actions named
as "object created "
what does it mean ?

View 3 Replies View Related

ASP.NET Profile Parameter In T-SQL

Feb 3, 2008

Hi

Is there any way that I can use an ASP.NET profile variable in a T-SQL parameter?
I need to base a query on the current ASP.NET profile variable for purposes of creating a report.
Thanks
Deon

View 3 Replies View Related

Difference Between Database -- &&> Users And Security --&&> Users

Nov 28, 2006

Hi Team,

In SQL Enterprise Manager, when we expand "Database -->Users", we see the

users there. When we expand "Security --> logins" we see the same users there.

Can you differentiate these two.

Thanks

Santhosh

View 1 Replies View Related

Profile, SQLDataSource And GridView

May 11, 2007

Hello.When I create a user at the ASP.NET database, I need to insert more fields than the defaults, and I do it like this:         Dim customProfile As ProfileCommon = ProfileCommon.Create(CreateUserWizard1.UserName, True)              
customProfile.telephone =
(CType(CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("TelephoneText"),
TextBox)).Text(telephone example)Those data are inserted at the DB at the aspnet_Profile table, in the fields PropertyNames & PropertyValuesString, but they are saved together (see image above)

I want to separate those properties in the GridView as long as each property appears in a column, is it possible? Thank you very much, i'm expecting your answers.

View 11 Replies View Related

Does The Profile Provider Uses Cache?

Feb 3, 2008

Hi,
I use the Table Profile Provider: http://www.asp.net/downloads/sandbox/table-profile-provider-samples/ 
When I call for example: Profile.FirstName does this access the DB every time this call appears in my code?
Or all the profile is loaded to the cache when the user first loggs on?
thanks

View 4 Replies View Related

Change Profile Field Name

May 28, 2008

 I had a profile element named "Country", however, I want it to be named "CountryId". I can change this in the web.config with no problems, but then I need to update the code manually any place Profile.Country is referenced. Also, it seems I would have to write some SQL to update all the values in the profile table from Country to CountryId. Is there an easier way to do this? I'm using Visual Studio 2005 and SQL Server Express 2005.Thanks,Wes 

View 5 Replies View Related

Profile / Stored Procedure

Feb 25, 2004

Hi,

I have created a Stored Procedure, under Stored procedures section under Enterprise Manager on SQL server 2000.

Could anybody tell me, how and what are the steps to follow to TRACE the procedure , using SQL PROFILER ?

Please advice me !

Nicol

View 5 Replies View Related

Profile Value + Sql Value, A Login Problem

Apr 11, 2006

Hi all.  Quick question.  I'm using VS2005, C#, aspx page.I'm creating a Profile to store login and password.  That part is working...  I can call the values (and display them) using this code  <%= Profile.login %> and <%=Profile.password %>Now I want to create a Grid View that will connect to the SQL db, see if the login and password value stored in the Profile match that of ones in the SQL db.  So if the profile is login: bob password: dog, the grid view will output all application ID numbers associated with the bob and dog.  Here is the SQL code...trying to use the <%=Profile.login %> as a filter on the login and password doesn't seem to work...Can anyone tell me what I'm doing wrong?  How can I reference a value in the Profile within an SQL statement?SELECT     ApplicationStatus.Description, Customer.CustomerName, Application.ApplicationDateFROM         Application INNER JOIN                      ApplicationStatus ON Application.ApplicationStatusID = ApplicationStatus.ApplicationStatusID INNER JOIN                      Customer ON Application.ApplicationID = Customer.ApplicationID INNER JOIN                      [User] ON Application.DealerId = [User].UserIdWHERE     ([User].LoginId = '<%= Profile.login %>') AND ([User].LoginPwd = '<%= Profile.password %>') AND (ApplicationStatus.Description = 'Pending')

View 2 Replies View Related

Using A Profile Object In A Query

Apr 24, 2006

I have created a profile object which is a list to store photoId into an array. (kinda like a shopping cart) which will persist in the list untill manually deleted by the user.I want to use the photo Ids stored in this object in my profile as a parameter for an sql select statement to be displayed into a data grid. What is the best way to go about this... and suggestions... I know you can use a profile property as a parametere in a sqldatasource but Im not sure how to do this for an array.HELP

View 1 Replies View Related

SQLMail, MAPI Profile

Aug 7, 2000

I created a new MAPI profile on the server, and it seems to work fine with Outlook. I also dropped the previous default MAPI profile.

Now, when I go to the EM SQLAgent Properties, the only MAP profile offered in the SQLMail drop-down is the old, deleted profile. Also, only the old profile comes up with xp_get_MAPI_profiles.

How can I get SQLAgent to recognize that I've set up a new mail profile?

View 1 Replies View Related

Create Profile Sql2000

May 2, 2008

how to create profile use mail in sql2000

View 1 Replies View Related

Set Statistics Profile On Into Table

Jul 23, 2014

How can I insert the results of "set statistics profile on" into a table?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved