Viewing 15 posts - 36,601 through 36,615 (of 39,717 total)
I favor the filesystem, but that's me. Andy has good arguments in another thread (http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4169&FORUM_ID=9&CAT_ID=1&Topic_Title=Images:%20Store%20in%20SQL2000%20or%20on%20File%20Directory?&Forum_Title=General) on this.
Steve Jones
January 10, 2003 at 10:35 am
use a left outer join
select *
from affiliate a
left outer join template t
on a.affiliateid = t.affiliateid
Steve Jones
January 9, 2003 at 2:48 pm
Are these employees? Authenticated (to NT) users? If they are, you need to buy 1 SQL Server License and 15 CALs. Middle Tiers don't count.
If they are Internet or unauthenticated...
January 9, 2003 at 1:02 pm
I'm not sure I agree with all the choices made either, but it was nicely written and it appears that it works well for you to solve the problem.
I worked...
January 9, 2003 at 1:00 pm
You can also return quarters with Datepart. Scorpian has good advice.
Steve Jones
January 8, 2003 at 8:14 pm
There are a few tricks. One is to set the package to connect to (local), which will be the default instance.
another is to use the Dynamic Properties task to query...
January 8, 2003 at 12:56 pm
I've tried different products, ErWIN, ER/studio, Total SQL Analyzer, none of them work well.
In general, the target for internal apps moves too fast to properly document. Well perhaps not, but...
January 8, 2003 at 9:51 am
We are starting to deploy the GSX internally at JD Edwards. Not sure if we have the metrics, but I will check.
AFAIK, the ESX runs better by allowing you...
January 8, 2003 at 9:45 am
hint:
use xp_cmdshell and ren
Build the command string using the datepart functions.
Steve Jones
January 7, 2003 at 1:48 pm
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
Viewing 15 posts - 36,601 through 36,615 (of 39,717 total)