Search:

"Hmm. Caveat emptor and all that. Although this might fall foul of advertising standards, it's not a fraud. When all is said and done they offered you an item at a price of $25 and you accepted their...

I know we had to install the product and it is a lot more than the dll. The person that knows the most about it is not available right now. I'll try and get back with you. I can tell by IDE that...

We run SOAP from VB 6.0 on Windows 7 calling a web service and it seems OK. I really don't know all that much about it. I can provide you specifics about how it is called if that would help. Are...

Specific rant - not replying to anyone in particular:

Anyone following news of JC Penny over the last couple of years should be aware of how they crashed and burned on their new marketing approach...

Wrong forum...you want Silk Road.

I've been an application programmer my entire career but always had to interact with databases and for the most part in development did the work myself. Something that helps to keep in mind for...

That depends on what version you have. 2000 had it, 2005 didn't, I think it's back with 2008. Later versions of Visual Studio have it (2005+ I think). Last time I checked you needed SA access to...

Byob

edit

The save is changing "BYOB" to Byob.

The thing about temporary tables starting with # is they will delete automatically when the SPROC is done running. Most people have clean up steps just to be sure. If your tables are small look...

Just for grins, if it is not proprietary, could you post the code? I can't look at it until tomorrow though.

I don't see where morality comes into it. At the same place I bought my gun I could have bought a fully automatic Thompson .45 "tommy gun" with a 100 round drum. Some people drive a Focus and some...

Gotcha...you may even have been in the thread where that came up in the last few days. I'm striking out all over the place today (been at work since 3:00 AM EST).

pseudo code:

1) Create a...

That won't work, multiple GOs, in a stored procedure though.

"You are only creating a temporary table"...I hate to be so pedantic but these are not temporary tables except in the sense they aren't around that long to you :)

I makes sense the compiler does...

Could some kind of constraint be added to make a duplicate fail?

You could tighten up the set with:

with (updlock)

Here is an example from something set up here.

set @pkClaim = isnull((select max(pkClaim) from Claim with (updlock)),0) + 1

Yes magazine...the purists hate people like me calling them clips. It just depends on what you buy. I have some 30 round "mags" for my 1911 model Colt .45. It looks silly as hell but probably not...

Welcome to the party....

Are you really using temporary tables or are you using tables temporarily? What I'm wondering is when you are dropping the tables if some kind of transaction logging is getting in the way.

To me...

I bought a Taurus PT 92 Para 9 mm last night. No waiting period...just walked in, bought it, walked out with it. I did have to pass the background check though.

17 in the clip and one in the...

I may be missing the point but you mean something like:

select getdate() 'current date'


and the column name would be 'Current date'

I guess Mary Jane is just to plain now a days...

Then I'm exicited for you :wave:

I had to add this site to safe email for the first time since I joined (post replies were going to junk). I don't know if it has to do with the upgrade or not.

Gotcha...I was half kidding.

"I'm surprised to hear that you both didn't think the GO would work"

We said in the middle of stored procedures not just straight SQL like:

select getdate()
go
select getdate()
go
select...

There is a lot of truth to that and that was my point about my "youth of today" post. But...we aren't publicly burning witches anymore. That's a plus :)

If you just forgot about batches and ran:

DO SOMETHING WITH TABLE 1
DO SOMETHING WITH TABLE 2
DO SOMETHING WITH TABLE 3

And something went wrong in TABLE3 the first two would not roll back or...

All that being said someone must be teaching it somewhere like it is current...it keeps popping up here as homework and such.

Then I'm confused about what I read (below from the link I posted)...or maybe it is just an accumulation of ticks versus storing a tick.

System time is measured by a system clock, which is...

Sorry...I didn't look close enough. I don't know Access.

I'm curious also. I found this:

http://support.microsoft.com/kb/555266

But I'm not curious enough to test it :)

Just recently someone posted about the system time being in ticks which was new to me. I knew about some software picking a point in time to "start the clock". For example, but not acurate...

Oh yeah...

If Jesus and Thor got into a fight who would win?

Hello back...The coding forums here offer a lot of knowledge also :D

You might be interested in this link:

http://en.wikipedia.org/wiki/Perpetual_calendar

Ahh the good old days...where did they go?

“The children now love luxury; they have bad manners, contempt for authority; they show disrespect for elders and love chatter in place of exercise....

As long as we are at it why in the world don't we all start speaking the same language? That would simplify things also. What year is it for the Chinese right now anyway :confused:

Which line is causing the error?