Is this what you want? CREATE TABLE [dbo].[Test] ( [ColA] [int] NOT NULL , [ColB] [varchar] (5) NOT NULL , [ColC] [money] NOT NULL) GO ALTER TABLE [dbo].[Test] WITH NOCHECK ADD CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED ([ColA],[ColB]) GO
2003-06-25
The following works for me: select 'job_ID: ' + cast(job_ID as varchar(100)) from sysjobs Also the following works: declare @job_id uniqueidentifier select top 1 @job_id = job_id from sysjobs print 'job_ID: ' + cast(@job_ID as varchar(100)) Is it possible your variable @job_id is NULL? ie. you haven't fetched a value into it?
2003-06-24
2 reads
There's a bunch of MDX functions to do Lineair regression calculations. Check BOL for LinRegPoint, LinRegIntercept and so on.
2003-06-24
Yogi, I believe you are on the right track with the proposed table structure. Of course, it needs some additional fields, but I suppose you only mentioned the important ones. If I read your structure correct you would have a BOM in your tblBOM, let's say bomId = CAR. In the tblBomProduct table, you would […]
2003-06-24
NPeeters is right on when he says this will become difficult to manage...Anyway, that said, you could implement a structure like so: CREATE TABLE Product ( ProductID INT NOT NULL IDENTITYT(1,1) , ProductDesc VARCHAR(150) NOT NULL ) -- CREATE TABLE ProductDependent ( Product INT NOT NULL , Dependent INT NOT NULL ) -- CREATE TABLE […]
2003-06-24
1 reads
OK this is the nub of Manufacturing control systems. You have to make a seperation in your mind between products and Bills Of Material (BOM's) You're most of the way there in identifying that you need a BOM table. You must also cater for the fact that a Product could have more than one BOM […]
2003-06-24
1 reads
If I understand things correctly, using an index is at least 2 reads - one (or more) for the index and one for the page containing the data. If this is right, then it is only worth having an index if the whole table is more than 2 data pages. The actual number of rows […]
2003-06-24
1 reads
We have had many many problems with service packs and clusters. We manually apply the service pack to each node. There is a known issue with service packs files don't get copied over to the second node at all. HP support should have articles on this big time. If you do a search you will […]
2003-06-23
If you can identify the rows, you could manually do the inserts/deletes to the subscriber, then update all affected rows on the subscriber to let the changes propagate. Are you sure the transactions aren't still queued in distribution? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-23
Not answering the question, but the concept is too cool! May be my inexperience, but I've not seen a numbering system like this before. Is there an official name for this. Twelvish?
2003-06-20
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers