Search results for query: *

How can I group dates in the following format QQYYYY in a simple select statement? Mike Cormier May God bless everything you do...

I am calculating the factorial and I need a data type that is larger than numeric(38,2). Does anyone have any suggestions? I have also tried bigint Mike Cormier May God bless everything you do...

How can you populate a table with factorial values for a population size of 1 - 200? Mike Cormier May God bless everything you do...

THanks for the extra set of eyes. Been a long weekend already. Mike Cormier May God bless everything you do...

I am running the following code, however I know that numerator = 7 and denominator = 23. Why is HCOObservation always coming out as a whole number of 1.00? SELECT (COUNT(CASE WHEN [AMI-1] = 'B' THEN [A].[CID] ELSE NULL END)) AS NUMERATOR, (COUNT(CASE WHEN [AMI-1] IN ('A', 'B') THEN [A].[CID]...

BillyRayPreachersSon Thanks! That’s exactly what I needed (scrollintoview)! Thanks for replying that answer out there. Now, Here's your STAR! Thanks again. Mike Cormier May God bless everything you do...

I'm interested in knowing if it is possible to set an anchor in a scrolling table with a locked header row. This will be done in ASP, but just need to know the HTML side of this puzzle. I need to anchor a row so when they select a row the page reloads and displays additional information on the...

Very hard to tell with out being there, but you might want to check the server's nic card configuration. If everyone can see everyone else and no one can see the server and the server can't see anyone...that has to be the source of your problem. Check your cat cables and make sure there are...

If you are trying to boot up with an XP CD, there should be a message to press any key to boot from CD. If you don't, it will continue to other boot up options. Just to make sure, I would also try the other CD drive. Mike Cormier May God bless everything you do...

I would say that we need a little more information to go on. What are you doing when this error occurs, what program/OS are you using, and what are you trying to get accomplished??? Mike Cormier May God bless everything you do...

I currently have cable high speed internet and the cable is split at the wall. One goes to my cable/modem and the other to my video card. If you do split your cable, try to use a good quality one from your cable company. The splitters that they offer at Wal-Mart and ‘insert your local...

Is the zip code in the same part of the column for every record (left or right part) or is it mixed thoughout the column? Mike Cormier May God bless everything you do...

Just type this in your select statement: LEFT(Tbl_Name, 10) This returns 10 chars starting from the left. Be careful on how the date is being stored. Using 10 is assuming that you have leading zeros in your date field.. 01/02/2004. good luck Mike Cormier May God bless everything you do...

Your first start should be to search the FAQ's on this site. My personal favority start would be http://www.w3schools.com Good luck, mike