Comments by Sprint89 - CodeProject

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

http://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/

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();
entry.Load();
entry.Save();
}
}

class Entry
{

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

public void Save()
{
TextWriter tsw = new StreamWriter(@"C:\Emails.txt");
tsw.WriteLine(Name);
tsw.WriteLine();
foreach (string email in Emails)
{
tsw.WriteLine(email);
}
tsw.Close();
Process.Start(@"C:\Emails.txt");

}

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

}

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 fahami.menu.ASIM 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

Comments by Sprint89 (Top 19 by date)