- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
79 Posted Topics
 | 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 … |
 | Ive never had that happen to me but try creating a new package and importing the .dtsx file and see if that works. |
| | 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 … |
| | http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734 |
| | 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 … |
| | Are the clients just normal desktop users? If so you can put sql express on everyones system if your database is under 10 gigs and then have it send back the data to the parent database via SSIS or .Net. SQL Express does allow users to use any sort of … |
| | 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 … |
| | PIVOT (AVG(CompleteTime) FOR BuildType IN (CompleteTime)) AS pvt SELECT p.* From(SELECT BuildType, CompleteTime from tTemp) d PIVOT (AVG(CompleteTime) FOR BuildType IN ([CompleteTime]))AS p This should work if not send your table structure |
| | 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? |
| | [CODE]Dim FilestoCopy As String Dim NewCopies As String FilestoCopy = "C:\Users\Documents\*.txt" NewCopies = "D:\New\Documents\" If System.IO.File.Exists(FilestoCopy ) = True Then System.IO.File.Copy(FilestoCopy , NewCopies ) MsgBox("File Copied") End If[/CODE] I was wondering how to switch this to copy all .txt file from FilestoCopy to NewCopies |
| | I have a foreach loop package that parses through some flatfiles and imports them into a database. Instead of using a batch script to grab files only with todays date I would like the the ssis package to only parse files with some sort of getdate() function. SSIS 2005 sorry … |
| | |
| | Re: SQL problem If the tables to do not all have an identifier that join each other you are out of luck. Try this: select * from t1 a full outer join t2 b on a.id = b.id full outer join t3 c on b.id = c.id |
| | |
| | I am building an excel address parser. Column B = streetnumber Column C = UnitNumber Column B is my streetNumber and What I need it to do is anytime it finds a letter attached to the number it needs to move it from column b to column C. So if … |
| | VS 2005 I just started to realized the power of SSIS packages meaning I am very new. Anyways I built a package that pulls from one of my stored procs and creates a flat file out of it and then sends to an FTP folder Okay now the problem is … |
| | change your code to a simple select statement on the given tables. Also see if your script works in management studio without any issues. It might be the syntax of your code. |
| | Your second table seems to be an ITEM table that contains all of your items when the first Table is a new inventory table. I guess I would need to see the actual tables but it appears that table 2 contains the ESN and by federal law each mobile device … |
| | Explorer.exe will not start. When I remote into the server it just stays on the blue screen even when I try to manually invoke explorer.exe to start it will flash for a second but nothing happens. Any ideas?  |
| | Im using the rank function for a route order on my import. The script works perfectly fine except when I have to stops at a location (locationid,stored as a GUID). This is how it currently looks locationid Rank 0A0F4E97-699B-E011-B139-00188B47C528 1 0A0F4E97-699B-E011-B139-00188B47C528 2 110F4E97-699B-E011-B139-00188B47C528 3 110F4E97-699B-E011-B139-00188B47C528 4 0E0F4E97-699B-E011-B139-00188B47C528 5 0E0F4E97-699B-E011-B139-00188B47C528 6 … |
| | Is there a way for a router or different type of product that could pickup a wireless connection and then broadcast it on its own. Basically I have a 4-port dock that can only connect through a hardline and Ive been noticing more and more hotels only have wireless connections …  |
| | I'm running sql server 2005 and I need to pull information from 2 of the databases(all from the same server). All of the databases are identical minus the data. database1 = LCDEL database2 = LCDFV I need all of the location data from each database and instead of querying them … |
| | Can anyone tell me whats wrong with my script? sql server 2005 Error: Incorrect syntax near ')'. I have a feeling there is more wrong than that. [CODE]SELECT a.* FROM OPENROWSET('Data Source=10.10.1.31;Initial Catalog=RFDG;User Id=admin;Password=342ds2sa12e;', 'SELECT * FROM location') AS a[/CODE] |
| | I am new to SSRS 2005 and in my report my results are all be displayed page by page as in 1 record per page and I would like multiple records per page. My data is simply select address1, city from location These are my two values. =Fields!address.Value =Fields!city.Value How … |
| | I cannot figure out how to increase the @bin I tried a cast as int and still no success. Any ideas are greatly appreciated. [CODE]DECLARE @counter int DECLARE @bin varchar(9) SET @counter = 1 Set @bin = '65R110001' WHILE @counter <= 5 BEGIN insert into laitem (ViitemName,viitemdesc,vilastused,vidateadded,virevisiondate,active,entitycode,manufactureddate, stopid,statusid, itemtypeid) values …  |
| | I was wondering if anyone knew of a more efficient way to run this? I feel that there has to be a more efficient way. Thanks [CODE] Dim doc As New XmlDocument Dim nodes As XmlNodeList Dim nodes1 As XmlNodeList Dim nodes2 As XmlNodeList Dim nodes3 As XmlNodeList Dim nodes4 … |
| | I'm working on an app to parse Excel files. I need to remove invalid characters in column 2 and then in column 3 I need to trim and upper that column. Any ideas? [CODE]Dim sql As String Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet As Excel.Worksheet ' … |
| | I'm working on a vb parser for excel but when it comes across anything that is not int the spread sheet it gives me an excel error message and I want to stop that before it prompts. [CODE] Try xlWorkSheet.Cells.Replace(What:="Boulevard", Replacement:="BLVD") Catch ex As Exception ex = Nothing End Try[/CODE] |
| | Variable 'loNode' is used before it has been assigned a value. A null reference exception could result at runtime. does anyone know why I am getting this error? [CODE]Imports System.Xml Module Module1 Sub Main() Dim doc As New XmlDocument Dim loNode As XmlNode Dim nodes As XmlNodeList doc.Load("C:\Desktop\Template.xml") nodes = … |
The End.