Search results for query: *

Ah Chris! Sweet! Works like a charm. Thank you!

Not on my machine. I get Path]filename.xls Adding an equals sign at the beginning, or a space between the two functions(right term?) does not help either.

Among the built-in options for Excel footers is the filename and tab description. I like to put those in each of my document so people can find the file again later. But it is not always obvious which network directory contains the file so I'd like to add the full pathname to the footer. Is...

Holy cow! That is a great link John! I love days where I learn new skills, this is a banner day!

Hey, another neat idea! Thanks. I see you are concatanating the < sign to make it work, I wasn't haven't ay luck without the concatanation, so thats another good tip. Skip, why does yours work? What does the sumproduct function do?

Bingo! Thanks very much Skip!

I have a range called SCORES, with numeric values 0 to 100. I want to see how many scores are between (inclusive) let's say 70 and 79. And basically every other range of possibilities in 10 point increments. So I thought I'd use column D for the minimum point of any given range, and column...

When I press snooze on a calander alarm I'm expecting it to pop back up in 5 minutes like I told it. Instead it pops back up anywhere from 10 seconds to 2 minutes or so. Wildly inconsistent. Any ideas? Second issue, be a hero to many. Is there any way to pick a snooze interval longer than...

You are a stud! Thanks so much!

Sorry, stacked columns is correct. Your next steps let me add the row with the Line data to the chart, but it treats it as an additional data point and justs add it to the the top of each column. I need to diaplay it as a line, preferably with a second value scale on the right hand side Y axis.

Cordury2, can you explain why that will help? I've had the same problem, the exact same formula works fine in certain cells of my spreadhseet, and stubbornly displays as text in other cells. I suspect it is a cell formatting issue but I've never stuck with it long enough to figure it out...

It's also possible the User has inadvertently grouped the column and selected a higher level view.

I have a table of data, 12 columns of months and 8 rows of data. I want a chart with months as the X axis and values on the Y axis. I further want the first seven rows to be a stacked bar for each month, and the last row to be a line superimosed across the stacked bars. A stacked bar chart is...

That's a good idea. Pretty much that is how things are organized, so I'll give that a try. Thanks!

George has the right solution for you. To get an Excel list of numbers into a SQL table is easy, use the DTS Import wizard in Enterprise Manager, then use George's code

Are your 10,000 numbers sequential? If so, how about creating a table with all 10,000, then doing a join between that table and documentinfo so that a query returns only those records from your new table that do not have a match in documentinfo?

Thanks SQLBill, you are of course correct, it is the server list I'm seeing. Which answers my question, but does not solve my problem. The organization follows no naming convention for the servers, even where DNS is turned on the servers are named silly things like "Joes".... Oh well. I'll...

My organization has several SQL databases. I can establish connections to them through Enterprise Manager by typing in their IP addresses in the NEW box and completing the wizard, but then under my SQL Group I end up with several databases identified only by their IP addresses. Is there a way...

Are you trying to change the properties of the column OhMfNo? That is the the reason for the cast(OhMfNo as Char) If so, may I suggest the ALTER command? USE SANDBOX DROP TABLE #TEMP CREATE TABLE #TEMP (OhMfNo VARCHAR(3)) INSERT INTO #TEMP VALUES ('AAA') SELECT * FROM #TEMP ALTER TABLE...

Would it make sense to use a CASE statement instead?