i've this with my sql server, but un installed. i need this book immiedietly please give me the linkGo to Microsoft.com and follow the links to SQL Server 2000 and then downloads. It will get you to the .msi file. I just ran it yesterday without a problem
Showing posts with label link. Show all posts
Showing posts with label link. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Books on T-SQL
Hi Can anyone suggest me a good book on T-SQL for SQL Server 2005? I preferably need both a Hardcopy and a softcopy (any link which covers in depth T-SQL for YUKON will do). Same for Hardcopy also.
Thanks in Advance
Shaun
I haven't actually read it, but the O'Reilly books are generally very good, and they have released on one SQL 2005:http://www.oreilly.com/catalog/progsqlsvr/
Also, Microsoft has some good books and courses online:
http://msdn.microsoft.com/sql/learning/default.aspx
HTH|||
For me Books OL is enough for all T-SQL questions and syntax issues.
I was looking for some good book for 2k5 but not many books are out yet.
|||? I don't think any are out yet. Itzik Ben-Gan and a couple of others have two books coming out in a few months, from Microsoft Press (part of the "Inside SQL Server" series). You might have to make due with BOL until that one is released. -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <Shaun Michael@.discussions.microsoft.com> wrote in message news:3049dd63-4c3c-42a8-9e31-57ee97c32f4e@.discussions.microsoft.com... Hi Can anyone suggest me a good book on T-SQL for SQL Server 2005? I preferably need both a Hardcopy and a softcopy (any link which covers in depth T-SQL for YUKON will do). Same for Hardcopy also. Thanks in Advance Shaun|||I've seen some books out, including the one in the link above. Some were out in Novemeber, but not official ones.|||? I'm not sure what you mean by "official". The only official documentation is Books Online. I don't recommend the book in my signature because the coverage of T-SQL isn't all that deep -- we covered the new features only. Aside from the four books targetted at the beta editions (Beauchemin et al, Otey, DeBetta, and Scalability Experts), all of the other books currently on the market are targetted at RTM, as far as I'm aware. -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <Shughes@.discussions.microsoft.com> wrote in message news:879be8bc-3533-4242-a45d-fc56a35ec105@.discussions.microsoft.com...I've seen some books out, including the one in the link above. Some were out in Novemeber, but not official ones.Tuesday, March 20, 2012
Book MergeRep (Was: It this a Virus (br0ther.exe) ?)
Am Sat, 29 May 2004 17:04:05 -0400 schrieb Hilary Cotter:
> the merge book should follow in the fall. Check the titles link.
thanks for the info
Susanne
Isn't there any other books about replication specifically Merge
Replication.
I have a project with a July 1st deadline that uses Merge Replication, I've
got it running in a test environement by I would like some more in-depth
information
about the method.
Any other recommended books?
/Fredrik
"Susanne Wenzel" <wirdnichtgelesen@.onlinehome.de> wrote in message
news:19ajjerha6fbc$.4tdmc1ejcav9$.dlg@.40tude.net.. .
> Am Sat, 29 May 2004 17:04:05 -0400 schrieb Hilary Cotter:
> thanks for the info
> Susanne
|||Fredrik,
there aren't any other books on replication - we're all eagerly awaiting
Hilary's.
BOL is the main resource currently.
If you're lucky, there'll be a scheduling of the pretty comprehensive MS
Replication course
(http://www.microsoft.com/traincert/s...2591AFINAL.ASP) at a local CTEC
(I'm running it myself (www.pygmalion.com) but it is at the end of July.)
HTH,
Paul Ibison
> the merge book should follow in the fall. Check the titles link.
thanks for the info
Susanne
Isn't there any other books about replication specifically Merge
Replication.
I have a project with a July 1st deadline that uses Merge Replication, I've
got it running in a test environement by I would like some more in-depth
information
about the method.
Any other recommended books?
/Fredrik
"Susanne Wenzel" <wirdnichtgelesen@.onlinehome.de> wrote in message
news:19ajjerha6fbc$.4tdmc1ejcav9$.dlg@.40tude.net.. .
> Am Sat, 29 May 2004 17:04:05 -0400 schrieb Hilary Cotter:
> thanks for the info
> Susanne
|||Fredrik,
there aren't any other books on replication - we're all eagerly awaiting
Hilary's.
BOL is the main resource currently.
If you're lucky, there'll be a scheduling of the pretty comprehensive MS
Replication course
(http://www.microsoft.com/traincert/s...2591AFINAL.ASP) at a local CTEC
(I'm running it myself (www.pygmalion.com) but it is at the end of July.)
HTH,
Paul Ibison
BOM structure using SQL
Hi there,
Im trying to create a multi-level BOM using MS SQL.
Here is my Table structure:
Table 1:
Part-Number
Table 2:
Part-Number
Part-Owner
So if I link Part-number from T1 to Part-owner I get all parts for that level.
If I link back from T2 using Part-number to T1 I can link again to T2 and check if there are any lower level part structures.
This imbedded link has no limits but usually does not go more then 6-7 levels.
Can anyone help with setting up code for this BOM?
ThanksYour table structure looks valid for logically modeling a hierarchal system. The join you described sounds valid as well.
You might want to add a Where clause and use that in a criteria driven stored procedure that will generate a BOM explosion out of a select, given an assembly SetID; (to return a specific sub part listing result set for a setID representing a desired 'assembly'). Im not sure I understand what you are asking for help with, if you'd like, post an email to me with more specifics, and perhaps I can send you some examples that would help.
Maps
INNER JOIN
Sets
ON Maps.SetID = Sets.SetID
INNER JOIN
Sets Sets_1 ON Maps.SubID = Sets_1.SetID
WHERE
Sets.SetID = [desired SetID]
NOTE:
Sets = "Table 1"
TABLE [Sets] (
[SetID],
[SetName])
Maps = "Table 2"
TABLE [Maps] (
[SetID],
[SubID])|||Hi,
I think you went over my head here
My SQL exposure is somewhat limited. I have not used stored procedures and it sounds from your explanation that I should be using them.
The logic I was going to use was to link Table1 to Table2, then Table2 to Table1 using the other part, however, at some point that becomes imposable.
If the stored procedure is the way to go, can you elaborate a little more how to set it up and what it does?
Thanks much|||RE: If the stored procedure is the way to go, can you elaborate a little more how to set it up and what it does?
Q1[How one may use a stored proc that accepts a parameter?]
A1 OK, I'll try to give you a short example here. If you'd like, post an email to me, and I can send you more complete demo examples.
Example using proc hr_Set_SubSets:
Assume you wish to see a BOM Explosion for a part / assembly number; say for part / assembly number 387. A stored proc that accepts an Int parameter and uses it as criteria on a properly constructed Select statement (built on the Maps and Sets tables) can do just that (assuming the Maps and Sets tables are correctly populated with data). Executing the example proc hr_Set_SubSets proc with 387 assigned to its parameter, would then return all 'components' for the part / assembly with a SetID = 387.
-- Example use of a stored proc hr_Set_SubSets:
Declare
@.vi int
select @.vi = 387
Exec dbo.hr_Set_SubSets @.pSetID = @.vi
-- Creating the stored proc hr_Set_SubSets in the example:
CREATE Proc dbo.hr_Set_SubSets
(@.pSetID int)
AS
SELECT
dbo.Sets.SetName AS SetName,
dbo.Sets.SetID As SetID,
Sets_1.SetName AS SubSetName,
dbo.Maps.SubID As SubSetID
FROM
dbo.Maps
INNER JOIN
dbo.Sets
ON
dbo.Maps.SetID = dbo.Sets.SetID
INNER JOIN
dbo.Sets Sets_1
ON
dbo.Maps.SubID = Sets_1.SetID
WHERE
dbo.Sets.SetID = @.pSetID
Maps and Sets schemas:
TABLE [Sets] (
[SetID],
[SetName])
TABLE [Maps] (
[MapID],
[SetID],
[SubID])sql
Im trying to create a multi-level BOM using MS SQL.
Here is my Table structure:
Table 1:
Part-Number
Table 2:
Part-Number
Part-Owner
So if I link Part-number from T1 to Part-owner I get all parts for that level.
If I link back from T2 using Part-number to T1 I can link again to T2 and check if there are any lower level part structures.
This imbedded link has no limits but usually does not go more then 6-7 levels.
Can anyone help with setting up code for this BOM?
ThanksYour table structure looks valid for logically modeling a hierarchal system. The join you described sounds valid as well.
You might want to add a Where clause and use that in a criteria driven stored procedure that will generate a BOM explosion out of a select, given an assembly SetID; (to return a specific sub part listing result set for a setID representing a desired 'assembly'). Im not sure I understand what you are asking for help with, if you'd like, post an email to me with more specifics, and perhaps I can send you some examples that would help.
Maps
INNER JOIN
Sets
ON Maps.SetID = Sets.SetID
INNER JOIN
Sets Sets_1 ON Maps.SubID = Sets_1.SetID
WHERE
Sets.SetID = [desired SetID]
NOTE:
Sets = "Table 1"
TABLE [Sets] (
[SetID],
[SetName])
Maps = "Table 2"
TABLE [Maps] (
[SetID],
[SubID])|||Hi,
I think you went over my head here
My SQL exposure is somewhat limited. I have not used stored procedures and it sounds from your explanation that I should be using them.
The logic I was going to use was to link Table1 to Table2, then Table2 to Table1 using the other part, however, at some point that becomes imposable.
If the stored procedure is the way to go, can you elaborate a little more how to set it up and what it does?
Thanks much|||RE: If the stored procedure is the way to go, can you elaborate a little more how to set it up and what it does?
Q1[How one may use a stored proc that accepts a parameter?]
A1 OK, I'll try to give you a short example here. If you'd like, post an email to me, and I can send you more complete demo examples.
Example using proc hr_Set_SubSets:
Assume you wish to see a BOM Explosion for a part / assembly number; say for part / assembly number 387. A stored proc that accepts an Int parameter and uses it as criteria on a properly constructed Select statement (built on the Maps and Sets tables) can do just that (assuming the Maps and Sets tables are correctly populated with data). Executing the example proc hr_Set_SubSets proc with 387 assigned to its parameter, would then return all 'components' for the part / assembly with a SetID = 387.
-- Example use of a stored proc hr_Set_SubSets:
Declare
@.vi int
select @.vi = 387
Exec dbo.hr_Set_SubSets @.pSetID = @.vi
-- Creating the stored proc hr_Set_SubSets in the example:
CREATE Proc dbo.hr_Set_SubSets
(@.pSetID int)
AS
SELECT
dbo.Sets.SetName AS SetName,
dbo.Sets.SetID As SetID,
Sets_1.SetName AS SubSetName,
dbo.Maps.SubID As SubSetID
FROM
dbo.Maps
INNER JOIN
dbo.Sets
ON
dbo.Maps.SetID = dbo.Sets.SetID
INNER JOIN
dbo.Sets Sets_1
ON
dbo.Maps.SubID = Sets_1.SetID
WHERE
dbo.Sets.SetID = @.pSetID
Maps and Sets schemas:
TABLE [Sets] (
[SetID],
[SetName])
TABLE [Maps] (
[MapID],
[SetID],
[SubID])sql
Sunday, February 19, 2012
blank report result
Hi aLL,
I have two DB's. A and B. I connect to A and construct a link diagram and run the report. But i get no data. When i see the SQL Its got the database B prefixed to the tables i am using. Even when i am conncting to A its running against B and that why getting no data.
What do i do...i am new to crystal...
matuI assume you're talking about views. If a view references B then it will quite rightly return data from B, even if you've stored that view in A. This isn't a crystal problem.
If the structure of A and B are the same, remove the B prefix from the view in A. Also, create this same view in B.
Now in Crystal, change your datasource location to whichever view you want the data from.
I have two DB's. A and B. I connect to A and construct a link diagram and run the report. But i get no data. When i see the SQL Its got the database B prefixed to the tables i am using. Even when i am conncting to A its running against B and that why getting no data.
What do i do...i am new to crystal...
matuI assume you're talking about views. If a view references B then it will quite rightly return data from B, even if you've stored that view in A. This isn't a crystal problem.
If the structure of A and B are the same, remove the B prefix from the view in A. Also, create this same view in B.
Now in Crystal, change your datasource location to whichever view you want the data from.
Subscribe to:
Posts (Atom)