Viewing 15 posts - 36,796 through 36,810 (of 39,903 total)
I'd set the memid as the PK if that's what it is. We assign an "ID" to every member and use that to track your posts, breifcase, etc.
Steve Jones
January 7, 2003 at 1:43 pm
I'd first question whether you need to do it in one statement. Can cause an unnecessary load on your server. Do you really need an all or nothing delete?
I'd batch...
January 7, 2003 at 11:15 am
Not sure if you can get it in Access, but you can get @@scope_identity (select it) to get the last identity value you inserted.
Steve Jones
January 7, 2003 at 11:10 am
Short answer is you can't unless you control the administrative access to the server.
You can remove select from syscomments (and insert, update, etc), for public and general users, but the...
January 7, 2003 at 11:02 am
Are you looking for the data conversions? Can you give some examples of the COBOL datatypes?
I would look at DTS and using whatever drivers you have and then see how...
January 7, 2003 at 10:54 am
Thanks for those notes. I think we may do an e-book at some time if the print thing goes well. Understand both sides and perhaps we can work something out...
January 7, 2003 at 10:33 am
Oh, how I agree. That is annoying. I wish I could get the scripting engine to format differently as well. Don't have a solution other than a custom scripting tool....
January 6, 2003 at 10:17 pm
you are welcome.
it worked as I wrote becuase your WHERE clause was filtering out the tblrequired value.
Steve Jones
January 6, 2003 at 5:01 pm
The issue is your WHERE clause.
If I run a left outer join like this:
SELECT
StepID,PrequalID, RequiredPageDescription, RequiredPageURL , SectionNumber, StepNumber
FROM dbo.tblRequired
left outer JOIN dbo.tblStepStatus...
January 6, 2003 at 3:52 pm
Kind of off topic, but yes, you do want to do the joins in the join clause. I was shooting for a simple example, but in reality I'd probably have...
January 6, 2003 at 3:41 pm
Can you post some DDL? Not sure hwat you mean. Also perhaps a sample data set.
Steve Jones
January 6, 2003 at 2:07 pm
Can you post some DDL for the tables? I suspect what you want is a left outer join, but I'd need some code to be sure.
Steve Jones
January 6, 2003 at 1:24 pm
January 6, 2003 at 12:35 pm
Not sure of the issue. Could be your NIC requires the CPU (some do, some don't).
What's the replication scenario? Transaction? Merge? Push/pull?
Steve Jones
January 6, 2003 at 12:14 pm
We are thinking of doing this annually. Love to let you choose the articles, but the cost would be too high, well above $15.
Initially, this will be a US only...
January 6, 2003 at 11:37 am
Viewing 15 posts - 36,796 through 36,810 (of 39,903 total)