| Groups | Blog | Home |
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 How to design this normalized database Posted by Zeeshan at 6/18/2005 1:59:01 PM Design a normalized database for “ABC CarRentalâ€. This is a car rental
company. One non-normalized way to represent this data is with the following
single table with given fields
CarRentalTable
CarId (PK)
Model
Color
CustomerName
CustomerAddress
PickupDate
PickupCity
P...more >>
SQL 2005 XML question. Posted by Colin Dawson at 6/18/2005 11:45:41 AM Hi All
I'm currently testing out SQL 2005 June CTP and have a question about one of
the new XML Features. I have an XML document...
<root>
<Item RowID="1" DataType="1" Value="hello">
<Item RowID="2" DataType="1" Value="Again">
<Item RowID="3" DataType="2" Value="100">
</root>
...more >>
How to calculate week number Posted by Isaias Wesley at 6/18/2005 9:11:04 AM Hi, Guys. I´m trying to create a script to update a dimension time and I need
input information about the number of week in this year.
For example:
Day Year Quarter Week
01/01/2005 2005 1 1
Ok? But my week starting on Sunday. I tr...more >>
Using the Split UDF to do multiple inserts Posted by hals_left at 6/18/2005 8:41:17 AM Hi I need to write a proc to do 1-n Inserts within a transaction.
I am using the udf split function at
http://www.4guysfromrolla.com/webtech/code/udf.txt to process the
inputs which are two variable length csv varchars - invoice line values
and invoice line descriptions.
I need to loop ove...more >>
Permission Posted by Ed at 6/18/2005 7:31:02 AM hi,
let say i have two tables called tableA and tableB
if I grant Insert, Update, Delete, Select to users for tableA and no
permission for tableB, in tableA, there is an insert trigger to access data
from tableB,
do users need permission for tableB when they insert data in tableA?
Th...more >>
Return 5 records for each day works fine on developement machine, Posted by Geevi at 6/18/2005 6:53:02 AM I need to get 5 avaialble times for each day of a month.
Here is my existing query:
-------------------------------------------------
SELECT InventoryID, AvailableTime
FROM tblInventory Inv1
WHERE InventoryID IN
(
SELECT TOP 5 InventoryID FROM tblInventory Inv2
WHERE
Inv2.Location...more >>
SQL DMO Curosr Posted by SQL at 6/18/2005 2:31:02 AM Hi there!
I'm trying to create a script (SQL DMO) which, when run on Server A, will
backup the databases on server B:
DECLARE @object int
DECLARE @hr int
DECLARE @property varchar(255)
DECLARE @return varchar(255)
DECLARE @dbname nvarchar(60)
DECLARE @sqlcmd nvarchar(600)
DECLARE @exec...more >>
Calculating Pay Periods Posted by ngorbunov NO[at]SPAM onetouchdirect-dot-com.no-spam.invalid at 6/18/2005 12:59:56 AM The pay period at my company is from sunday to saturday
How can I calculate these pay periods for the next 5 years
Example
StartPeriod EndPerio
20050612 2005061
20050619 2005062
20050626 2005070
Thanks
Nine
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |