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

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