Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Jamfool
  • Content: Threads
  • Order by date
  1. Jamfool

    Undocumented quasi feature/quirk sql 2005

    Just found the following interesting, although its only semi useful because the formatting is lost when saved. Run something similar to the following in grid mode: select top 1 name from syscolumns for xml auto, elements you will then get the usual results window, which u can click on and...
  2. Jamfool

    SQL2005 Cluster Active-Active?

    is it possible to install this in an active-active cluster setup? and has anyone done it?..got notes info on it? general advice on 2k5 clustering?
  3. Jamfool

    Backup Script Help. Please

    Hi All Can someone confirm the following syntax/proceedure for me. I need to backup the entire contents of an oracle database, and then copy the files to a another directory in a linux environment. Assumptions: I need control file and all tablespaces backedup. 1. Check files I need...
  4. Jamfool

    most effective way, ranged join.

    case id of 1, has been oustanding for 15 days and therefore rate table B must apply a cost of 20. My question is what is the most effective and elegant way to return this rate without using: Create Table A ( CaseID int, mydate datetime ) go insert into a values (1,getdate()-15) go Create...
  5. Jamfool

    connection files

    I have a asp page that uses the following connection stored in a file called connection.asp. e.g i use <!--#include file="connection.asp"--> at the top of my main page and use below stored in connection.asp <% set cnn = server.createobject("ADODB.Connection") cnn.open "PROVIDER=SQLOLEDB;DATA...
  6. Jamfool

    Renumber problem.

    Create Table mytable ( AlphaNumericID varchar(10), renumber int ) insert into mytable values ('ZAA0062000',null) insert into mytable values ('AA00062000',null) insert into mytable values ('AA00062000',null) insert into mytable values ('AA00062000',null) insert into mytable values...
  7. Jamfool

    Security check

    Hi all. Please can someone provide me with the sql which checks if a user has access to read the object createdate from the sysobjects table in all the databases on the server. I presume they just need to have read access or greater on the database.
  8. Jamfool

    xp_fileexist encapsulated in a function.

    ok we have basically created a function which uses the existing undocumented xp_fileexist to check for a file but wrapped it in an existing function. e.g dbo.fnFileExists (filepath) which returns a bit The first time this runs it takes 4-6 seconds, but the second time it is almost...
  9. Jamfool

    SQL server Jobs

    Hi All Has anyone got a script to export all server jobs to individual files? so that they can be recreated later
  10. Jamfool

    Jobs List

    Hi All Ive been trying to get a list of the jobs and their details on various servers etc, and have trawled the net for bits and pieces to compile the below job script. Has anyone got a better one? or perhaps tips to improve this one? SELECT 'Job Type' = CASE server_id WHEN 0 THEN...
  11. Jamfool

    Pivot Data

    dt Requests 19/09/2004 10:00:04 10 20/09/2004 07:00:06 161548 21/09/2004 00:00:07 164190 21/09/2004 12:00:07 100000 21/09/2004 12:20:07 100000 19/09/2004 01:00:06 155289 Can someone help me pivot the date in this wait table. I need it in the following format: Sum requests as the...
  12. Jamfool

    Total beginner needing some help!!! - please!

    I am a complete beginner so please bear with me and any offers of advice and/or tips would be much appreciated! I have a list which has been inputted by the user. The numbers are any positive and negative integers and zero. I want to include a function where they can turn all the numbers in the...
  13. Jamfool

    Outlook 2003, VBA macro

    Program: Outlook 2003 Hi Instead of using the import/export wizard, has anyone got a macro (that I can then assign to a button) to export emails to a windows csv, and also import others from another csv?
  14. Jamfool

    Chart Problem Access2003

    ok I got a table ID,NAME 1,JO 2,BOB 3,JIM I select design a form, insert chart. select the table, select both fields. pick bar chart, i put 'name' in the axis box, and count of name in the data box. When I preview I see the correct graph...but when i finish and get the final graph... it...
  15. Jamfool

    outlook subject search in vba

    How do you go about doing this:- if i got several emails some with and somewithout 'urgent' somewhere in the message subject...how would i got about selecting these and addint a priority marker. if .subject like %urgent% then priority ...
  16. Jamfool

    reformatting incoming outlook mail (font..etc)

    If i get a variety of emails in I want to change it to a set format. In particular I want the emails to be rich text, which I got by using .BodyFormat = olFormatRichText However how do you set font and size? Can anyone give me a hand with this>? cheers (outlook 2002 btw)
  17. Jamfool

    array problem

    <?php require_once('Connections/jxpDREAM.php'); ?> <?php mysql_select_db($database_jxpDREAM, $jxpDREAM); $query_data_grab = "SELECT `data` FROM datadump"; $data_grab = mysql_query($query_data_grab, $jxpDREAM) or die(mysql_error()); while ($row = mysql_fetch_array($data_grab, MYSQL_BOTH)) {...
    • Jamfool
    • Thread
    • Replies: 2
    • Forum: PHP
  18. Jamfool

    Update linking back to the same table

    Ok basically I need to copy the details of a main client to a new sub client related to that client. so updating the address details of one Sub client (say with a code S1) with that of a Main client (M1) UPDATE User_file SET address1 =(SELECT Address1 FROM User_file WHERE (Code =...
  19. Jamfool

    Help reducing number of IF statements

    Basically if l1 is greater than the str_len then i need to take a part of the string and set str_len to 0. (Repeating this for several other fields) If it is less than str_len I want to take all the string and set str_len to str_len - l1. At the moment this is multiple IF statements. How do I...
  20. Jamfool

    Critical Replication failure

    The remote site has had a complete loss of data. The master database sql 2000 db is still intact. I need to get this going again,soon. Will diabling Microsoft replication on the main db, and then scripting it to a new db work? Or will there be loads of stuff to configure/remove/change? How...

Part and Inventory Search

Back
Top