As the title implies:
select sum(t.TOTAL) recordTotal
from TRANSFERS..REPTRANSF t
inner join TRANSFERS..REPHIERARCHY h
on h.VP_ID = 'ES3891'
and h.AGENT_UUID = t.AGENT_UUID
where t.COL_DAT = '2008-03-01'
select sum(TOTAL) recordTotal
from TRANSFERS..REPTRANSF
where COL_DAT =...
I have 2 tables which are linked by userid. There is a column in the first table that I need to update based on the way the table would be sorted using criteria from another table. For example:
set nocount on
declare @a table (userid char(3), start smalldatetime, tiebreaker tinyint)
insert...
I have 2 tables, a calendar table and a vacation table. In the calendar table there is a date column and a slotsFull column. The slotsFull column represents how many people have taken a vacation for that particular time. In the vacation table there is a vacStart and a vacStop column that...
I have a table (VPOFF) that has a row for each 15 minute increment an office is open. In another table (VPVAC) are rows that define the start and stop time for employee vacations. In one procedure I'm inserting some bulk vacation rows, and I need to increment the SFULL column by 1 in the VPOFF...
I know a Rubik's cube is a puzzle in and of itself, but my question involves only a small part of a Rubik's cube.
Imagine you are holding a Rubik's cube and you are looking at the white face of the cube. If the cube is oriented such that the green face is on the right side, that will put the...
I'm having a weird issue with IE and clearing floats. First, a VERY cut down version of my code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>test</title>
<meta...
So, my machine got the IE7 critical update today. What stinks is my company is mostly win2k machines, so this problem isn't even very relevant for the time being (till they upgrade to XP).
Anyway, I have to start with a disclaimer - these pages have a lot of very unnecessary markup. It's used...
I'm wanting to know if something like this is possible. I'll try to explain this in simplest terms.
Assume I have a database like so:
myTable
num type junk
--- ---- ----
1 a abc
1 a xyz
1 b abc
1 c xyz
Now, the query that I'd like to write would pull a list...
On my company's main webpage, I decided to put some info about each of the applications when you hover over the links to them. Using the basic function from this page, I came up with this - which works out pretty nice:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"...
when I run the following command:
ltrim(rtrim('')) I am getting a value of NULL returned.
up until earlier today this command has always returned ''
is there a setting that can be changed that will cause this command to return different values?
the odd thing is that if I change to a...
(This example uses Jscript instead of VBscript)
Here's my situation.
When I call a stored procedure that returns a result this is how I usually pull the info:
var strConn = "Provider=SQLOLEDB;Data Source=servername;Initial Catalog=catalogname;User Id=userid;Password=password";
var oConn =...
I was hesitant to ask this question earlier because it didn't really have a whole lot to do with programming. But after the question about the lottery turned into more of a math discussion I figured this would be fair game.
Before I ask the question let me add that it doesn't really have an...
I've cut the page down considerably so that it will be easier to show my problem. I have a sort list that sits right on top of the scrollable list of exception codes. I need to make a printer friendly version of this page so I wanted to put a link out to the left side of the sort buttons...
I ran this hiijackthis scan on one of the machines here at the office and here is the log. There were a few adware alerts that popped up in a norton scan that it could not get rid of. Does anybody see anything malicious in this list? Thanks in advance.
Logfile of HijackThis v1.99.1
Scan...
I'm using MS Excel 2003.
Every time I open a document in excel the "Work Items" toolbar shows up. I right click on the toolbars section and uncheck it every time, however it's there again each time I reload excel. Is there a way to disable this toolbar so that it stays gone?
-kaht
...looks...
disclaimer: I didn't write all the table stuff on the page before you all tear me a new one [smile]
The div "content" is repositioned down below "menu" when the browser is resized smaller horizontally (in IE only). This wouldn't be that big of a problem, but we have to assume that the users...
I have 2 problems with my layout (please ignore the colors, they're bad but I used them for identification.)
1. In IE there's a small horizontal gap between logo and header.
2. I want the footer to appear at the bottom of the page, but if there is more material in the menu, the footer will...
I recently started making one of my web applications for work more cross-browser friendly. This whole time it had been developed for IE because we run a microsoft shop (unfortunately).
I ran into a bug when referencing table elements using the parentNode and childNodes collections. Take the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.