Viewing 9 posts - 1 through 9 (of 9 total)
Lamprey13 (8/9/2011)
Not the most effecient, but I think might work for what you are trying to do. If not, check out what Gail posted, so we can help you better:
Thank...
August 9, 2011 at 12:36 pm
GilaMonster (8/9/2011)
And some sample data for the two please (garbage data is fine, not asking for anything confidential)/ Also a bit better description of what you want to happen.
rnd_street:
IDstreet_name
93 Lincoln...
August 9, 2011 at 8:42 am
I'm sorry - that was in response to an earlier post -- the structures are:
CREATE TABLE [dbo].[RND_Street](
[ID] [int] IDENTITY(1,1) NOT NULL,
[street_name] [varchar](40) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[RND_Customer_Master](
[Customer_Id] [int] IDENTITY(695,1) NOT...
August 9, 2011 at 8:28 am
select ID, COUNT(*)
from RND_Street
group by ID
having COUNT(*) > 1
returns zero rows.
August 9, 2011 at 8:23 am
update the customer table with values from a set of street names with random addresses, without using a cursor & loop. I have tables with a unique identity column...
August 9, 2011 at 8:08 am
yes, the ID is an identity column w/unique values.
CREATE TABLE [dbo].[RND_Street](
[ID] [int] IDENTITY(1,1) NOT NULL,
[street_name] [varchar](40) NULL
) ON [PRIMARY]
August 9, 2011 at 8:00 am
i don't care about the randomness -- it's the multiple rows being returned that's the problem.
August 9, 2011 at 7:42 am
Hi,
The problem is getting multiple rows returned, not the random number generation. I've tried a couple of different randomization techniques, but continue to get 0, 1, or...
August 9, 2011 at 7:32 am
I'm sorry, i forgot to include the entire statement:
update RND_Customer_Master
set Address1 = (select convert(varchar(5),dbo.RandNumberInt(1, 100000)) + ' ' + street_name
...
August 9, 2011 at 7:22 am
Viewing 9 posts - 1 through 9 (of 9 total)