This all depends on what you are trying to accomplish. Are you trying to display the data? Or are you trying to Report it...two different things in my...

Usually when you copy and paste into MS Word, it preserves Colors and formatting. You also might want to try printing to a PDF (if you have a full...

Haha ! That's great! I thought ours was the only company who did this! To develop the skeleton of the software...and not even a...

Right, I already knew how to use CASE in a SQL Statement, I've done this for CrossTab Reports. Anyway, it just seems like there should be something equivalent to...

Well, that is not helpful . I ended up changing to "IF..Then" but seems like there should be a Select Case or something...oh well.

Whoops, I put this in the wrong topic section!

Here's the Code I use in a Stored Proc that calculates over time:

Set @DateFirst = @@DateFirst-- Save the Current Setting

Set DateFirst 1-- Set DateFirst to be Monday

Set @StartDate = DateAdd(d,...

I am thinking that many Developers / IS people go through this same thing. Don't take this personal...I used to do this . I think...

Ok, just making sure I am on the same page. What I've done is created a methodology of Database versions.

I've created one main DBScript which scripts in the Database,...

What exactly do you mean by "Scripts"? DBScripts?

First, make sure you have the User Account that you log in with on your IIS Server, setup in SQL Server as a Valid Login.

Secondly, make sure you are using...

Yes, that's a little more tricky but not too much. A great book is "ASP.NET Unleashed" by Stephen Walther (SAMS Press). Also, check out http://www.asp.net for...

Heh, if you peeps need any insight in VB.NET, let me know. I have been developing with it now for over a year and know it pretty much inside...

Hmm, maybe create a new Connection Object only when you go to retrive Data for your Recordsets. If Connection Pooling is on, this shouldn't be a huge resource hog.

As...

Actually, for your Recordset Issue, all you should have to do is set the "CommandTimeOut" Property of your Connection Object to = 0 or a very high number as well....