Dissapointing Book Purchase

Jan 21, 2004

I went in to waterstones today to try and get a copy of sql pocket reference (o'riely publishers i think) but there were none in stock, as the new edition is out on the 31st.

so i bought sam teach urself sql "in ten minutes"

unfortunately it covers the alter tag but not its use to modify columns >:(

I'm a bit stuck with this one atm

---------------------------------------

1> alter table news modify ( dateadd varchar(80))

2> go

Msg 170, Level 15, State 1, Server NEIL, Line 1

Line 1: Incorrect syntax near '('.

1>

what exactly am I doing wrong?

View 6 Replies

SQL SERVER Purchase

Nov 9, 2006

Guys,

Would you mind advising me on what sql server license would be suitable?
What I am concerned about having is the ability to access a database from 10 computers.
I like to use the Enterprise Manager, Query Analyzer, write proceduers, Views and Triggers. Not sure if this affects anything.

View 3 Replies View Related

Need Opinion On New Purchase

Dec 18, 2007

I need to purchase a new computer for a small medical clinic which will basically only have one purpose: to answer to read and write queries to a SQL Server 2005 which is resident on that computer. Queries come from the current 8 stations (up to 14 stations in the future). Most of the time, only 3 stations will be active at a time. Queries are mostly to access patient file information, are not complex and are short-lived.

A friend of mine who owns a computer store just quoted me for a dual quad-core Xeon 5405 2GHz system with Windows Server 2003 10 Cals. I'm concerned about the following:
- What's the use in having 8 cores, each of them running at only
2GHz, when there's really only one service running (SQL Server
2005, likely Express Edition) on the computer. Does SQL Server
have the capability to make use of all cores? Otherwise, why
spend more for Xeon and so many cores instead of a single
C2D running at a faster speed of say 3GHz ?
- What would be the advantage of using a Windows Server over
Windows XP in a peer-to-peer configuration? I don't buy into
the 10 connection limit because the TCPIP.sys file can be
altered to move that limit up, so 14 stations does not trigger
the need for Windows Server in and of itself.

Thanks all!

View 5 Replies View Related

Idea On Hardware Purchase

Oct 29, 2004

I am looking for a good reference on hardware specs for a dedicated SQL server. I don't want to talk to vendors, because I'm not looking to get snowed. Does anyone know of any resources? The server is to be a dedicated dataserver, for about 300 clients.

View 9 Replies View Related

Which Sql Server Product To Purchase?

Oct 14, 2006

Hi,

The SQL server 2005 is needed to be put for user's access as database backend for VB.net application. We need only one system for development. Which is best suited for our application?

Any suggestions?

View 1 Replies View Related

Average Duration To Purchase Again Same Product

Sep 6, 2015

I have data concerning sale of several products, columns are two : Name_product, Purchase_day

I need to calculate with SQL the average duration (number of days) to purchase again the same product among the products

As in example, one product can be bought many times, so this product we will see it repeated several times at different days "Purchase_day" so here we can have Duration between each two successive purchases for the same product, but for the last purchase of this product the duration until today will be the day of yesterday minus the last day of purchase, and finally the average duration of this product will be the sum of all duration of this product / number of all duration of this product.

Link to the table copy and paste : [URL] .....

View 2 Replies View Related

Exclude All ID Which Doesn't Purchase Any Code

Aug 30, 2013

how can i exclude all id which doesn't purchase any code.

codeA,codeB,codeC,codeD,.....
ID 1 purchase codeA, this will not be pulled out.
ID 2 didnt purchase any code, this will be pulled out.

I tried select id,code from tableA where code not in ('codeA','codeB','codeC','codeD',...)

but it still pull out ID 1.

View 1 Replies View Related

Do We Get SQL2000 Media With A SQL2005 Purchase?

Mar 13, 2007

My company is planning to purchase a SQL2005 standard Processor license (unlimited users - about $5000)

Does anyone know if we can obtain SQL2000 media along with the purchase. Because of the app we are running and its stage of development, we have to install and run SQL2000 for about 6 months before we can run Sql2005. We dont want to purchase SQL2000 for such a short term use.

I asked a DELL rep to help me with this over a month ago and he still has no answers for me.

Any help with this would be greatly appreciated.

View 4 Replies View Related

SQL Statement To Retrieve Rows With More Than One Purchase On Any Particular Day

Sep 10, 2007

Hi,
I am new at SQL hopefully this would be a rather easy question for you guys to help me out with.
I have a table called PRODUCT with the following fields:
a. Product Name
b. Product Dept.
c. Purchase Date.

I would like to run a query to obtain all rows tha has more than one purchases on any particular day.

Any replies would be great.

View 1 Replies View Related

I Wanna Query A Purchase Order Table!...but Can Not:(

Feb 28, 2006

i use microaccess create table, there is a filed call"Complete_PO", value"yes/no"
i wrote following statement to select it, but at runtime, there is warning message"...constraint...one or more row violating non-unique and so so..." how to solve it
SqlSelectCommand2.CommandText = "SELECT Complete_PO FROM [PURCHASE ORDER] WHERE [PO_No] Like '%" & GetYearCode() & "%' ORDER BY Right(PO_No,4) desc"
PoNum_SqlDataAdapter.Fill(PO_DataSet1)
TextBox1.Text = PO_DataSet1.Tables("PURCHASE ORDER").Rows(0).Item("Complete_PO").ToString()

View 5 Replies View Related

Purchase Order Query: Very Funny And Challenge ^_^

Mar 1, 2006

i query a purchase order table, there is one column called PO_No, format: LP-0245111-0004
i make following statement to query: the middle code act as my id, using it search my records, the last 4 digit used to find the last purchase order number
SqlSelectCommand2.CommandText = "SELECT PO_No FROM [PURCHASE ORDER] WHERE PO_No Like '%" & GetYearCode() & "%' ORDER BY Right(PO_No, 4) DESC"
i checked my database, last record is LP-0545381-0300
in my debuging process, surprisingly found that selected record is LP-0545381-301 !
any one hav any suggestion? ^_^

View 2 Replies View Related

Does SQL 2005 Purchase Come With Access To SQL 2000 Media?

Mar 13, 2007

View 3 Replies View Related

Transact SQL :: Finding Last Purchase Price For Each Product?

Sep 29, 2015

I need to find the last purchase price for each product. If I run the following code, I correctly get 1 result for each productID and the last purchase order number.

SELECT pod.article as ProductID,max(pod.order_ID) as LastOrderfrom apodetail podgroup by pod.articleorder by pod.article

Now I need to add in the price for that product on that orderID. I've tried the following self join query, tried it without the join, and tried adding DISTINCT, but they all return more than 1 row per ProductID.

SELECT pod.article as ProductID,max(pod.order_ID) as LastOrder,pod2.rev_price as UnitPricefrom apodetail podjoinapodetail pod2on (pod2.order_ID = pod.order_id)group by pod.article,pod2.rev_priceorder by pod.article

How can I get it to simply add the price to the first query?

View 10 Replies View Related

Table Set Of Records - Show Purchase Time When It Crossed 1000

Feb 10, 2014

I have a table set of records. Its contains some customerID,SportsGoods,Price in different datetime. I want to add customer spent. If crossed 1000 means i have to show purchase time when it is crossed 1000. I need query without while and looping.

Example:

Customer NameGoodsPriceDatePurchased
ABat2501/31/2014
ABall221/31/2014
BCarrom Board4752/2/2014
CTennis Ball502/1/2014
AFootball1502/2/2014
DBat2501/31/2014
BBall221/31/2014
AHockey Bat1252/4/2014
CChess552/4/2014
AVolley Ball552/4/2014

View 9 Replies View Related

Time Slot Which Has Maximum Number Of Purchase Orders Created Or Updated

Jul 15, 2014

I need to write down a sql query wherein in one particular day(user will enter manually), i need to find out a 15 minutes slot wherein purchase order's created or updated are the highest.

i.e. out of 96 slots(15 minute slot each)-I need to find the slot which has maximum number of Purchase orders created or updated.

View 7 Replies View Related

How To Add Order Item Into A Purchase Order Using A Stored Procedure/Trigger?

Jan 4, 2008

Hey guys, i need to find out how can i add order items under a Purchase Order number.
My table relationship is PurchaseOrder ->PurchaseOrderItem.

below is a Stored Procedure that i have wrote in creating a PO:

CREATE PROC spCreatePO (@SupplierID SmallInt, @date datetime, @POno SmallInt OUTPUT)

AS

BEGIN

INSERT INTO PurchaseOrder (PurchaseOrderDate, SupplierID) VALUES(@date, @SupplierID)

END

SET @POno = @@IDENTITY

RETURN

However, how do i make it that it will automatically adds item under the POno being gernerated? can i use a trigger so that whenever a Insert for PO is success, it automaticallys proceed to adding the items into the table PurcahseOrderItem?

CREATE TRIGGER trgInsertPOItem

ON PurchaseOrderItem

FOR INSERT

AS

BEGIN

'What do i entered???'
END

RETURN

help is needed asap! thanks!

View 14 Replies View Related

DTS Book

Jul 19, 2000

Can anyone recommend a good book on DTS?

View 1 Replies View Related

New DTS Book

Feb 23, 2001

For those of us struggling with DTS, you've probably all seen
Professional SQL Server 2000 DTS
Mark Chaffin, Brian Knight, and Todd Robinson
WROX
ISBN 1-861004-41-9

This is brand new:
Microsoft SQL Server 2000 DTS
Timothy Peterson
SAMS
ISBN 0-672-32011-8

I have both and they're both worth owning.

I also just found a reference to the following, but I haven't seen it so I count vouch for it. (I also wonder why I haven't stumbled across it previously...)
Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NA and DTS
Frank Miller & Rachelle Reese
WROX
ISBN 1861002807

View 1 Replies View Related

Book

Jul 27, 2004

I read alot of Technical books on SQL and I have found that SQL for dummies is actually a pretty good book(nice reference)

View 1 Replies View Related

Got Done W/ Book, Anyone Want It ?

Mar 9, 2004

I really like to pass my books on, for small price to anyone who could use them, since I no longer need 'em. I've got one , the SQL 2000 Administrator's Companion. Please take a look, I put it on ebay:

http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&category=36313&item=3593450436

Thanks

/rob

View 9 Replies View Related

BEST SQL BOOK

Apr 15, 2008

Ok, look. I could sit here and ask about 1,000 different queries that I would like to have. I'd much rather prefer to find it on my own however. Could someone please recommend a book that will tell me all I need to know about performing different kinds of queries? I have limited Mysql, JavaDB experience. A beginner compared to most of you. Thx in advance for any replies.

View 2 Replies View Related

Book

Sep 6, 2007

Hi

Which is the best book to refer for SQL Server 2005

thanks

View 4 Replies View Related

The Best Book

Jul 20, 2005

Hi to all, I ask to everybody which is the best book of the MS SQl Server 2000.I search in particulary a book complete and advanced.ThanksAlex Palermo

View 6 Replies View Related

Book

May 30, 2006

It seems that there are only two books on SSIS

The Rational Guide to Scripting SQL Server 2005 - BETA preview

Professional SQL Server 2005 Integration Services by wrox

Has anyone read these or any other ones out there?

Any thoughts on which to get?

I am very new to SSIS.

Thanks

View 7 Replies View Related

Book

Feb 4, 2007

Hi,
Can you recommend a book on SSIS.
I am particularly interested in books which demonstrate a particular project from start to finish while going through chapters.
Thanks

View 6 Replies View Related

E-Book

Nov 14, 2007

Hi I tried to download the E-Book that is located on the benefits page, when i click to save it to hard drive it just sits and nevers start the process. What can I do to correct this matter. Thank you for you time and effort.

DKB

View 3 Replies View Related

DBA 101 Book

Feb 26, 2008

I'm looking for a good book to teach me the basics of SQL Server DBA - installing, daily routine tasks, basic best practices, etc. I'm a DBA newbie so I want beginning level.

View 4 Replies View Related

Book

May 25, 2006

Can you recommend a book on Integration services in sql server 2005?
Thanks

View 8 Replies View Related

Good SQL Book

May 30, 2007

hello
i am just starting to learn sql and know the basics, but now im looking for a good book to learn some more. A book that covers stored procedure would be very useful. If possible a book with q and a would be very good because i feel this tests if u understand what was just explaned. but if there is a good book without this it is ok. All sugestions welcome

NubNub

View 1 Replies View Related

Best Book(s) For Learning SQL?

Jul 8, 2000

I'm looking for a book or a couple of books to learn SQL (in general aswell as various versions from different vendors). A couple of books that would take me from beginner through advanced topics. Any good suggestions?

/ ludde@freebox.com

View 1 Replies View Related

Good Book For Using DTS?

Aug 23, 2000

I have been using DTS somewhat, but I would like to read a good discussion (with cpmplex examples) of it.

Anyone found either a book on DTS or a good section in a book?

Thanks,
Judith

View 1 Replies View Related

A SQL 7.0 Admin Book?

Jun 5, 1999

Any recommendations on a good SQL 7.0 Systems Admin book for future DBAs? Too many books at the store, so i'm wondering how i can narrow it down. I'm looking more for the Admin side rather than developer side type book. Thanks.