Forum Replies Created
Viewing 15 posts - 1 through 15 (of 112 total)
-
RE: Changing SQL Code/VBA
If there was one, of course, although I feel the error was of my doing in the first place. It was due to the version of Office I was using...
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Changing SQL Code/VBA
problem solved, no problem. End.
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Changing SQL Code/VBA
The exact error is :
run-time error 1004
General ODBC Error
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Randomly selecting rows from a table
cheers Frank.
Still leaves me with the same problem really I think.
Table of thousands of people, male/female of two different age groups.
need a random sample of 75 male/75 female....
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Randomly selecting rows from a table
Great! I have the following code. there is also an age field included which I want to use to split the results of the following query, i.e. 35 out of...
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Randomly selecting rows from a table
Nice one, NEWID() seems to work fine. Do I need to pass any values into NEWID(x)?
Seems to work fine without though......
Cheers
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Randomly selecting rows from a table
cheers frank, much appreciated.....
.....would NEWID() work for this kind of thing? do yu have any examples of this in action?
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Changing Owern ship of tables
panic over, I have used sp_changeobjectowner
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Changing Ownership of tables
panic over, I have used sp_changeobjectowner
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Learning a database
as i thought, just needed reasurrance
. thanks graeme
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: VBA and VB differences
Thanks guys.
Have been away...but watch this space Frank!
Will search on MS......
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Help new to TSQL
Sorry for all the followups,
is your solution by any chance related to dijkstras algorithm? or is that somethin different?
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Help new to TSQL
could you also explain the line
GID int IDENTITY
What does GID stand for / relate to?
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Help new to TSQL
Just to make certain, are there any alternatives that would be worth thinking about?
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive! -
RE: Help new to TSQL
Thanks for that wayne, very helpful indeed, appreciate it
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
Viewing 15 posts - 1 through 15 (of 112 total)