Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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