<html>
<head>
<title>I just wanted to post this here as an FYI since it took me several hours
to find out how to do it:</title>
</head>
<body lang=EN-US style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:Verdana'>I just
wanted to...
My production server (MSSQL 2000 Server with Service pack 4) is set to use Dinamically configured memory at 4MB to 1503MB max. After a few days, the process sqlservr.exe is using 1,609,560 K and growing. The host operating system is Windows 2000 with Service pack 4. The applications using the...
How can I display all rows for vendorkey even if vendorkey is null on table vendors
select vendor.name, vendor.key, vendor.id, item.number, item.name
from dbo.vendor, dbo.item
where vendor.key = item.vendorkey
With the query above I only get data that exists on table vednor
I want to get...
I want to sort by the following formula but need an sql expression. any help will be great
if {@OriginalQty} = 0 then
0.00 else (Sum ({Items_Sold.Quantity}, {Items_Sold.ItemNumber})%{@OriginalQty})
The code for @OriginalQty is
{Items_Sold.QtyOnHand}+(Sum ({Items_Sold.Quantity}...
I'm looking for a command for Redhat 8 that deletes 0 Kb files with extension .php including files located inside sub-directories
Thanks for your help in advance
How can I select one record with relation to two tables
for example
select * from system where user_id=admin_table id
and the result should be the name of the user whos id in the admin_table = the user_id in the users table
I have a query that requires that the current user's name = the username in the database
when I query "select user" I get "domain\username"
how can I tell my query that the username is the last 7 characters of the user result
I'm running a query where the database has a date format of 2003-07-31 10:43:56.717
what command can I use to retrive records created 2 days ago
For example
select * from customers where createDate = 'currentdatetime'
I tried that I got a couple of errors about the date format not being correct
How do I connect a Flash / Norstar Voice Mail System to a Meridian Modular / Compact DR5. I already have the Meridian system working, all lines programmed and ready. I only need to know what special cable, etc. I need.
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.