Help Required in SQL



sql 2000 Question 

i have following ddl and sample data

CREATE TABLE [Model_data] (
	[main_id] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
	[model_1_Group] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[model_2_Group] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[model_3_Group] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[model_4_Group] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[model_1_Value] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
	[model_2_value] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[model_3_value] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[model_4_value] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO


CREATE TABLE [tbl_status] (
	[main_id] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
	[status] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO


CREATE TABLE [data_table] (
	[main_id] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
	[group_id] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[model_value] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
	CONSTRAINT [PK_data_table] PRIMARY KEY  CLUSTERED 
	(
		[main_id],
		[group_id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [work_table] (
	[main_id] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[group_id] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[data_value] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[model_value] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO


insert into data_table values('A001','1','AB900')
insert into data_table values('A001','2','AB100')
insert into data_table values('A001','3','AB2000')
insert into data_table values('A001','4','AB700')

insert into data_table values('A002','1','CF1000')
insert into data_table values('A002','3','CF4000')
insert into data_table values('A002','4','CF9000')

insert into data_table values('A003','3','DE4000')
insert into data_table values('A003','4','DE9000')

insert into data_table values('A004','1','GT4000')
insert into data_table values('A004','4','GT9000')

insert into Model_data
values('A001','Y','Y','N','Y','ZZ3000','ZZ100',null,'ZZ700')
insert into Model_data
values('A002','Y','Y','Y','Y','QT5000','QT4000','QT3000','QT9000')
insert into Model_data
values('A003','N','N','Y','Y',null,null,'MM4000','MM9000')

insert into tbl_status values ('A001','T')
insert into tbl_status values ('A002','T')
insert into tbl_status values ('A003','T') 


group_id  1,2,3,4 against any main_id in data_table forms complete set
of data 
i want to insert only those values in work_table by joining tbl_status ,
data_table and model_data where 
status is 'T' and in data_table group_id  = 1 and in model_data value of
model_1_Group is 'Y' then data from data_table and model_data sholud be
inserted in work_table like following
 
 
main_id  Group_id  data_Value  Model_Value
A001      1       AB900        ZZ3000 
A002      1       CF1000       QT5000 

if group_id 1 does not exist then group_id 2 should be checked in
data_table with model_2_Group = 'Y' and data should be inserted in
work_table
if group_id 2 does not exist then group_id 3 should be checked in
data_table with model_3_Group = 'Y' and data should be inserted in
work_table
if group_id 4 does not exist then group_id 4 should be checked in
data_table with model_4_Group = 'Y' and data should be inserted in
work_table

for example complete data  data inserted in work table should be like
according to above sample data 

main_id  Group_id  data_Value  Model_Value
A001      1       AB900        ZZ3000 
A002      1       CF1000       QT5000 
A003      3       DE4000       MM4000


Regards
  


*** Sent via Developersdex http://www.developersdex.com ***
0
Jami
9/10/2010 6:34:15 AM
sqlserver.programming 1873 articles. 0 followers. Follow

1 Replies
1285 Views

Similar Articles

[PageSpeed] 53

On Thu, 09 Sep 2010 23:34:15 -0700, Jami <jami.khan@yahoo.com> wrote:

>
>
>
>sql 2000 Question 
>
>i have following ddl and sample data
>
>CREATE TABLE [Model_data] (
>	[main_id] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
>,
>	[model_1_Group] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>	[model_2_Group] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>	[model_3_Group] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>	[model_4_Group] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>	[model_1_Value] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
>NULL ,
>	[model_2_value] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>	[model_3_value] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>	[model_4_value] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
>) ON [PRIMARY]
>GO
>
>
>CREATE TABLE [tbl_status] (
>	[main_id] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
>,
>	[status] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
>) ON [PRIMARY]
>GO
>
>
>CREATE TABLE [data_table] (
>	[main_id] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
>,
>	[group_id] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
>	[model_value] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
>,
>	CONSTRAINT [PK_data_table] PRIMARY KEY  CLUSTERED 
>	(
>		[main_id],
>		[group_id]
>	)  ON [PRIMARY] 
>) ON [PRIMARY]
>GO
>
>CREATE TABLE [work_table] (
>	[main_id] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>	[group_id] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>	[data_value] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>	[model_value] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
>) ON [PRIMARY]
>GO
>
>
>insert into data_table values('A001','1','AB900')
>insert into data_table values('A001','2','AB100')
>insert into data_table values('A001','3','AB2000')
>insert into data_table values('A001','4','AB700')
>
>insert into data_table values('A002','1','CF1000')
>insert into data_table values('A002','3','CF4000')
>insert into data_table values('A002','4','CF9000')
>
>insert into data_table values('A003','3','DE4000')
>insert into data_table values('A003','4','DE9000')
>
>insert into data_table values('A004','1','GT4000')
>insert into data_table values('A004','4','GT9000')
>
>insert into Model_data
>values('A001','Y','Y','N','Y','ZZ3000','ZZ100',null,'ZZ700')
>insert into Model_data
>values('A002','Y','Y','Y','Y','QT5000','QT4000','QT3000','QT9000')
>insert into Model_data
>values('A003','N','N','Y','Y',null,null,'MM4000','MM9000')
>
>insert into tbl_status values ('A001','T')
>insert into tbl_status values ('A002','T')
>insert into tbl_status values ('A003','T') 
>
>
>group_id  1,2,3,4 against any main_id in data_table forms complete set
>of data 
>i want to insert only those values in work_table by joining tbl_status ,
>data_table and model_data where 
>status is 'T' and in data_table group_id  = 1 and in model_data value of
>model_1_Group is 'Y' then data from data_table and model_data sholud be
>inserted in work_table like following
> 
> 
>main_id  Group_id  data_Value  Model_Value
>A001      1       AB900        ZZ3000 
>A002      1       CF1000       QT5000 
>
>if group_id 1 does not exist then group_id 2 should be checked in
>data_table with model_2_Group = 'Y' and data should be inserted in
>work_table
>if group_id 2 does not exist then group_id 3 should be checked in
>data_table with model_3_Group = 'Y' and data should be inserted in
>work_table
>if group_id 4 does not exist then group_id 4 should be checked in
>data_table with model_4_Group = 'Y' and data should be inserted in
>work_table
>
>for example complete data  data inserted in work table should be like
>according to above sample data 
>
>main_id  Group_id  data_Value  Model_Value
>A001      1       AB900        ZZ3000 
>A002      1       CF1000       QT5000 
>A003      3       DE4000       MM4000
>
>
>Regards
>  
>
>
>*** Sent via Developersdex http://www.developersdex.com ***


Hi

Thanks for the DDL and example data it is refreshing to get such a
comprehensive post. This will do what you have asked:


SELECT d.main_id, d.group_id, d.model_value as [data_value],
m.model_1_value as [Model_Value]
FROM data_table d
JOIN model_data m ON m.main_id = d.main_id
JOIN tbl_status t ON t.main_id = d.main_id and t.status = 'T'
WHERE d.group_id  = 1
UNION ALL
SELECT d.main_id, d.group_id, d.model_value, m.model_2_value
FROM data_table d
JOIN model_data m ON m.main_id = d.main_id
JOIN tbl_status t ON t.main_id = d.main_id and t.status = 'T'
LEFT JOIN data_table l ON l.main_id = d.main_id AND l.group_id  = 1
WHERE d.group_id  = 2
AND l.main_id IS NULL
UNION ALL
SELECT d.main_id, d.group_id, d.model_value, m.model_3_value
FROM data_table d
JOIN model_data m ON m.main_id = d.main_id
JOIN tbl_status t ON t.main_id = d.main_id and t.status = 'T'
LEFT JOIN data_table l ON l.main_id = d.main_id AND l.group_id  = 1
LEFT JOIN data_table l2 ON l2.main_id = d.main_id AND l2.group_id  = 2
WHERE d.group_id  = 3
AND l.main_id IS NULL
AND l2.main_id IS NULL
UNION ALL
SELECT d.main_id, d.group_id, d.model_value, m.model_4_value
FROM data_table d
JOIN model_data m ON m.main_id = d.main_id
JOIN tbl_status t ON t.main_id = d.main_id and t.status = 'T'
LEFT JOIN data_table l ON l.main_id = d.main_id AND l.group_id  = 1
LEFT JOIN data_table l2 ON l2.main_id = d.main_id AND l2.group_id  = 2
LEFT JOIN data_table l3 ON l3.main_id = d.main_id AND l3.group_id  = 3
WHERE d.group_id  = 4
AND l.main_id IS NULL
AND l2.main_id IS NULL
AND l3.main_id IS NULL


John
0
John
9/10/2010 7:50:00 AM
Reply:

Similar Artilces:

A pal needs help on this site
A pal needs help on this site greetings fellow newsgroupers. I recently found a site called Microsoft Forums. In a very short time I became very known to the site and its an excellent tool. This guy who runs it is good too but needs a helping hand. Please do me a favor and check it out at http://www.msforums.org/ Categories are like Microsoft Windows, Microsoft Office, Microsoft Gaming, Servers, Developer and so on. Thanks to everyone. MDO Pro -- I go to Microsoft Forums, do you? http://www.msforums.org/ Please do not multipost. Read your reply in the Office setup group. -- M...

Selective report printing please help
Hi Under Transactions menu > Financials > Series post Say i check mark 2 or 3 records and post them I want to selectively print eg - 1st page of report ok print , 2nd page not required. etc Rick Unfortunately, what you want to do is not possible. -- Charles Allen, MVP "Rick" wrote: > Hi > > Under Transactions menu > Financials > Series post > Say i check mark 2 or 3 records and post them > I want to selectively print eg - 1st page of report ok print , 2nd page not > required. > etc > > Rick ...

Help open Excel 2007
My Excel 2007 tries to open but closes immediately. I cannot open any files in excel. Please help. Thank you. Maybe you have some code in your Personal.xslb that is in the workbooks open event (Personal.xslb is the equivalent to Personal.xls found in xl2003), see if you can locate and open this. You could try holding down the shift key when opening a file and see what happens. Does it happen with every excel file? -- The Code Cage Team Regards, The Code Cage Team http://www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team...

HELP #38
i have several email accounts i need to manage. and cant figure out how to set up outlook. I dont know my incoming and outgoing servers. Lila wrote: > i have several email accounts i need to manage. and cant figure out > how to set up outlook. I dont know my incoming and outgoing servers. Ask your ISP? Lila wrote: > i have several email accounts i need to manage. and cant figure out > how to set up outlook. I dont know my incoming and outgoing servers. Hi - you need to ask your ISP for this information. Also: please post by including a concise summary of your question in t...

Cannot view picture attachment when put in folder..HELP
I received pictures as an attachment. I wanted to save them so I put them in a created folder. Now when I open the folder and click on the e mail and try to open the attchment their muted and it won't let me click on them. What should I do? Thank you for your help. JOE Joe <jfsa1219@hotmail.com> wrote: > I received pictures as an attachment. I wanted to save them so I put > them in a created folder. Now when I open the folder and click on the > e mail and try to open the attchment their muted and it won't let me > click on them. A Windows or an Outlook folder? ...

Windows7 help: associating Word 2007 for .doc files
Hey guys, Whenever I try to open .doc files, it uses "WordPad" (the word processing program that came with Windows7) to open the files & sometimes it's unreadable with weird symbols. I used to just right click on the file & do "open with.." & choose the "Windows Office Word Viewer 2003" for files that don't look right (weird symbols) in WordPad... I just bought & installed Office2007 on my computer which is using Windows 7. Now that I have Word 2007, I want to make it the default program for .doc files so I don't have...

Scheduling legacy DTS packages in SQL 2008 SP1
I have hundreds of DTS packages that I brought over from SQL2000 into a SQL 2008 Enterprise SP1 64 bit environment, on Windows 2008 R2 64 Bit. Our plan is to bring everything over as is, and convert to SSIS as time permits. I've run into a bit of a stumbling block hopefully someone out there can assist me with. I can run the dts package by running it at the command line via DTSRUN /S I can run the dts package by hand via the backward compatability design time components when I schedule a job to do DTSRUN as a cmdexec the job fails saying it cannot find the specified file, ...

Help with wildcard Replace syntax, please?
I tried a wildcard Find/Replace: -- Find: 5 spaces, any combination of 2 numbers, a period ( {5,})[0-9]{2,}. -- Replace: 9 spaces, then "a." ( {9})a. Find worked. Replace gave me: " {9}a." I gave up trying to code it and just typed 9 spaces! 8>/ Is there something special I needed to do in the Replace box? Ed You must enter into the Replace box exactly what it is that you want to be used as the replacement Though, you could have used ([ ]{4}) [0-9]{2} in the Find what control and then \1\1 a in the Replace with control -- Hope this...

Help! need to fit 4 - 3.75"x5.25" cards (all different) on one page
Hi, I am new to ms publisher 2003, and I am trying to create a document that does the following: - about 50 unique thankyou cards - fit 4 or so on one page Thanks! When you say 'unique' do you mean you are Merging data and/or pictures to the cards 4 to a page? A little more information please? -- The US should free all those illegally held prisoners they are torturing, abusing and denying human rights being held at Guantanamo Bay. Hi, Each card will be typed manually, and I would like to fit for of these cards on one page/sheet of paper (to save paper). I will then cut ...

the server does not support the required HTTP methods 0x800CCC3E
I just started to get this error. ALso, I can not create more then 1 Homail account. When I do, only 1 account does Outlook pull & syn information from. Please help. What version of Outlook do you have? Outlook 2002 can only have one Hotmail account - Outlook 2003 allows multiple accounts. As to the error you're getting, you probably have a proxy server between you and Hotmail that doesn't understand the HTTP/DAV protocol used by Hotmail. Contact your network adminstrator (if the problem is occurring at work) or your ISP (if it happens at home) and ask them to upgrade to a pro...

Saving a File to SQL Server from Access 2003
I have an application written in Access 2003 using linked tables to SQL Server 2000. I need to code an Access form to upload files (i.e. .pdf, .doc, ..xls, .txt, etc.) to SQL Server and I've never done this before. Can someone please point me to some sample Access code that will take a file and save it to the (SQL Server) database? I also need to know how to retrieve it. Thank you! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200707/1 "richxyz via AccessMonster.com" <u35439@uwe> wrote in news:75094d3835f16@...

Event ID 5892 (on EXCH Server) HELP!!!
Situation: Vanilla install of CRM. Only problem was I could not send an email from CRM and received an error that was corrected by changin the permissions on my exchange server's "vsi 1" folder. But now, I get a 5892 error on each incoming and outgoing message saying it can't send to all servers. Mail sent through the web interface appear to go from the client, but never arrive. Email arriving never gets to the CRM server. Any ideas? Joseph Michaud Fixed it. Had to add the CRM server netbios name to the webpage host header. :) Whee! ...

Help req: how to conditional count with words in cells based on their formatting
I have a text based spread sheet that counts the number of words at the end of each row. I want to be able to bold selected words and have these excluded from the count at the end of the row e.g. frog cat dog (If cat is bolded then the count at the end of the row is 2 not 3). Thanks in advance. Babs That will require VBA code. Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "babs" wrote in message I have a text based spread sheet that counts the number of words at the end of each row. I wan...

Instr help
Hello, I've spent quite a bit of time in Excel using the SEARCH function to parse out names from a text field thinking I'd be able to use this same expression once I brought the data into Access. As I find out I guess I need to be using the InStr function in Access but I'm still having a little trouble. Here's an example of the text field : 00022956CTE/Smith,Harry And here's an example of the SEARCH function I used in Excel which produced "Harry": =+RIGHT(C2,LEN(C2)-SEARCH(",",C2,1)) When I try to run an Update query to a blank field with...

I need help getting started
I have Office 2007 and I am having trouble getting my e-mail address configured with Outlook. I get to the point where they want me to log into the server but when I input my information it doesn't accept it. I don't know what I am doing wrong. PLEASE HELP! "Laura" <Laura@discussions.microsoft.com> wrote in message news:2745354F-ED15-42A8-B3E5-41286A439EB2@microsoft.com... >I have Office 2007 and I am having trouble getting my e-mail address > configured with Outlook. I get to the point where they want me to log into > the server but when I input my inform...

help me with excel formula please
A B can somebody help with a formula in the B colunm so that it 1 1 give values added upwards in the A colunm 2 (1+2) 3 (1+2+3) 4 ( 1+2+3+4) advance thanks In B1 enter: =A1 In B2 enter: =B1+A2 and copy down -- Gary''s Student - gsnu200903 "shaanu" wrote: > A B can somebody help with a formula in the B colunm so > that it > 1 1 give values added upwards in the A colunm > 2 (1+2) > 3 (1+2+3) > 4 ( 1+2+3+4) > ...

PLEASE HELP ME with page numbering
I posted this earlier, waited all day for a response only to be told that I was on a Mac bulletin board that I was led to with a bad interface???? anyway here is my question. I am DESPERATE my page numbers are not showing in my document and I am at the end of my > rope. I am using MS word 2007 and Vista - I am able to go through all the > menus for header, footer, format page numbers, etc. but then no final product > shows up. > > The help desk at my school is clueless and offered no help whatsoever. > > I have spent HOURS trying to insert these page numbers today. I ha...

Convert OL 2003 PST file for use in OL2000
I need to use my Outlook 2003 pst on an older machine that has Outlook 2000. I am working to beat the clock, as this needs to be functional by morning. Any suggestions?? thanks in advance Rick Export your messages to an Outlook 97-2002 pst-file. For detailed instructions see; http://www.howto-outlook.com/howto/downgradefromoutlook2003.htm -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Navigation Pane Tips & Tricks -Create an Office 2003 CD slipstreamed with Service Pack 1 ----- "Rick" <anonymous@discussions.microsoft.com> wrote in me...

Help with adding a bit to an existing If Statement
I have a inherited a spreadsheet with formulae in it - this one gives m a number in column B which is great but I would like to add something t it so that it also looks at column P and if column P does *not* have th word "Unrefreshed" the formula below will return a value of zero =IF(ISBLANK(G30),"",VLOOKUP(G30,MachineData,3,FALSE)) Many thanks in advanc -- Message posted from http://www.ExcelForum.com Assuming you aret just testing P30 for the single word "Unrefreshed", then something like: =NOT(P30="Unrefreshed)*IF(ISBLANK(G30),"",VLOOKUP(G3...

desperately need help with average
This is what i have & works but need to do more AO6:AO66 = Names from week 1 =IF(AW6>0,AW6,'Week 1'!S6) AQ6:AQ66 = week 1 hours & adjusted hours =IF(AO6>"",E6+AZ6,"") AR6:AR66 =L means laidoff=IF(AY6>0,AY6,"") AS6:AS66 = Average hours {=IF(OR(AR6="L",AW6>""),AVERAGE(IF(AT$6:AT$66>=0,AT$6:AT$66)),"")} AT6:AT66 = total hours of this week =IF(AR6="L","",AU6) AU6:AU66 = Total hours of week 1 & this week=IF(AR6="L",AS6,IF(B6="","",AQ6+SUM(F6:Q6)...

Help in Subtotal
I have a list containing thousands of data like Product Name, Code Quantity, Rate, Value etc. Generally I use subtotal for productwise total and use sum function fo Quantity, value etc. through subtotal how i can get Code with Product name total ? I think i am not able to understand u so please go through m attachment file. thanks in advance. s kara +------------------------------------------------------------------- |Filename: example.doc |Download: http://www.excelforum.com/attachment.php?postid=2676 +---------------------------------...

Help needed to add commets, arrows, etc to existing graph...
I am wanting to add comments and arrows (that look proper) and fill i the area between two lines on a line graph i have created in excel. Ca someone please guide me on how this may be done... I was thinking: i. there may be a way to do it in excel that i am not aware of, ii. there may be another charting program which will draw the chart with all the frills from data exported from excel, iii. there may be another program that allows me to add stuff t already created excel charts, iv. something else. My aim is to export these graphs to word - they will form part of report i am writting. An...

CDocument Help
I'm deriving a class from CDocument to put some functionality to be shared. This base class will not be instantiated. It's just used as base for others. I'd like to add a pure virtual function so derived ones have to implement it: class CContactDoc : public CDocument { .... public: virtual void GetDetails() = 0; }; class CAttorneyDoc : public CContactDoc { public: virtual void GetDetails() { ... } }; I get a C2259 (Cannot instantiate abstract class due 'void GetDetails()' : pure virtual function was not defined) in IMPLEMENT_DYNCREATE( CCo...

Help Please
I have a: MainForm = record source "tblProject Staffing Resources". On the MainForm there are 4 comboxes: ProjectID = row source "qryProjectID Discipline Name = row source "qryDisciplineName" Section Number = row source "qrySectionNumber" Last Name = row source "qryLastName" There is also a select button and a clear button. Once a selection is made from one or a combination of combo boxes the select button is clicked and the results display in a subform = record source "SELECT [tblProject Staffing Resources].ProjectID, [tblProject Staffing...

Please help install SQL SRS CRM 4.0 on SBS 2003R2
Please help, how do I install and configure SQL 2005 WGE especially SRS on SBS 2003R2 for CRM 4.0 WGE? I'm just not finding any detailed information on SQL install/configuration. Please point me to any resources. thanks! On May 9, 3:56=A0am, Scroch <Scr...@discussions.microsoft.com> wrote: > Please help, how do I install and configure SQL 2005 WGE especially SRS on= > SBS 2003R2 for CRM 4.0 WGE? =A0I'm just not finding any detailed informati= on on > SQL install/configuration. =A0Please point me to any resources. > > thanks! It should be a case of putting t...