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

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

    selecting data where it does or does not appear in a table

    Having a stupid moment that I hope someone can help me with. I have a number of tables to pull some data from, two tables in particular, one has an ID that may or may not appear in table 2, the tables are linked via a join where a.con_id = b.Con_id. How do or I set up my join to pull back data...
  2. jeffwest21

    Two groups totalling

    I have a report that basically looks like this Line 1 Date Day of the week 1 (should be 2) Line 2 Group Campaign 1 1 Line 3 All Regions 1 Line 4 Detail Row Region1 0 Line 5 Detail Row Region2 1 Line 6 Detail Row Region3 0 Line 7 Group Campaign 2 1 Line 8 All Regions 1 Line 9...
  3. jeffwest21

    Connect to more than 1 sftp

    I am trying to set up a system to pull data from more than 1 sftp site at timed intervals during the day. I have found a piece of work that someone else did that does it from one, but I need to as I say from a second as well. The code I have in the app config is this. <appSettings>...
  4. jeffwest21

    Create MVC Questionairre

    I am new to MVC and EF, I have followed a few pluralsight videos about implementation of MVC and EF, and want to create a Questionairre for staff to fill in, can anyone recommend a good online tutorial to achieve this. I have a basic concept of what I want to achieve, but am having a few issues...
  5. jeffwest21

    Combo Box populating a text box after update

    Please excuse me if this is elsewhere but I can't seem to find it. I am trying to build a C# windows application form I have a combo box that is populated from a SQL database, which after the user updates the combo box, it adds an email address into a hidden filed on my form that will get...
  6. jeffwest21

    Stored proc not creating temp table

    I have a stored proc that when I run the code on it's own create table #Campaign_Hours ( Dateperiod varchar(20), USerID varchar(20), total_dialler_secs int, logged_on_time_secs int, busy_secs int, notready_secs int, preview_secs int, ready_secs int, wrapup_secs int, waittime_secs int...
  7. jeffwest21

    Chart Headings from Field

    I have a bar chart, where what will be on it will differ each time the report is run, what I want to do is name the elements dynamically from a field on the report, I have tried adding an alias to the query, noting the form filed I want to use, but this just errors with...
  8. jeffwest21

    Export to sequential folders

    I have to create an export everyday for a client, I then need to upload that data onto a sftp. The issue I have is the client want the folder to be named Run001, Run002 etc I know how to create a dated folder, but how do I create a folder with a sequential number in the format above?? Any...
  9. jeffwest21

    Batch file not quite running right.

    I have the following in a batch file @echo on setlocal set LogPath=\\Bridata\user drives\JeffWset LogFileExt=.log set LogFileName=Daily Backup%LogFileExt% ::use set MyLogFile=%date:~4% instead to remove the day of the week set MyLogFile=%date% set MyLogFile=%MyLogFile:/=-% set...
  10. jeffwest21

    Query bring back multiple values I only want one

    I have the following code in a query SELECT Distinct p.ID,p.Forename, p.Surname,p.[Event Code],convert(varchar(10),[Event Date],103) AS Event_Date,convert(varchar(10),c.[Contact Date],103) as Contact_Date, convert(varchar(10),c.[Callback date],103) AS Callback_Date,p.[Date of...
  11. jeffwest21

    Checking dates is more than 14 before

    Copuld really do with some help with this. I have been taked with changing someone els's code (never a good thing) and I am stuck Below is a pice of code that checks if a date is more than 9 months ahead if(checkDD.value.length > 0){ var d = new Date(); maxDD =...
  12. jeffwest21

    Not always printing data on a report

    I have a series of forms that after a user has entered some data, on submit also prints out a report, there are times when the report doesn't always print out the data (text fields and bar chart) it just comes out blank. I am using this in my vba code DoCmd.OpenReport...
  13. jeffwest21

    BCP Out file with double quotes

    I am trying to output a table using BCP in a stored procedure, problem i am having is that I don't get a double quote at the start of the file, and get one on the last line in the file, like below 00008373","30/09/2013 16:31","30/09/2013 16:31 " This is what I am using to bcp select @sql =...
  14. jeffwest21

    Batch File Find the latest file in a series of folders

    I have the followin g code in a batch file @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION SET "FFPath= \\server\ROI\" SET "NewPath= \\server\ROI\" REM Arbitrary yyymmdd starting point, nothing will be older than it SET NewestDate=20130101 ECHO Recursively searching %FFPath% echo. FOR /F...
  15. jeffwest21

    No Double Quote at start of BCP'd file

    I have an export that is ouputtying some data from SQL using bcp, I need to add quotes around it but everytime it output i miss a double quote at the start and get and extra one at the end. I am using this select @sql = 'bcp "select * from Database.dbo.table " queryout '+ @file +' /c -t...
  16. jeffwest21

    Rename file from stored procedure

    I have a series of files that I am importing into my database, this I can do no problem, my issue is with moving the files afterwards. I want to move them into a \done\todaysdate folder, again, I can create the folder and three of the four files move into my folder, the fourth doesn't, I am...
  17. jeffwest21

    Bulk Insert four different files into Four tables

    I have 4 files that are dumped automatically off a sftp site, three of the files have specific file names that do not change, however the 4th one does change as it is prefixed with the date of creation i.e. FileName-exp-2013-09-24.csv. My bulk insert statement reads thus BULK INSERT CDR FROM...
  18. jeffwest21

    BCP out without headers

    I need to create an export from my SQL 2005 database, i have the following DECLARE @bcpCommand VARCHAR(8000) SET @bcpCommand = 'bcp " SELECT * from ##TempExportData2" queryout' SET @bcpCommand = @bcpCommand + ' ' + @fullFileName + ' -c -T -t"\",\"" -r"\"\n\"" -Usa -Psa ' EXEC...
  19. jeffwest21

    Adding a group to a table

    Ok, having a dumb moment and I can't seem to find a consise answer anywhere so hope someone can help. I have a table which has a result, total and % field Pass 1 50% Fail 1 50% What I want to do is add a group under the Rass/fail to show the detail of the score (will be about 8 - 10 fields)...
  20. jeffwest21

    Send a form field to a report

    Trying to send the value from a form field to a report DoCmd.OpenReport "Agent_Report_BR_Com", acViewReport, , "Mon_ID = " & Me.ID.Value Mon_ID is the field on my report, me.ID.Value is the field on the form. It picks up the data from the form but doesn't seem to send it to the report so...

Part and Inventory Search

Back
Top