Viewing 15 posts - 11,656 through 11,670 (of 14,953 total)
You can't use a sub-query that way in a "Values" statement. You either need to change to Insert...Select, or you need to assign the return value from the function...
January 12, 2009 at 11:21 am
I got a similar (may have been the same) error message at one point when the file was not on the same computer as it had been checked in from....
January 12, 2009 at 11:20 am
GilaMonster (1/12/2009)
mhaskins (1/12/2009)
January 12, 2009 at 11:17 am
As far as security goes, it can't get much worse than the laptop I took on my vacation last month. The carry-case had a sheet of paper on it...
January 12, 2009 at 11:15 am
Parse the statement (the description) into individual words, one word per row. You can parse on spaces, then separate punctuation marks into their own rows. (The scripts section...
January 12, 2009 at 10:55 am
I've used the WinZip command line interface to automate that kind of thing. It's very straight-forward, and the documentation is reasonably good. I haven't checked the cost recently,...
January 12, 2009 at 9:56 am
Is it possible that the database had to be rebuilt, or anything like that?
January 12, 2009 at 9:54 am
gcopeland (1/12/2009)
GSquared (1/12/2009)
Yes. That's exactly what I'm saying. George W Bush dresses well. By your logic, that means you assume he's a highly skilled computer programmer.
Let me...
January 12, 2009 at 9:53 am
I've never bothered with it. Maybe I should, but I never have.
I've found tracking runtime on queries to be much more useful to me in performance tuning.
January 12, 2009 at 9:20 am
It is possible to set a maximum timeout value for remote queries, at the server level, but that won't do what you're looking for. For that, it would need...
January 12, 2009 at 9:00 am
If the two indexes really provide exactly the same execution plan, then the optimizer just picks one. Probably the first one. All other things being equal, it has...
January 12, 2009 at 8:57 am
Different data in the tables
Data cached on one and not on the other
January 12, 2009 at 8:53 am
I'd go with a two-step upgrade. First to 2005, then to 2008. Unless the database is really, really simple, that should get the job done in the best...
January 12, 2009 at 8:51 am
gcopeland (1/9/2009)
January 12, 2009 at 7:46 am
gcopeland (1/9/2009)
GSquared (1/9/2009)
The way that Gates and Ballmer dress is considered socially appropriate for executives. It says nothing whatsoever about technical skill. You're concatenating two thoughts...
January 12, 2009 at 7:25 am
Viewing 15 posts - 11,656 through 11,670 (of 14,953 total)