473,386 Members | 1,819 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Clarification about newid() function

I have a table tblEmails which contains a list of email ids.

ID,address_id,list_name is the structure of it. I need to create a sub
list for a particular list_name say "Google Customers" , then say my
sublist "Random Internal Google customers" should contain 1000
address_ids from "Google Customes" when I create a new sublist say
"Random Internal Google Customer 2"
I want 1000 address_ids which are not present in the first. Basically
I need to create n sublists which do not have any common address_ids.

I used newid() random function for this. but I find a couple of common
values.
Jul 20 '05 #1
0 1357

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Tech | last post by:
I have a table tblEmails which contains a list of email ids. ID,address_id,list_name is the structure of it. I need to create a sub list for a particular list_name say "Google Customers" , then...
1
by: A Rothberg | last post by:
Is it possible to use NEWID() as a parameter to a stored procedure in SQL Server 2000. I keep getting a "Line 1: Incorrect syntax near ')'" error. ALTER PROCEDURE dbo.StoredProcedure1 ( @x...
3
by: ma740988 | last post by:
Consider the 'C' source. void myDoorBellISR(starLinkDevice *slDevice, U32 doorBellVal) { doorBellDetected = doorBellVal; } void slRcv() { starLinkOpenStruct myOpenStruct;
4
by: chanchito_cojones | last post by:
Hi there, I was searching the net for some guidance in putting together a query that would select random records from the main table. I came across this and it works like a charm. SELECT TOP...
1
by: Eugene Anthony | last post by:
Is there a limitation of using: set @sessionID = NEWID() would there be a simular NEWID() being generated if used in a database application. Eugene Anthony *** Sent via Developersdex...
2
by: mr.Hyde | last post by:
Hi, I am working with mscrm database. the Accounts has UniqueIdentifierID, so I am trying to use as parameter value in sqlcommand "NewId();", it doesnt works becouse, ExecuteNonQuery pass my...
9
by: wizwx | last post by:
what does the following mean? int func2(); According to C++, it surely means func2 is a function that takes no argument and returns an integer. But what about in C? Does it have the same...
3
by: Cindy | last post by:
I'm trying to use the NEWID function in dynamic SQL and get an error message Incorrect syntax near the keyword 'ORDER'. Looks like I can't do an insert with an Order by clause. Here's the code:...
1
sujathaeeshan
by: sujathaeeshan | last post by:
Hi all, Newid() which creates a unique value of type uniqueidentifier. Is there any possibolities for seeding or incrementing the NEWID() value. For example: create table cust(cust_id...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.