|
The sproc is there to provide the functionality.
If it is there, and works, and you need such, why ask for "any" solution that excludes it? Why "except"?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
You can always have a .NET program run the procedure taking data from it and email from the .NET program.
|
|
|
|
|
|
Hi,
I need your advise please..
here is the detail:::
The employee contract can be definite (with expiry date) or indefinite (open without expiry date).
The employee contract will always have date of join
if the contract is definite then employee will have 30 days every year where the year is the period between the date of join and +365 days and the renewal is the same (from the renewal date and +365)
if the contract is indefinite then employee will have 30 days every year where the year is the period between the date of join it's every 365 days so the contract has not renewal but the employee will have 30 days annually.
for example, if indefinite and date of join is 1 April 2010 then every period from 1 April until 30 March will have 30 days for the employee
I want to calculate the leaves for the employee without having to keep a renew table so it will be calculated based on the leave date and the first date of join.
hope I explained it well...
Technology News @ www.JassimRahma.com
|
|
|
|
|
so the data will be just one leave table with from and to indicating the leave period for every leave and the result will be
1 April - 31 March - [Total Taken Leaves] - [Total Remaining Leaves]
Technology News @ www.JassimRahma.com
|
|
|
|
|
|
I have HTML content in string variable (from to ) within store procedure. The html contains one table with 'n' number of rows and columns. Its my final output which i will publish in mail.
My need is : I want to workout on last column in this HTML, and highlight background with RED color whichever SLA missed (As my last column having date and want to highlight entries less than today's date)
How to achieve this. Please help.
|
|
|
|
|
How about learning CSS? (or HTML...)
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Please go through my first line.
"I have HTML content in string variable (from to ) within store procedure"
As i mentioned, this need to be achieved in STORE PROCEDURE. How to do this?
|
|
|
|
|
Hello,
I'm looking for a free (or cheap) and simple tool to design a SQL database. I just would like to be able to generate the standard SQL from the tool.
What do you suggest?
|
|
|
|
|
|
Microsoft® SQL Server® 2008 Management Studio Express? With Management Studio Express I can create tables then generate SQL for MySQL?
|
|
|
|
|
B413 wrote: generate SQL for MySQL?
Where in your original post did you say MySQL? If a generic SQL question is asked here, more that likely, the response will be Microsoft SQLServer biased.
|
|
|
|
|
If you need tools for MySQL go to it's home site and look for Workbench...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
TOAD has always been a decent tool
TOAD freeware for MySQL[^]
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
|
No#1 Option: ERwin Community Edition
No#2 Option: Toad Data Modeler freeware edition
No#3 Option: Oracle SQL Developer Data Modeler.
In [free] world, nothing else come closer to this.
|
|
|
|
|
CUSTOMER (Cust#, Cname, City)
ORDER (Order#, Odate, Cust#, Ord_Amt)
ORDER_ITEM (Order#, Item#, Qty)
ITEM (Item#, Unit_price)
SHIPMENT (Order#, Warehouse#, Ship_Date)
WAREHOUSE (Warehouse#, City)
List the orders that were not shipped within 14 days of ordering.
Produce a list of Cname who has not placed any orders.
|
|
|
|
|
It's not a "relational algebra equation" - the assignment is to write a thing called a "query". A "select query" to be more exact.
I can help with the assignment if you have a specific question, but I'm not going to give the solution. If you're looking how to get started, then I suggest you write a script to generate said tables with some testdata.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
If this is a relational algebra question in the sense of just math, probably can't help.
If it is a database question looking for a query, something like:
select order.order#
from order o left outer join shipment s
on order.order# = shipment.order#
where (shipment.ship_date is null and datediff(d, order.odate, getdate()) > 14) or
datediff(d, order.odate, shipment.ship_date) > 14
select cname from
(select cname, o.cust#, count(o.order#)
from customer c left outer join order o
on c.cust# = o.cust#
group by cname, o.cust#
having count(o.order#) = 0)
|
|
|
|
|
Much better for the second query:
select cname
from CUSTOMER c
left join [ORDER] o
on c.cust# = o.cust#
WHERE o.order# IS NULL
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
Tim Carmichael wrote: If this is ...
It's actually a homework question.
|
|
|
|
|
|
1)
∏{order#} (∑{datediff(ODate,Today)>14}
(REN o(ORDER) θ{o.order#=ons.order#} REN ons( ∏ {oredr#} (ORDER) - ∏ {oredr#} (SHIPMENT))))
2)
∏{CName} (REN c(CUSTOMER) θ{c.Cust#=onp.Cust#} REN onp( ∏ {Cust#} (CUSTOMER) - ∏ {Cust#} (ORDER)))
Operators used:
∑ is SELECT
∏ is PROJECT
θ is THETA JOIN
- is SET DIFFERENCE
REN is RENAME
{} is for enclosing expressions
|
|
|
|
|
Hi
I have executed package through command line its working fine. The same package executed in SQL SERVER AGENT throwing exception. Please find the exception below
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 5:13:13 AM Could not load package "C:\Packages\ITEMMASTER_IMPORT.dtsx" because of error 0x80131534. Description: The package failed to load due to error 0x80131534 "(null)". This occurs when CPackage::LoadFromXML fails. Source: {C45D90C3-5C86-4B77-B2D6-6A6261230041} Started: 5:13:13 AM Finished: 5:13:13 AM Elapsed: 0.078 seconds. Process Exit Code 5. The step failed.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
: