Search results for query: *

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...

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

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"?>

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?

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...

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...

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

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...

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...

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...

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...

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.

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...

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

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...