MS SQL Server :: Do Anyone Have An Idea?

Just An Idea
what if I took this trigger and based it on a view rather then a table

CREATE TRIGGER TerminationUpdateTrigger ON EmployeeGamingLicense
FOR UPDATE
AS
INSERT INTO TERMINATION(Status,[TM #],LastName, FirstName, [SocialSecurityNumber], DateHired, Title)
SELECT STATUS, [TM#], LASTNAME, FIRSTNAME, [SSN#], HIREDATE, JOBTITLE
FROM Inserted
WHERE STATUS = 'TERMINATED'

CREATE VIEW dbo.Update_Terminations
AS
SELECT STATUS, TM#, LASTNAME, FIRSTNAME, SSN#, HIREDATE,
JOBTITLE
FROM dbo.EmployeeGamingLicense
WHERE (STATUS = N'TERMINATED')

Base the Trigger on this View rather then on the Table itself????

View Replies ! View Related

Any Idea's On 605
When one of the users log into the database via a thrid party application
they receive an error message:

2000/11/16 10:40:13.84spid51Error : 605, Severity: 21, State: 1
2000/11/16 10:40:13.84spid51Attempt to fetch logical page 7832 in database 'highview' belongs to object '1241055457', not to object 'application_data'.
2000/11/16 10:45:07.68spid46Getpage: bstat=0x1008/0, sstat=0x80002110, disk
2000/11/16 10:45:07.68spid46pageno is/should be:objid is/should be:
2000/11/16 10:45:07.68spid460x1e98(7832)0x49f900e1(1241055457)
2000/11/16 10:45:07.68spid460x1e98(7832)0x4810b86f(1209055343)
2000/11/16 10:45:07.68spid46... extent objid 0, mask 0/0, next/prev=0/0
2000/11/16 10:45:07.68spid46... retry bufget after purging bp 0x2da7e060

I tried running DBCC checkdb, newalloc,& checktable to fix the probelm and than droping the table and rebuilding it but not success, any suggestion are
more than welcome.

View Replies ! View Related

Need An Idea How To....
If anybody can suggest the most efficient way to "page" the output from a big and wide table (about 7000000 records) in order to display on the web in the user requested sort order. Sort order could be on at least 7 different columns from 50 of returned.

I need to find a solution to move to the next and previous page.

Any Idea?

Dim

View Replies ! View Related

Can A DTS Do This For Me , If So, Any Idea How?
Hi all,

I am new to the DTS game - or at least to trying to do anything other than transfer rows between databases with identical structures.

I now need to create a far more complex DTS package to transfer data between an SQL Server database (I am using SQL Server 7.0) and an Oracle database. I have no trouble in making the connections and performing simple DTS's beween the two.

However, my current task is more complicated.

Problem 1:
In one database I would store fifty values as 5 five records each containing 10 values (i.e. has ten fields). However, in the other database these fifty values would all be stored as one record (i.e. one row with 50 fields). How could I go about creating a DTS to transfer this information?

Problem 2:
These values should only be transfered if certain conditions are met in an another unrelated table. For example, a flag in another table indicating that transfer of the said values should occur.

Any help with either of these problems would be much appraciated.

Thanks in advance,
Ross

View Replies ! View Related

Someone Have Any Idea About It?
I have a table call CLIENTE and another table call ENDERECO where the CLIENTE table has the FOREIGN KEY of the ENDERECO table.

When I try INSERT COMMAND in C# this message is show.

The instruction INSERT conflicted with a constraint of FOREIGN FUNDAMENTAL "FK_CLIENTE_ENDERECO." The conflict happened in the database "E:ARQUIVOS DE PROGRAMASMICROSOFT SQL SERVERMSSQL.1MSSQLDATALINETEC.MDF", table "dbo.I ADDRESS", column 'IDENDERECO.'
The instruction was concluded.

I am a "little" lost.

Thanks.

View Replies ! View Related

Some Idea
Hi I'm new to sql and it would be great if someone could give some idea on how to do the following

This is the relational model:

Department(DeptNum, Descrip, Instname, DeptName, State, Postcode)
Academic(AcNum, DeptNum, FamName, GiveName, Initials, Title)
Paper(PaNum, Title)
Author(PaNum, AcNum)
Field(FieldNum, ID, Title)
Interest(FieldNum, AcNum, Descrip)

The question is :-
Which academics have the largest number of fields of interests? Return their academic number,
given name, family name, institution and total number of fields they are interested in. Your must use a
subquery in the sense that you must use 2 sql statements and use any of the following to connect both:-

1)Exists
2)Not exists
3)IN

View Replies ! View Related

When Are Transactions A Bad Idea?
Lets say I have to insert 60,000 or so records into SQL Server from another data source using the sqlTransaction class.

However if at any point an error should occur I would like to roll back any changes.

Would a transaction be a bad idea when dealing with this many records?

Thanks for any advice.

SA

View Replies ! View Related

Need Good Idea
Hi guysWe have a following problem. For security reasons in each table in ourDB we have addition field which is calculated as hash value of allcolumns in particular row.Every time when some field in particular row is changed we create andcall select query from our application to obtain all fields for thisrow and then re-calculate and update the hash value again.Obviously such approach is very ineffective, the alternative is tocreate trigger on update event and then execute stored procedure whichwill re-calculate and update the hash value. The problem with thisapproach is that end user could then change the date in the tables andthen run this store procedure to adjust hash value.We are looking for some solution that could speed up the hash valueupdating without allowing authorized user to do itThanks in advance,Leon

View Replies ! View Related

Does Any One Have Idea About DBE/ILE In Sql Server
Hello guys
can somebody help me,
is there any thing called DBE/ILE in sql server or in any
database.please let me know where can i find some details

View Replies ! View Related

An Interesting Idea...
Having no more experience than reading books online, here is an interesting idea I would like to run by you guys and you can let me know if it is feasible or tell me I need to put the crack pipe down...

We are going to increase the number of disks in our SAN, and I was speaking with the SAN administrator and he mentioned the shuffling of logical drives to match the new space. He said he is going to have to go through quite a few combinations/permutations on figuring out the best configuration for what data goes on the old vs. new to get the optimal space.

Is this something that can be modeled out? I can write something that recursively figures it out, but why not explore fun ideas with tools that may be able to do it?

Thank you in advance,

John Hennesey

View Replies ! View Related

Any Idea What This Means .....?

Hi,

Does anyone have any idea waht this means:

aspnet_wp!resourceutilities!5!07/11/2007-10:32:00:: i INFO: Reporting Services starting SKU: Developer
aspnet_wp!resourceutilities!5!07/11/2007-10:32:00:: i INFO: Evaluation copy: 0 days left

It is take from the ReportServer log file.

Thanks in advance for any response.

Jon

View Replies ! View Related

Need Idea About COLLATE
I need help regarding what is a collate and where to use.If any examples with INNER JOIN it could be more helpful....

View Replies ! View Related

Designing Idea Please
Dear Friends,I'm a junior DBA,
I've to prepare an online examination.
for this, I've three categories.
a)beginer level
b)intermediate level
c)expert level

again here subjects are 6. like sqlserver,oracle,c#,vb.net,html,javascript.
in these subjects, i've to select these three types of questions.
now how can i design for this requirement? shall i create three tables for beginer, intermediate,expert or shall i create 6 tables and write according that?

am i given correct inputs?

please give me an idea to design

thank you verymuch experts.

Vinod

View Replies ! View Related

Can Anyone Explain To Me Why This Is Not A Good Idea
I have a complex select statement that is used in several stored procedures. I decided that instead of having x number of T-SQL scripts with the same exact select statement that I would to put this query into a view and then do a select * from View. Recently an instructor told me that this was a bad idea and that anyone who uses a select * from anything should be fired. When I asked for his reasoning his response was to say the least abnoxious. I can understand why a Select * from Table might be a bad idea as the table definition can change, but the chances of a view changing seems much less likely.
Is a view a good idea in this case? Is the Select * from View really a bad idea?
Thanks

View Replies ! View Related

New Idea To Use The EXCEPT Operator To Paging
Last night, I have this idea, but can not know if it can have a good performance and efficiency when the @CurrentPage is big.-------------------------------------------------------------------DATABASE:AdventureWorks DECLARE @CurrentPage intDECLARE @PageSize intDECLARE @OrderExpression nvarchar(100)DECLARE @Sql nvarchar(500)SET @CurrentPage = 1SET @PageSize = 10SET @OrderExpression = N' employeeid 'DECLARE @BigTop intDECLARE @SmallTop intSET @BigTop = @CurrentPage * @PageSizeSET @SmallTop = (@CurrentPage -1) * @PageSizeDECLARE @StartTime datetimeSET @StartTime = GETDATE()SET @Sql = N' SELECT TOP (' + CAST(@BigTop AS nvarchar(10)) + ') * FROM humanresources.Employee '+ ' EXCEPT '+ ' SELECT TOP (' + CAST(@SmallTop AS nvarchar(10)) + ') * FROM humanresources.Employee ORDER BY ' + @OrderExpressionEXEC sp_executesql @SqlDECLARE @EndTime datetimeSET @EndTime = GETDATE()SELECT DATEPART(s,@EndTime-@StartTime)SELECT DATEPART(ms,@EndTime-@StartTime)GO-----------------------------------------------------------------

View Replies ! View Related

Have An Idea But Not The Answer.... :( Needed Help
Hi,
I have a table that has the ff:
LastName varchar(50)
FirstName varchar(50)
PhotoPath varchar(50)
Now I want to create a form that can accept the LastName,Firstname and also can upload a picture which in turn the filename of the image will be the value for the PhotoPath field, and eventually displays it using the repeater control.
Your Help/Info. is highly appreciated...

Jeff

View Replies ! View Related

Idea On Hardware Purchase
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 Replies ! View Related

Concurrency (recap And Idea).....
With respect to my (now not so recent) thread on Concurrency, I would liketo run my idea past you gurus to see if its a runner. First, a brief recap:I have a single user system (one user, one copy of the software, one copy ofMSDE, one machine) that I wish to convert into a multi-user/single databasenetworked system. The problem I had was that a lot of information isfetched from the database and cached in the client program (the programimplements a tree structure, similar to a file system, and each of the nodesin the system has properties). The concurrency issue revolved around havingmultiple users updating these properties and possibly able to modify thetree structure and there being no way to notify the other clients that theyneed to refresh their data structures. Consider the system to be similar toVSS to look at (and in VSS, people can make modifications to the treestructure also!).Ok, one of the suggestions was time stamping each record. So, when one usermodifies the record, a second user can detect whether their timestamp isdifferent and thus whether or not their update is invalid (and also whetheror not the client program needs to refresh the properties of the givennode). How about instead of a timestamp I simply use a reference counter.ie. an integer that increments every time the record is modified (sameprinciple). I don't need to know when it was changed, just that the tworeference counters are different between when I fetched and when I amupdating the record.Secondly, I think I have to distinguish between a change in properties and achange in structure. For example, User A doesn't need to know about achange in properties for a node he is not currently looking at. However,that same user will want to be told about any change to the overall treestructure. So, I was thinking that any operations involving modificationsto the tree structure should set a "structure changed" flag in the database(increment a counter). After any operation is performed, the clientcompares its "changed" flag to the database value to see if it needs toreload the tree structure.Do you think this is workable?Thanks.Robin

View Replies ! View Related

Design Idea Help For Database
we are creating a database of sales agents. Basically I have a tableof about 35,000 people, a second one with 8000 offices, and a thirdtable of around 400,000 transactions done by those 35,000 people inthose 8000 offices. We get new data everyday that just updates theexisting tables with the updated rosters and transactions.I want to build a quick website where our recruiters can look up thosepeople and keep contact info and all that fun stuff but also pullnumbers on those people. Like* How Many Transactions that Sales Agent did last year* Rosters by office showing productionThe goal is to click the users name and see all the percentages,commissions and data like that which we will get by searching thattable of transactions by the agents ID.the problems I see right away are stuff like* If I were to pull a report showing all agents in a single office withtheir number of transactions next to their name, that is a HUGE query.It would have to search the 400k worth of records for each of theagents on just that one report.A suggestions I was givenI was told by a fellow programmer a better way to do this is to have anadditional table that houses stats info and have the SQL server runautomated reports everyday at say midnight where it updates that table.This table could show stuff like** number of transactions for each user** avg sales price on all transactions for each user** avg commission on transaction for each userlet me know your thoughtsthanks in advanceMonkey Girl

View Replies ! View Related

Any Idea Of This Replication Error?
Hi, all..
One database called POS in a server A is replicated with another server B with merge replication.

Server A is distributor and publisher.
I tried to replicate POS db it keeps giving me error following.

"SQL Server Enterprise Manager could not retrieve information about database 'POS'
Error 21776: [SQL-DMO] The name 'POS was not found in the ReplicationDatabase collection. If the name is a qualified name.
user [] to separate various parts of the name, and try again."

When other try it gives following error..
SQL Server Enterprise Manager could not enable database 'POS' for merge replication.
Error 20736: [SQL-DMO] This object has been dropped from the server.

I did all I can do..
I reinstalled sql server and tried again.. but it gives same error..

Does anyone has any idea of this problem????

Please post any idea.

Thank you...

View Replies ! View Related

Is There Any Idea For The View In ERWin?
Hello, everyone:

I know this post is on the wrong place, but I didn't know any ERWin forum.

I set a data model project by ERWin 4, and import the database by Reverse Engineer. But there are not column names for all views, only view names are here.

Any help will be great appreciated.

ZYT

View Replies ! View Related

AUTO_UPDATE_STATISTICS A Good Idea?
Can anyone tell me if turning on the AUTO_UPDATE_STATISTICS option will have any adverse effects on performance? I've read that it is possible for it to adversely affect performance, because SQL Server “takes a quick break to update database statistics in the middle of the day”. The book does not explain why and I'm always leery of simply accepting something, simply because I’ve read it from a book. This is the first time that I’ve ever heard this and cannot find anything from SQL BOL or any other source.

View Replies ! View Related

No Idea About MSSQL2000. How Do I Export???
Hi.. Never used MSSQL 2000 db. I have this website that uses mssql2000. I want to export it and convert db in mysql. Please help me understand how i can do that. I have all login info..

View Replies ! View Related

IDENTITY_INSERT, Is It A Good Idea?
Hi,

Today I discovered this command completely by accident and thought that ther are several places which we could use it in our apps.

Talking with a colleague, he is not to sure as it new to him too.

By using this to recover lost identity values, would this have any possible adverse effects on the table, indexes etc.

I can see potential problems when constraints are set between tables/keys. Anyone with any experience using this good and bad would be useful to hear.

Thanks

Adam

View Replies ! View Related

My Million Dollar Idea
After working with database design for 15 years, I finally made my way up to working on multiple dimensional analysis tools.
We know they are there, i.b.m. power play formerly cognos, microsoft mdx
these are excellent for the upper echelon of decision support systems i.e. upper management.
So why cant we really impress the golden parachutist? We have 3 dimensional data models on our computers. We have 3 dimensional holograms becoming main stream.
I have searched and searched and no one I know has put these together.
What I want to see is a digital holographical projection of 3 dimensional data.
Any Ideas?

harrybowyer@aol.com

View Replies ! View Related

Database Design Idea
Good morning
In messages system i have table to store messages and another table to contain the links which the message is posted through
Now i want to delete a link but i don't want to delete the message sent through this link

The problem:
When displaying the message sent what will be fount in the link field (i.e for the deleted link)
I tried to move the deleted link data to separate table (EX: deletedLink) but if the user added new link with the same name as the deleted link? The problem mainly in when displaying the message sent i will have the same link twice one for the deleted and the other for the added one.

If any one has a good idea for doing that please reply to me
I donâ€™t want the sql code
I want just the idea
Thanks

mohammed Al maghraby

View Replies ! View Related

Many To One Relation - Is It A Good Idea?
Hi

I have about six different entities that can have zero or more note entities associated with them. The easy way to do this is obviously to have a different "note" table for each of the entities i.e. WorkItemNote, CustomerNote etc.. But I would much rather have a single "note" table since they would all be identical, so I came up with this design:

CREATE TABLE WorkItem
(
WorkItemGuid uniqueidentifier PRIMARY KEY DEFAULT (newid()),
-- rest of table declaration removed for bravity
)

CREATE TABLE Customer
(
CustomerGuid uniqueidentifier PRIMARY KEY DEFAULT (newid()),
-- rest of table declaration removed for bravity
)

CREATE TABLE Note
(
NoteId int IDENTITY(1,1) NOT NULL PRIMARY KEY,
ReferenceGuid uniqueidentifier NOT NULL,
Text ntext NOT NULL,
-- rest of table declaration removed for bravity
)

This way I can get notes associated with a given entity, either Customer or WorkItem, by just selecting from the Note table with its WorkItemGuid or CustomerGuid.

My question is: Is this the best approach to what I am trying to accomplish?

(ps: Apologies if "many to one" is not the right terminology)

Regards, Egil.

View Replies ! View Related

Keep Getting Error 208: Invalid Object Name, Any Idea?
When I try to amend a stored procedure, I get Error 208: invalid object name when amending a stored procedureAny idea how I can amend the stored procedure?thanks

View Replies ! View Related

Any Idea What The Purpose Of This SPROC Might Be? (no Prizes, Sorry!)
I've been asked to document an application and I'm going through allthe Stored Procedures and trying to work out what they're supposed todo.Can anyone give me an idea of what the Stored ProcedurewsBookingListsGetAll below is trying to achieve? Is it incomplete? Ican't see any reason to pass in the Parameter, and what is the UNIONSELECT 0 all about?Many thanksEdwardCREATE Procedure wsBookingListsGetAll@DebtorIDvarchar(15)Asset nocount onSELECTfldBookingListIDFROMtblWsBookingListUNIONSELECT 0returnGO/* Table def */if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[tblWSBookingList]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [dbo].[tblWSBookingList]GOCREATE TABLE [dbo].[tblWSBookingList] ([fldDebtorID] [char] (15) COLLATE Latin1_General_CI_AS NOT NULL ,[fldBookingName] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL,[fldAddressCode] [char] (15) COLLATE Latin1_General_CI_AS NOT NULL ,[fldEmail] [varchar] (250) COLLATE Latin1_General_CI_AS NOT NULL ,[fldFirstName] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL ,[fldLastName] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL ,[fldBookingListID] [int] IDENTITY (1, 1) NOT NULL ,[fldInvoiceNumber] [varchar] (15) COLLATE Latin1_General_CI_AS NULL ,[fldPayeeID] [char] (15) COLLATE Latin1_General_CI_AS NULL) ON [PRIMARY]GO

View Replies ! View Related

Using Xp_cmdshell In INSERT Trigger: Bad Idea?
Whenever something is inserted to a given table, I want to run someshell commands using xp_cmdshell. Would it be a bad idea to put thisxp_cmdshell in the INSERT trigger of this table?I understand that when using xp_cmdshell, the sql thread in questionwaits until xp_cmdshell finishes what it's doing. Does this mean ifmy xp_cmdshell call takes 30 seconds, that nobody else can insert tothis table until my xp_cmdshell and rest of the insert trigger finishup?The alternative solution seems to be frequent polling of the table inquestion; while this isn't really a great solution it would seem tocircumvent a table lock brought about by the INSERT trigger.Thoughts?Joel

View Replies ! View Related

Entity Relationship Management Idea
Please let me know what you think of this scheme I have come up with(not to imply that noone else has before me) for managingrelationships.I have created an entities table with Individual and Organizationalsubtypes. I need to be able to relate them to eachother (e.g., someare customers of or suppliers to others, some have employer/employeerelationships,...). I know this is not an uncommon thing to do.So, I have created relationship pairs with left and right values. Thepairs are things like employee/employer, customer/vendor,contractor/client,... Then I can create relationships that will letme look in two directions. For example, if I say entity1 has anemployee/employer relationship with entity 2, that means that entity1is an employee of entity2 and entity2 is an employer of entity1.Entities (This is just a view of the combined ind/org subtypes tables)EntityID EntityName1 Doe, John2 MyCorp, Inc.3 Smith, Jane4 AnotherCorp, Inc.RelationshipTypesRelTypeID RelLValue RelRValue1 Employee Employer2 Customer Vendor3 Client ContractorRelationshipsRelTypeID LEntityID REntityID1 1 24 2 22 3 3Then I can query for everyone that has a relationship with a specificentity by using:SELECT Entities.EntityName, RelationshipTypes.RelLValue ASRelationship FROM RelationshipsLEFT JOIN Entities ON Entities.EntityID = Relationships.LEntityIDLEFT JOIN RelationshipTypesON Relationships.RelTypeID =RelationshipTypes.RelTypeIDWHERE REntityID = 2UNIONSELECT Entities.EntityName, RelationshipTypes.RelRValue ASRelationship FROM RelationshipsLEFT JOIN Entities ON Entities.EntityID = Relationships.REntityIDLEFT JOIN RelationshipTypesON Relationships.RelTypeID =RelationshipTypes.RelTypeIDWHERE LEntityID = 2Returns:EntityName Relationship (to EntityID = 2)Doe, John EmployeeSmith, Jane ContractorAnotherCorp, Inc. Customer

View Replies ! View Related

Any Idea To Implement SCD Without SCD Component Of The SSIS
Hi All,
I would like to say thank you in advance for all your ideas. Here is my case i want to implement slowly changing dimension, i know that i can use SCD component of the SSIS, but because of performance issue i am thinking to use something else that can subtitute the SCD component, i want some idea from you guys if anyone has implemented before without Slowly Changing Dimension component.
If not, do you have any comment/suggestion to use the SCD component i mean if the worest comes and i use it, what draw backs does it has, for example interms of data size, performance. Note that i use Dedicated Server for the ETL in Production.

Thank you

SamiDC

View Replies ! View Related

Small Necessary Changes Missing In SP2. Any Idea If This Is In Pipeline
1. i find it hard to believe that I cannot use stylesheets for textboxes or for that matter anything. I have to manually go and edit every textbox.
2. I have to define at t global level if a link opens in a new window or same window.

Anyone has ideas if this is even in the pipeline to be done?. I had asked the same questions on the release of SQL Server RS and that time it was thought that it would already be there in SP1/SP2. But i do not see it.

Or anyone has ideas how to achieve the above?

View Replies ! View Related

Sanity Check/Question About Idea
OK can someone look at this idea and tell me if it sounds like it would be work and be a good way to do things

On our Virtual Server machine I have 4 Server's setup. All Running Windows 2003 Standard.

Server1 - SQL Server 2005 Standard

Server2 - SQL Server 2005 Standard

Server3 - SQL Server 2005 Express

Server4 - SQL Server 2005 Express

Now I would have Server1 & Server2 in a DB Mirror Mode. With Server3 being the witness. When Server1 Fails Server3 would tell Server2 to become primary. Then when Server1 comes back it gets updates from Server2 and vice versa if Server2 fails.

Now Server4 I was hoping to remove some of the processing that is done (currently via DTS in SQL 2000). This scheduled jobs will get the updates from another system process them and then push the changes to either Server1 or Server2 depending on who is the primary at the time.

Does this sound like it would work? Is this a solid idea in making the DB's available witha 99.9% uptime?

View Replies ! View Related

New Contest - $10,000 And All It Takes To Start Is An Idea...
Just announced, a new contest for SQL Server Express.
Do you like to use technology to build cool and useful stuff? Do you think you could do it with Visual Studio Express and/or SQL Server Express? Would you like $10,000 cash? Well then we have a contest for you! Learn more at www.MadeInExpressContest.com.
Cool stuff.
MJ

View Replies ! View Related

Is Dropping Distribution Db A Good Idea?
What would happen if I dropped the distribution db?

I'm having problems configuring distribution and after searching, I found someone that claims they solved the same problem by dropping the distribution db. The resolution is the last post on this thread: http://www.ureader.com/msg/11563430.aspx

Is this safe to do? There are currently no publications and the distribution server is not configured.

Thanks

View Replies ! View Related

Anyone Has Any Idea On How To Insert 2 Strings Into A Row With 2 Lines Created?
<p>Hi ,
I would like to know anyway to insert two strings into a row with 2 lines created?My codes are as below
                        If NodeName = "subProductPrice" Then                            If xmlrder.NodeType = Xml.XmlNodeType.Text Then                                SubPrPriceList.Add(xmlrder.Value)
                                For i = 0 To SubPrPriceList.Count - 1                                    SubPrPrice = CStr(SubPrPriceList.Item(i))                                    PriceBrkDownStr &= SubPrPrice
                                Next
                                PricePerDay = SvcDate & PriceBrkDownStr                                 dr("dailyPrice") = PricePerDay                            End If                        End If
Although both the SvcDate and PriceBrkDownStr are inserted into the same row but they are displayed into one line such as below:
<u>dailyPrice </u>02/03/2007    03/03/2007   120     230
Any idea how to make the date and price separate into two rows in the same table grid row? thanks =)</p>

View Replies ! View Related

Media File In Database... Good Idea ? Or Not
helloi want to give the ability to the people who will visit my web site to download and upload mp3 files. Should i insert the mp3 file in my database in a byte[] column or should i put the mp3 file in a folder of my web site ?Any idea or suggestions ?

View Replies ! View Related

Idea: New Database Object That Defines A FROM Clause
create from dbo.fromExampleasfrom dbo.Customers cjoin dbo.Invoices ion c.CustomerID = i.CustomerIDnow you can use it as follows:select c.CustomerID, i.InvoiceNofrom dbo.fromExampleI find I reuse FROM clauses alotand reusing a "base query" requires writing a very large and cumbersomeselect clause

View Replies ! View Related

Is It Good Idea To Replicate Sql Server Db Files?
Hi.I am wondering if it is a good idea to replicate sql server db filesusing frs.I don't really know how the frs works, sodoes frs replicates the whole database from time to time or just theportion that is changed?Also if the db is expected to change very often, and wouldn't it makethe whole system down?I wonder if it's a good idea just to make a backup of the database andcopy it.What's the usual practice?

View Replies ! View Related

Can A Managed Udf Contain A Static Dictionary&&<&&>? Is This A Wise Idea?
I currently have a udf written in T-SQL that's getting way too logically complicated!

It€™s typically accessed like this:

SELECT PartNumber,dbo.PartPrice(Manufacturer, Model, AssemblageInfo, Version, CustomerDiscountLevel) FROM WorkOrders where OrderNumber=123456

The udf does some complicated manipulations on the parameters and eventually does a SELECT on a lookup table and returns the result.

If I make this a managed code udf, the logic gets much simpler to write (great!).

But, my question is:

Can I take the lookup table and embed it in the udf--so the udf doesn't have to go to the database to do the lookup?

Would I do that in a STATIC dictionary<>?

Is it wise to keep the info statically?

The lookup table consists of 3600(+/-) elements and changes exactly once a month.

The SELECT statement using the udf typically returns several thousand rows.

The SELECT is done often.

--Mark

View Replies ! View Related

Is It A Good Idea To Install SQL On Exchange Server?

I am out of my element here but I have someone who is working on a project for me that entails him migrating our Access database to sql. He wants to load the sql software on our exchange server but our IT guy is saying this is not a good idea. Any thoughts???

Thanks,

Beth

View Replies ! View Related

Sproc Idea: How Sensitive Is A Neural Net To Each Input?
Wanted some candid feedback on this idea. Everyone knows that neural nets are a black box in terms of the weights and such it uses. The best you can do is to get an idea how "sensitive" the NN is to each input. I don't know of any example code that's out there to help you do this in an automated manner (correct me if I'm wrong) so I'm thinking about writing a sproc that would help with this task.

Basically, the sproc would take in the mining model's name and the key of one case. Let's say the case and its attributes are:

ZipCode=93901 (the case key)

MedianIncome=99,098

PopulationDensity=1234

AvgTemperature=74.3

Predict likelihood to respond to an offer

For that case, it would go through an iteration per input. First it would test the first input, MedianIncome. It would run 100 predictions using the input values listed above. All the inputs would remain the same throughout except for MedianIncome where it would try out the complete range of that input. Based upon how much the prediction changes, you would have an idea how sensitive the model is to MedianIncome. Then it would move on to the next input and do the same.

When it's done testing each input, it could spit out a dataset listing all the inputs in order of how sensitive the model is to them and a few other stats like min and max prediction.

Thoughts? Improvements? Alternatives?

View Replies ! View Related

Unable To Connect To An Existing SQL Express DB But No Idea Why?
Within SQL Express 2005 running on Windows server 2003 using asp.net as the interface

This Is the Situation, at first i recieved this error
"

Previously we received a €œfailed to generate a user instance of SQL due to a Failure in Starting the process for the user instance. The connection will be closed€?

I looked up this error and it seams to be a flaw/bug in sql server express the error occurs because of the use of remote login on the windows 2003 server.

The solution to this was to delete an sql server directory that resides here
C:Documents and SettingsUSERNAMELocal SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS.

This indeed solved the failed to generate a user instance once the server was re-started however now I get a responce within the asp.net pages (which will have been built into those pages)

Your login attempt was not successful. Please try again.

now i have checked the simple errors caps lock etc and tried to log on to the SQL pages directly on the server with exactly the same result. the system was built by somone else and has not been modified "intentionally" just recently i added a few extra databases to the same server location, could this have caused the problem. to my knowlage (e.g i cant recall changing any settings)

there are one or two extenuation circumstances just recently the whole file directory was transfered from one HDD to another and then back to it's original position now i dont think this altered data but possibly there is some inbuilt security or something, i would most sincearly appreciate any questions or answers about this possibly things i havent mentioned that you need to know, just let me know i will get back to you

thanks in advance

Chris

View Replies ! View Related

No Idea If This Is The Right Place To Post... Need Stored Proc Help
Hello,
I am trying to make a stored proc that will tell me if there are any rows in a table. The table name is a variable that I get at the start of the proc it is not sent in. What I am looking for in the table is sent into the stored proc.

here is where the problem is, i can not save it. It does not seem to allow me to use the if exists with variables. I have tried it also without the + and with the + ' to create a string I cant seem to get it anyway I try.

if exists (SELECT * FROM  + @TableName +  WHERE  + @ColumnName +  =  + @SearchStr2)

print 'got here ' +@TableName + '  '+  @ColumnName

END

Thanks for any help

View Replies ! View Related

Do Anyone Have An Idea?

Hi there, I have number of tasks in my control flow most of them are execute sql task. I want to update one of the column in my table when anyone of the task in the control get fails? Please let me know if anyone have an idea how to do this. Thanks and Regards

Hi there,

I have number of tasks in my control flow most of them are execute sql task. I want to update one of the column in my table when anyone of the task in the control get fails?

Please let me know if anyone have an idea how to do this.

Thanks and Regards