I drop the table because it needs to be rebuild on each cycle. The "Max" records are removed on the first cycle and then I pull the next set of "Max" records for the second cycle. This goes on until #BC is empty. Replace(Left(@BoardCert,2)+Cast(@Counter as Char),' ','') actually works. The real problem is the following: Select * Into #@BoardCert From #tblBoardCert It doesn't see #@BoardCert as #BC1 then #BC2 etc., it only sees it as #@BoardCert and so it errors because it thinks it's already written to #@BoardCert on the first cycle.

Select * Into #BC From dfCert -- Creates master Certification table -> #BC Declare @BoardCert Char(3) Set @BoardCert = 'BCn' Declare @Counter int Set @Counter = 1 While @Counter < 10 Begin Select Biog_Nbr, Max(Biog_Cert_ID) as aMaxBiogCertID, Max(Cert_Year) as aMaxCertYear Into #tblBoardCert From #BC Group By Biog_Nbr Delete From #BC From #BC Inner Join #tblBoardCert On #BC.Biog_Nbr = #tblBoardCert.Biog_Nbr and #BC.Biog_Cert_ID = #tblBoardCert.AMaxBiogCertID and #BC.Cert_Year = #tblBoardCert.aMaxCertYear Where #BC.Biog_Nbr = #tblBoardCert.Biog_Nbr and #BC.Biog_Cert_ID = #tblBoardCert.AMaxBiogCertID and #BC.Cert_Year = #tblBoardCert.aMaxCertYear Set @BoardCert = Replace(Left(@BoardCert,2)+Cast(@Counter as Char),' ','') Select * Into #@BoardCert --<< Here's the problem. I need this to be #BC1 then BC2, etc up to BC9 From #tblBoardCert Drop Table #tblBoardCert Set @Counter = @Counter + 1 Print 'The counter has just increased to ' + Cast(@Counter as Char) End

I'm very new to C#. I'm a beginner. I just need a very simple example of a ProgressBar that fills once every second for 10 seconds then goes blank and then fills every second for 10 seconds. I need this to study how it's done for something else. Many thanks if you are to help.

Very much a beginner C# person. I need something simple and I'm pretty sure it can be done. I need to go to a website and simply see if a date has changed. I it has I need to pull the date back in. The date always follows the same three words so it will be easy to find. Thanks for any who can help dflat4now

There are no keys. I simply want to check the column headings with a table we know is correct with the new incoming table. How does the new table (if at all) differ from the standard (I know the columns are right) table.

I have one table and the columns are exactly as they should be. I am sent new data that needs to match the columns headings of this first table exactly. How do I create a sql query (it's really in Access) that does a quick compare and show me any differences or how the new violates the standard?

Does anyone have the simple C# code for showing a butterfly flying across the screen. The one I remember from years ago used only two jpg pictures. Thanks, dflat4now

JimBDay does not show up on Console.WriteLine("Jim's Birthdate is... ", JimBDay); it just says "Jim's Birthday is..." and "span" shows as 9132.03:46:30.4287493 / How can I format this to say... This many months... This many days... This many hours... and This many minuts until your next birthday? using System; class myApp { public static void Main() { DateTime CurrTime = DateTime.Now; Console.WriteLine("Right now the date and time are: {0:F}", CurrTime); DateTime JimBDay = new DateTime(1983, 7, 26, 20, 0, 0); Console.WriteLine("Jim's Birthdate is... ", JimBDay); TimeSpan span = CurrTime.Subtract(JimBDay); Console.WriteLine(span); Console.Read(); } }

Many thanks!

I need just a simple console program to tell how many days and hours (minutes if possible) until this persons next birthday. He was born on July 26th 1983 at 8:00 pm. I'm really new at this and I wanted to give him a small exe (console program) for his birthday. This is all I oould come up with so far: using System; class myApp { public static void Main() { DateTime CurrTime = DateTime.Now; DateTime JimBDay = DateTime.Compare(CurrTime, "08/01/2008"); Console.WriteLine("Jim's Birthdate: ", JimBDay); Console.WriteLine("Jim's Birthday is July 26th at 8:00 pm"); Console.WriteLine("{0:F}", CurrTime); // Need some code to say there are this many days and this many hours until your next birthday (minutes if possible). Console.Read(); // wait } }

I have been studying C# for about 4 or 5 months and then thought "Well I'll just write something from scratch. Well I felt like I've been reading a book on "How To Swim" and then when I jumped in the water I just gasped for air! Well anyway I hoping that someone could look at this and tell me how to use the return for the "public bool TrueOrFalse(). Thanks and sorry this is so elementary. I think I would like to write a book some day named a Beginner Beginner for the Basics of C#. Well any way here it is. using System; using System.Collections.Generic; using System.Text; namespace StartingOver { class RunIt { public bool TrueOrFalse() { int four = 4; int five = 5; bool answer; Console.WriteLine("4 * 5 should equal: {0}", four * five); four*five return answer; } public void Getyear() { Console.WriteLine("What year will you be beginning?"); string year = Console.ReadLine(); Console.Clear(); Console.WriteLine("Starting all over again in {0}\n", year); } static void Main(string[] args) { RunIt ri = new RunIt(); ri.Getyear(); ri.TrueOrFalse(); } } }