Forum: ASP.NET  Nov 13th, 2008 |
| Replies: 12 Views: 28,611 I'm not sure I understand. Is there a question here? |
| Forum: MS SQL Aug 13th, 2008 |
| Replies: 9 Views: 9,153 Let me know how it worked. If you get any errors, let me know of those too.
(I assumed you are using MS SQL 7 or above.) |
| Forum: MS SQL Aug 13th, 2008 |
| Replies: 9 Views: 9,153 copy/paste the following code into query analyzer.
SELECT C1, C2, C3, 0 [grp]
INTO #t1
FROM staging
declare @cnt as int
set @cnt = 0
update #t1 |
| Forum: MS SQL Aug 13th, 2008 |
| Replies: 9 Views: 9,153 I'm not so sure how your data columns relates to each other, but here's one way you can put data into the grp column....
This is a three step process since it looks like you have three unique... |
| Forum: MS SQL Aug 13th, 2008 |
| Replies: 9 Views: 9,153 Here's how you get the grp column into your temp table.
select C1, C2, C3, 0 [grp]
into #t1
from staging
This creates a temp table called #t1 with a column named grp which is all... |
| Forum: MS SQL Aug 13th, 2008 |
| Replies: 9 Views: 9,153 It looks like you want to do some logical grouping.
Here's what I would do....
C1 C2 C3 Grp
41 te cc 1
42 te cc 1
51 te cc 1
41 te cc 2
42 te cc 2 |
| Forum: MS SQL Aug 5th, 2008 |
| Replies: 8 Views: 1,624 Sorry - I haven't touched Access in ages so I don't think I can add any more value to this thread.
Perhaps the only advice I can give is to open up Access and test the query within the Access... |
| Forum: MS SQL Aug 5th, 2008 |
| Replies: 8 Views: 1,624 I think you have to qualify the field, "GRAPHICSVERSION" in the case statement.
You have:
cmd = New OleDbCommand("SELECT table2.GRAPHICSVERSION, case when GRAPHICSVERSION IS NULL then 0 else 1... |
| Forum: HTML and CSS Jun 5th, 2008 |
| Replies: 4 Views: 2,752 Here's your code...
<body bgcolor="#000000" onload="load()" onunload="GUnload()">
<div id="" align="center">
<a href="http://www.laudontech.com"><img alt="logo"... |
| Forum: HTML and CSS Jun 5th, 2008 |
| Replies: 4 Views: 2,752 Are you trying to clear the text box when it gets focus? if so, the see the code below. (I'm not too sure what you wanted to get out of the onclick event.)
<html>
<title>test</title>
<script... |
| Forum: HTML and CSS Jun 5th, 2008 |
| Replies: 4 Views: 638 Don't feel that you missed the boat; that was probably a boat you were better off missing anyway. It's good to get into the habit of writing correct code; breaking the habit of writing bad code is... |
| Forum: MS SQL Jun 5th, 2008 |
| Replies: 2 Views: 2,174 Use stored procedures and pass the data you need to update as parameters. |
| Forum: MS SQL Nov 2nd, 2007 |
| Replies: 15 Views: 13,562 I don't know how to specify the sheet by position.
I also struggled with the sheet names containing spaces. This seems to be a limitation as far as I was able to research. In the end, I replaced... |
| Forum: MS SQL Nov 2nd, 2007 |
| Replies: 15 Views: 13,562 Be careful in situations where you have different data types in the same column.
For example, in my spreadsheet, the first four rows contain information that really has nothing to do with the... |
| Forum: MS SQL Nov 2nd, 2007 |
| Replies: 15 Views: 13,562 Ok. One more thing (and I use this technique a lot). You can conditionally inject a zero to your string data based on conditions.
case when ((cast(f1 as int) > -10) or (cast(f1 as int) < 10))... |
| Forum: MS SQL Nov 2nd, 2007 |
| Replies: 15 Views: 13,562 Yes -- this is a hurdle that we have to face. You have to wirte a second routine that will cast your data into correct data types.
I tweak my data by getting the table containing the spreadsheet... |
| Forum: MS SQL Nov 2nd, 2007 |
| Replies: 15 Views: 13,562 Yes -- you can build the statement and then use the execute command to execute the statement.
I do something similar to the following in my actual code...
declare @text_01 as varchar(1000) ... |
| Forum: MS SQL Aug 9th, 2007 |
| Replies: 1 Views: 6,361 Have you considered puting this code in a stored procedure instead of a view? This type of code is easily implemented in a stored procedure.
If you require a view, then you may want to create a... |
| Forum: ASP.NET Jul 2nd, 2007 |
| Replies: 4 Views: 5,071 If you are using the .net framework 2.0 or greater, you may want to look at the PreviousPage property of the Page object.
For example, let's say you have a hidden field in your original page... |
| Forum: ASP.NET Apr 19th, 2007 |
| Replies: 2 Views: 1,207 It's not functionality that comes out of the box, but I believe you can do this. Let me divide your question into two parts.
PART 1:
First of all, each page in a Sharepoint site is ultimately... |
| Forum: ASP.NET Apr 19th, 2007 |
| Replies: 3 Views: 5,379 Tell us your requirements. Did you find any third party controls that do what you are looking for? If so, which? This gives us a better picture of what you require. |
| Forum: Geeks' Lounge Apr 18th, 2007 |
| Replies: 68 Views: 7,597 Huh? What did you say?:)
Maybe if I'd gone with the "can you hear me now?" guy, I'd still have a cell. But for now, I live in a cave. :'( |
| Forum: Geeks' Lounge Apr 17th, 2007 |
| Replies: 68 Views: 7,597 I've thrown away my cell phone about three years ago. (I was happy with the phone, but angry with the carrier - the one with the trench coat guy.) I had a Kyocera smartphone - it had a built-in... |
| Forum: MS SQL Apr 17th, 2007 |
| Replies: 7 Views: 9,521 You can create a view to get the data you want and the import it into excel. The "Import External Data" is in the Data menu, and is wizard based, so it's pretty easy.
If your data changes, all... |
| Forum: Geeks' Lounge Apr 17th, 2007 |
| Replies: 1,440 Views: 123,869 I wasn't directing my post directly to you. But kudos to you for responding. Looking at this post, so far, you haven't dodged a single tough question. |
| Forum: Geeks' Lounge Apr 17th, 2007 |
| Replies: 1,440 Views: 123,869 Go back a few posts and start replacing "scientology" with your religion. Hmmmm, makes you wonder how long your measuring stick is, eh?
Be careful how you judge others... |
| Forum: Posting Games Apr 17th, 2007 |
| Replies: 7,595 Views: 662,145 U.S. Army -> under budget |
| Forum: Posting Games Apr 16th, 2007 |
| Replies: 7,595 Views: 662,145 |
| Forum: Posting Games Apr 10th, 2007 |
| Replies: 7,595 Views: 662,145 |
| Forum: Geeks' Lounge Apr 9th, 2007 |
| Replies: 1,440 Views: 123,869 Come on, dude. Some jokes are better left untold. Bad taste. |
| Forum: Posting Games Apr 9th, 2007 |
| Replies: 7,595 Views: 662,145 |
| Forum: Posting Games Apr 9th, 2007 |
| Replies: 7,595 Views: 662,145 |
| Forum: Geeks' Lounge Apr 5th, 2007 |
| Replies: 1,440 Views: 123,869 Yes. It's debated because it's hard to understand. Just like the folks who had a hard time understanding that the world was not flat. It must have taken a whole lot of faith to believe that the ships... |
| Forum: Geeks' Lounge Apr 5th, 2007 |
| Replies: 1,440 Views: 123,869 God created the world in 6 days; not 7. God rested on the 7th day. This is Fact based on faith!
There was a point in time when folks believed that the world was flat. The world was as round as it... |
| Forum: Posting Games Apr 5th, 2007 |
| Replies: 7,595 Views: 662,145 |
| Forum: Posting Games Mar 23rd, 2007 |
| Replies: 7,595 Views: 662,145 returns -> Christmas gifts |
| Forum: Posting Games Mar 20th, 2007 |
| Replies: 7,595 Views: 662,145 |
| Forum: MS SQL Mar 19th, 2007 |
| Replies: 15 Views: 13,562 First of all, let me recap the situation. I need an interface that allows users to upload excel data into a sql database.
1) I need a way to get excel data into my sql database.
2) I use the... |
| Forum: MS SQL Mar 19th, 2007 |
| Replies: 15 Views: 13,562 Ok. Hang on; it's going to take a while for me to gather all of the information. |
| Forum: Posting Games Mar 8th, 2007 |
| Replies: 7,595 Views: 662,145 |
