need help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Other Development Tools

need help

Author

Topic

parikhm3
Starting Member

12 Posts

Posted - 2007-07-26 : 11:55:28

thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-26 : 12:00:30

quote:
Originally posted by parikhm3

Add dropdown list "Service Category"
- Values = select distinct SVC_CAT from WWGD_SERVICENOTES
- Filter by "Service Category" AND "Service Name"
- If SVC_CAT IS NULL "Patch" can be assumed so that current patch processes do not need to be changed, i.e., patch services populated with "Patch"

Page split by Service category: <SVC_CAT> + "Services"
Example: "Inventory Services"

A transform is needed for column "REBOOT_FLAG"
-For app management there needs to be a transform occur in the WWRIM.HPSTYPE.REBOOT to GDESL.WWGD_SERVICENOTES.REBOOT_FLAG load:

set GDESL.WWGD_SERVICENOTES.REBOOT_FLAG = Y
if WWRIM.HPSTYPE.REBOOT has an "H" or "S" in it

otherwise set GDESL.WWGD_SERVICENOTES.REBOOT_FLAG = N

Add hyperlink (or button) to run script so that when "Service Name" is selected (or button pushed) all data is queried from the HPSTYPE table for that service.

This is

1) Not a Microsoft SQL Server question. SQL code below indicates other DBMS (Oracle?).
2) Not a working script.
3) Most problably homework question.

Moderator, please move this post to appropriate forum.

E 12°55'05.76"
N 56°04'39.42"

parikhm3
Starting Member

12 Posts

Posted - 2007-07-26 : 12:27:48

can u help me out

parikhm3
Starting Member

12 Posts

Posted - 2007-07-26 : 13:49:24

thanks

Haywood
Posting Yak Master

221 Posts

Posted - 2007-07-26 : 13:50:56

I deleted my reply...wasn't worth it.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-07-26 : 15:57:23

why bother editing your responses like this? lame.

oh, and if you have an oracle question it is best to go over to www.dbforums.com and post it in the appropriate forum there.

-ec

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-26 : 16:15:56

had an unbeliveable urge to delete the whole thread

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources