Click here to Skip to main content
14,973,970 members

Comments by Sprint89 (Top 19 by date)

Sprint89 3-Nov-14 11:50am View
What do you mean by 'extract'? are you trying to get at the contents of a text file? Or shell out to a batch file perhaps?
Sprint89 18-Jul-14 4:19am View
You could do it in dynamic SQL, get the number of records, build a string in a loop that would have that number of records, add a where clause and exec the string. Pretty ugly though
Sprint89 17-Jul-14 3:20am View
What do you want the generated code to do?
Sprint89 3-Jul-14 3:29am View
"First find days then calculate the months."

There are not a standard number of days in a month, it could be 28, 29, 30 or 31. That is why you need to consider month boundaries
Sprint89 1-Jul-14 3:30am View
You will need a separate update query for each table, are you trying to use one update for more than one table?
Sprint89 27-Jun-14 6:05am View
What is the error message?
Sprint89 26-Jun-14 9:25am View
Try a netstat -a to see if anything else is blocking that port
Sprint89 26-Jun-14 3:26am View
You don't seem to have included fn_executequerystring(); in the listing above
Sprint89 25-Jun-14 9:57am View
But that is in your SQL code. If you want to do it that way you need to do the whole transaction, commit/rollback/error-handling in the one SqlCommand. The other way to do it (as in solution2) is to handle the transaction in VB
Sprint89 18-Jun-14 6:10am View
Do you have a field in either the CRF_Project table or the CustomerList table that is called CreateYear? What happens if you use Create_Year?
Sprint89 17-Jun-14 10:15am View
I don't think you can ping a port
Sprint89 13-Jun-14 10:14am View
Are you trying to find, for each EmailID, the contiguous blocks of dates?

I.e. if there had been a record on 6/15/2014 for EmailID 2, your second and third lines in your results would be combined into

StartDate - EndDate EmailID
6/3/2014 - 6/16/2014 2
Sprint89 13-Jun-14 3:23am View
Is it really being used by another process? If you run Unlocker on it, does it show something hanging on it - a copy process or something?
Sprint89 6-Jun-14 5:22am View
Does a netstat show anything using that port?
Sprint89 30-May-14 6:27am View
'Create' as in instantiate the Entry class and call the methods??? Like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace ConsoleApplication1
class Program
static void Main(string[] args)
Entry entry = new Entry();

class Entry

public string Name { get; set; }
public IEnumerable<string> Emails { get; set; }

public void Save()
TextWriter tsw = new StreamWriter(@"C:\Emails.txt");
foreach (string email in Emails)


public void Load()
TextReader trs = new StreamReader(@"C:\Emails.txt");
Console.WriteLine("Press any key to exit...");


static class Process
public static void Start(string path)
// Your Process.Start code here
Sprint89 30-May-14 6:00am View
Are you asking how to call the Save and Load methods?
Sprint89 30-May-14 5:24am View
if X = 7, why not

20 3 abc123 3
22 4 abc123 4
Sprint89 22-May-14 6:24am View
I tried that on "Motin AS AS SUVASISH" and got "SISH"
Sprint89 7-Mar-14 6:41am View
Reason for my vote of 2 \n Lots of typos in code samples. Also missing code, doesn't run as is. I spent my time trying to get this to compile and run rather than follow the principles of the article