Viewing 15 posts - 13,396 through 13,410 (of 26,486 total)
SQLRNNR (3/27/2012)
Lynn Pettis (3/27/2012)
Brandie Tarvin (3/27/2012)
Lynn Pettis (3/27/2012)
March 27, 2012 at 12:07 pm
Aty01 (3/27/2012)
What makes up the customer details? Is this information stored any where else?
Customer
Customer Forename
Customer Surname
Street
Town
Postcode
Category
and the order table will have this detail, so that they can dispach it...
March 27, 2012 at 12:05 pm
SS999 (3/27/2012)
Currently its on sql server 2005.
You posted in a SQL Server 2008 forum, that usually means you will get SQL Server 2008 answers that don't necessarily work in SQL...
March 27, 2012 at 12:03 pm
Brandie Tarvin (3/27/2012)
Lynn Pettis (3/27/2012)
March 27, 2012 at 12:01 pm
Aty01 (3/27/2012)
Lynn Pettis (3/27/2012)
Aty01 (3/27/2012)
what else am i suppose to look for
Think about orders you have placed with a company. Right now I am just trying to help you...
March 27, 2012 at 11:55 am
Aty01 (3/27/2012)
what else am i suppose to look for
Think about orders you have placed with a company. Right now I am just trying to help you look at one...
March 27, 2012 at 11:53 am
Rod at work (3/27/2012)
March 27, 2012 at 11:49 am
GilaMonster (3/27/2012)
Lynn Pettis (3/27/2012)
GilaMonster (3/27/2012)
Lynn Pettis (3/27/2012)
Aty01 (3/27/2012)
there is no link to order table
Stepping in a minute. Look at your Order table and think of an order you may...
March 27, 2012 at 11:41 am
Aty01 (3/27/2012)
one order has many stock-----------
Stock ID
Right. What else?
March 27, 2012 at 11:40 am
capn.hector (3/27/2012)
djustice 20821 (3/27/2012)
ALTER DATABASE DB
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
GO
DROP DATABASE db
GO
and the error that I got:
Msg 5064, Level 16, State 1, Line 1
Changes...
March 27, 2012 at 11:39 am
GilaMonster (3/27/2012)
Lynn Pettis (3/27/2012)
Aty01 (3/27/2012)
there is no link to order table
Stepping in a minute. Look at your Order table and think of an order you may have placed with...
March 27, 2012 at 11:34 am
What is the smallest unit of time you would report? Remember DATEDIFF(hours,'2012-03-05 01:00:00.000', '2012-03-05 01:59:00.000') would return 0 where DATEDIFF(hours,'2012-03-05 01:59:00.000', '2012-03-05 02:00:00.000') would return 1.
What you need to...
March 27, 2012 at 11:33 am
Aty01 (3/27/2012)
there is no link to order table
Stepping in a minute. Look at your Order table and think of an order you may have placed with a company. ...
March 27, 2012 at 11:25 am
The date 1900-01-01 is the zero date. If you were to subtract '2012-03-05 00:00:00.000' from '2012-03-05 00:00:00.000' you will get '1900-01-01 00:00:00.000'.
I think the best thing to ask right...
March 27, 2012 at 11:18 am
Robert Davis (3/27/2012)
Ooh ooh. So what does ROM mean? 😀
Is this a real question? If so, Read Only Memory.
Do I get a prize?? :hehe:
March 27, 2012 at 10:49 am
Viewing 15 posts - 13,396 through 13,410 (of 26,486 total)