moone009

First off this is my second day writing in Python. My manager switched us off SAS and moved us to Python and R which I actually am starting to like the flexibility. I have a few datasets that I work with on a regular basis that require a lot of …

This is my main page where the user can choose a category from a drop down. I need that category selection to update my session variable so I can then send that variable to another php page execute a query and return the result in my div because I do …

I would like split to some how split each item in the arry and sort it by Id[1] and then date[2] Been doing a fair amount of reading and cannot seem to figure this one out. Name,ID,Date John,432,2012-03-21 04:32:00 AM Bob,532,2012-01-01 12:12:00 AM Mike,932,2012-01-11 11:42:00 AM Mike,932,2012-05-01 12:13:00 AM John,1532,2012-01-11 …

I am brand new to web development just moved over from the database side and I am having a bear of a time trying to remove clusters in google maps. I've probably spent roughly 12 hours trying to research what is going on. Attached is my code all help is …

I was wondering if anyone could provide me a complete example with html tags and all of javascript or jquery that can load an html table with local files directly on my c drive? Sorry Ive been searching online all night and could not find anything.

I've have been doing some research on how to export export a pipe delimiated file from sql management studio but I cannot quite seem to figure it out. How would I simply turn this output into a piped file. [CODE]select * from #tmpRPLRouting where propertydatamap = '3' [/CODE]

Error: Cross-thread operation not valid: Control 'TextBox1' accessed from a thread other than the thread it was created on. After doing some research online I found when I add Control.CheckForIllegalCrossThreadCalls = False it works but I feel like that is not the proper way to handle this error. If anyone …

Hi All, Something strange just happened. I just tried to open a package that I have been working on but nothing opens in Recent Projects on the Start Page in SSIS. The package title is also grey. I have no idea what happened or what I could have done to …

I found this example online and cannot figure out why it will not work. I was wondering if anyone could help me figure out why this code does not work ive spend a few hours tinkering with it and no luck. I learn best by example and just basically need …

Hi All, I am trying to export data from SQL Server. But i am unable to do that. I have also created an SSIS pacage and after connecting the excel Manager when I am going to select the excel sheet it shows me the following error **The 'Microsoft.ACE.OLEDB.12.0' provider is …

Example data in column1 2|3|3|3GES|5|3 |3|334|3ere||343 I would like to split this by pipes so I can update the corresponding other blank 6 columns in each row. Example Col1 Col2 Col3 Col4 Col5 Col6 Col7 2|3|3|3GES|5|3 2 3 3 3GES 5 3 I hope this makes sense! Any help is …

Using VB.NET 2010 All helps is greatly appreciated! Currently I am parsing through 1,000s of text files each day and inserting them into SQL. I am unsure how to break up the actual pipe delimited data and insert it properly into my database columns so I am doing that through …

I have a nightly SSIS package that reorganizes indexes that are between 10% and 40% and then a weekly package that rebuilds for anything over 40%. But Ive noticed a lot of table do not change. Example below my Location table below is just about always at 82%. Am I …

BIDS 2005 DEV Ed I am working on a simple SSIS Package that parsers through a folder and uploads certains flat files data to certains databases. TextFile syntax example: CustomerData1213.txt;CustomerData1513.txt;CustomerData3313.txt;CustomerData1323.txt I am using a sql task that pushes file names from a table to the foreach loop (ADO Enumerator). However …

For the purpose of synchronizing data in sql server, such as: **1. Synchronize data between servers and client 2. When loss of internet, the client can still work based on the data required to run on the client. 3. When have the internet connection, data from workstations to be synchronized …

I have an ssis package the loops through an entire folder importing records into a sql 2005 database. I pull these records from a table in my database through an "execute sql task" then that gets pushed into the foreach loop container. However when one of the filenames is missing …

I need help with the format for single qoutes. I am using dynamic sql in an SSRS for error trapping records inserted with single qoutes during bulk imports but I cannot seem to format the actual select statement properly. SQL Sever 2005 Dev edition. Any help is great. Declare @DB …

I am trying to change the order of how my excel worksheets tab appear in my workbook. I have a .net app that parses and pulls data from sql and exports it to excel. Currently it spits out 5 tabs and the Summary tab is in the middle. I want …

Basically I have a trigger that is fired off whenever a workorder is reopened to close it again. The trigger works perfectly but I want to track the workorders where there is an attempt to reopen it. so basically if workorderid 8 is attempted to open again I want to …

What I am trying to do? update a database field with a richtextboxfield. Please help. I have tried using Dim range1 As New System.Windows.Documents.TextRange(RichTextBox1.Document.ContentStart, RichTextBox1.Document.ContentEnd) but this did not work for me either. [CODE] Dim cnn As SqlConnection Dim connectionString As String connectionString = "Integrated Security=SSPI;Initial Catalog=rploperations;Data Source=" & Environment.MachineName.ToString …

Hi there I am new to .net and I have put at least 4 hours in to figuring out why i cannot view my results when I run a datagrid in my 2010 visual studio WPF application. Also, it looks like it is only filling one record in the datagrid. …

I've been putzing around with this for awhile but I need to delete column B (minus the header) when ever it is empty. Does anyone have any idea on how to do this. If xlWorkSheet.Range("B2:B65565").Value = "" Then Dim rg As Excel.Range = xlWorkSheet.Columns("B") rg.Select() rg.Delete() End If

How can I replace only "North" in this following string when it is by itself? 'E NORTHCREST DR NORTH' UPDATE address SET streetname = REPLACE(streetname, ' NORTH',' N') This script changes it to 'E NCREST DR N'

I work for a small warehouse management software company and we were looking at dropping DotNetNuke for our inventory management portal and switching to Sharepoint(myself never thought of Sharepoint as an option). I was wondering if anyone has some insight on External Sharepoint sites as far as pros/Cons.

VB.net 2010 How I want the date: 2012-01-24 11:48:40.000 How I my program is exporting the date: 1/24/2012 11:48:40 AM currently I am using the sqlreader myreader.GetDateTime(10) which is giving me the format of 1/24/2012 11:48:40 AM

I built an app to create a night export of data. I am new to programming (basically I have found vb.net to be more powerful than SSIS) and I was looking for tips in improving my basic program. [CODE] 'Declared columns from SQL Script Dim Servicenumber As Integer Dim pilotarea …

I cannot figure out why this will not execute. For somereason it does not like my inner join I believe but it works perfectly in management studio. Any ideas? [CODE] Dim column_1 As String Dim column_2 As String Dim column_3 As String Dim TotalCol As String Dim D As String …

Hi, I am trying to use the PIVOT function in SQL Server 2008. I have a query that I think should work, but whenever I execute it, I get the errors: Msg 265, Level 16, State 1, Line 25 The column name "CompleteTime" specified in the PIVOT operator conflicts with …

Im trying to move all files from "C:\SSIS\Test1\" that are new than 2 days old to the C:\SSIS\Test\" but for some reason it keeps skipping over the if statement marked in red. Any help please. Very amateur programmer here! [CODE] Sub Text() Dim sDay As DateTime sDay = DateAdd(DateInterval.Day, -2, …

Windows Server 2005 [CODE]XCOPY "\\14.4.7.10\d$\FTP\TEST\Prod\*.txt" "D:\MANU" /D /E /C /R /I /K /Y PAUSE[/CODE] ---This works perfectly [CODE]XCOPY "\\14.4.7.10\d$\FTP\TEST\Prod\*.txt" "D:\MANU" /D /E /C /R /I /K /Y [COLOR="Red"]/DA#24H[/COLOR] PAUSE[/CODE] ---when I add the portion in red it fails Any ideas?