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 Rhinorhino 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: *

  1. esilva002

    Create XML File From SQL Table

    hey hey hey! I used code that tsuji supplied me but it gives me an xml file that looks like this(I also supply the code below): <?xml version="1.0" encoding="windows-1252"?> <Root> <ListPreDef> <bm TYPE="1" COLOR="-1"> <DockNo>675303</DockNo> <Judge>Judge</Judge> <Plaintiff>TUCKER, DAVID P JR...
  2. esilva002

    Copy files from CD-ROM to Hard Drive

    GREAT!!! It works perfectly!! You guys rock thanks for the support!
  3. esilva002

    Create XML File From SQL Table

    I still don't know how to take it from a record to an actual file, but I also have another problem where my XML Header tag is missing. <?xml version="1.0" encoding="windows-1252"?>
  4. esilva002

    Copy files from CD-ROM to Hard Drive

    idk. My autorun file opens a flash projector file from there the flash projector file links to a .bat file that would either copy and paste the the access file itself or link to another setup.vbs file that would do the same. What are your thoughts?
  5. esilva002

    Copy files from CD-ROM to Hard Drive

    Hello, I have an access database and ico on a CD. I want to run a script on load (using autorun.inf - that's no big deal) to copy files from the CD to a folder on the C: drive. Once I copy the file I will make a short cut to the desktop to that file. Now the only problem I am having is that my...
  6. esilva002

    Create XML File From SQL Table

    Ok I took the supplied information and came up with this in a stored procedure: SET NOCOUNT ON; DECLARE @FileName varchar(50), @bcpCommand varchar(2000) SET @FileName = '\\primary\Rockftp\Judge1.xml' SET @bcpCommand = 'select(select 1 ''@TYPE'', -1 ''@COLOR'', * from tblBIS_ExportJudge1 for...
  7. esilva002

    Create XML File From SQL Table

    Works Great Thanks A Lot!!! but how would I go about taking that record and saving it to a file on my server?
  8. esilva002

    Create XML File From SQL Table

    Hello World! I have a bit of an issue I need my table in sql to be exported to an XML file. I have an example of the XML file and created my table to look like the file. Here is what my final XML is supposed to look like: <?xml version="1.0" encoding="windows-1252"?> <Root> <ListPreDef> <bm...
  9. esilva002

    Selecting max(date) from view

    I'm still receiving the record 00CV000773 with the TermActionCodeID of X. Should the line below be changed? ROW_NUMBER() OVER(PARTITION BY CaseNumber1 ORDER BY TermDate DESC) AS rn What exactly does the PARTITION BY statement actually do? I think I might need to partition it with one more...
  10. esilva002

    Selecting max(date) from view

    Do you want to show only one row for each CaseNumber1? --- I want to show the last CaseNumber based on the TermDate The row that is shown should be the one with the most recent TermDate, right? --Yes Is is possible to have the same CaseNumber1 with the same date? --No What version of SQL...
  11. esilva002

    Selecting max(date) from view

    I have a View with the following code: SELECT ID, CaseNumber1, DateFiled, OpenActionCode, JudgeNumber, TermDate, TermActionCodeID, ReOpenedCase, VisitJudge, CaseTypeNumber, SubmittedDate, RulingDate, PreviousFileDate, Note, CDatefiled, CTermdate, CSubmittedDate, CRulingDate FROM tblSupremeCourt...
  12. esilva002

    Replace Wild Card Characters

    They are found with in a varchar(max) field! So I cant just update the column because other paragraphs of text are in there too.
  13. esilva002

    Replace Wild Card Characters

    Hello, perhaps you guys have heard this before in the past, but here is what I'm looking for. I have a SQL 2005 table with Social security numbers. We need to get rid of the SSN numbers and replace them with SPLAT (*) For example: if the real SSN is: 340-53-7098 the repacement would be...
  14. esilva002

    Copy files and folders of directory to another folder

    The Error happens on line "FSO.CopyFolder CopyFolder1 , PasteFolder1 , OverWriteFiles" and most likely on the next line too
  15. esilva002

    Copy files and folders of directory to another folder

    I have a DailyBackup.vbs file that selects two drives and then copies the contents to their own folder for backup purposes. It looks like this: Option Explicit Dim FSO, StrDate, StrMonth, StrDay, StrYear, StrBackupFolder1, StrBackupFolder2, CopyFolder1, CopyFolder2, PasteFolder1, PasteFolder2...

Part and Inventory Search

Back
Top