Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 385
Search took 0.02 seconds.
Search: Posts Made By: robprell
Forum: SQL Server 2000 September 2nd, 2008, 01:23 PM
Replies: 13
Views: 1,876
Posted By robprell
I don't think you can do this with MS-SQL, this...

I don't think you can do this with MS-SQL, this can be done with Oracle which supports better use of aggregation and sub queries.

When using MS-Sql I put the data into a temp table and add some...
Forum: SQL Server 2005 April 12th, 2008, 01:41 AM
Replies: 4
Views: 7,758
Posted By robprell
Another way of saying the same thing is the...

Another way of saying the same thing is the database has rules to prevent you from putting in bad data like duplicates. When you tried to put in a duplicate it rejected it as it should.
Forum: SQL Server 2005 April 12th, 2008, 01:39 AM
Replies: 4
Views: 1,576
Posted By robprell
My two cents if it's worth that. I largely...

My two cents if it's worth that.

I largely agree with Planoie. With one addition. If you have repeating logic in your stored proc for the add/modify it may be a good idea to put them both in the...
Forum: SQL Server 2005 April 12th, 2008, 01:36 AM
Replies: 2
Views: 1,915
Posted By robprell
post the query that failed if you want help.

post the query that failed if you want help.
Forum: SQL Server 2005 April 12th, 2008, 01:35 AM
Replies: 1
Views: 739
Posted By robprell
Triggers and stored procedures are completely...

Triggers and stored procedures are completely different based on what executes them. A trigger as the name implies is "triggered" on an event. You can have an Insert Trigger and an Updated trigger...
Forum: SQL Server 2005 April 12th, 2008, 01:31 AM
Replies: 2
Views: 903
Posted By robprell
you need to give more info if you want more...

you need to give more info if you want more help......
Forum: SQL Server 2005 April 12th, 2008, 01:28 AM
Replies: 5
Views: 1,457
Posted By robprell
Ok I will help you with your exam question. ...

Ok I will help you with your exam question.

a) if you have duplicate rows where every row is a duplicate you need to write a cursor and go through row by row comparing to the previous (assuming...
Forum: SQL Server 2005 April 12th, 2008, 01:25 AM
Replies: 2
Views: 852
Posted By robprell
This is a likely cartesian join when you get more...

This is a likely cartesian join when you get more data with this type of multiple joins......
Forum: SQL Server 2000 April 11th, 2008, 11:56 PM
Replies: 4
Views: 1,078
Posted By robprell
The encryption that comes with SQL is extremely...

The encryption that comes with SQL is extremely week.

Externally accessible third party tools are generally the best.

Ideally I try to add my own salt(cryptogrophy term) in addition to the...
Forum: SQL Server 2000 April 11th, 2008, 11:38 PM
Replies: 2
Views: 1,287
Posted By robprell
And the question is?

And the question is?
Forum: SQL Server 2000 March 3rd, 2008, 07:35 PM
Replies: 1
Views: 940
Posted By robprell
try posting this in the Oracle forum

try posting this in the Oracle forum
Forum: SQL Language February 7th, 2008, 07:40 PM
Replies: 2
Views: 1,010
Posted By robprell
This only checks if the id field is duplicated. ...

This only checks if the id field is duplicated. If the ID field matches but some or all of the other fields are different (thus not a dupe) this query will count it as a dupe.
Forum: SQL Server 2005 February 7th, 2008, 07:32 PM
Replies: 1
Views: 1,244
Posted By robprell
One license you pay for the processor speed. The...

One license you pay for the processor speed. The other you pay based on the number of connections allowed at a time.

Depending on the prices and your design you choose accordingly. For a web app...
Forum: SQL Server 2005 February 7th, 2008, 07:30 PM
Replies: 1
Views: 1,502
Posted By robprell
You may want to consider doing a trigger. ...

You may want to consider doing a trigger.

Depends on the volume of data your dealing with. A trigger can be setup when you insert or update a value in table one. It fires and takes that data and...
Forum: SQL Server 2005 February 7th, 2008, 07:26 PM
Replies: 6
Views: 894
Posted By robprell
If you use stored proc 1 to call up stored proc 2...

If you use stored proc 1 to call up stored proc 2 and stored proc 2 returns a value. You can print it in stored proc 1. But I believe you need to do this with two stored procs. You capture the...
Forum: SQL Server 2000 February 7th, 2008, 07:22 PM
Replies: 3
Views: 935
Posted By robprell
But when you "go get data from the SQL server"...

But when you "go get data from the SQL server" all your data is going over a small bandwidth connection. Be careful you don't do "select * from X" because all the rows are then sent over your small...
Forum: SQL Server 2000 February 7th, 2008, 07:19 PM
Replies: 3
Views: 2,151
Posted By robprell
I think you need to do master.dbo.sp_rename ...

I think you need to do master.dbo.sp_rename

or whatever database it is in that your using it with.

If you specify the fully qualified name I think that should fix your problem.
Forum: Perl February 6th, 2008, 08:47 PM
Replies: 2
Views: 1,703
Posted By robprell
Parsing question:

I am an admitted perl newbie. So please be gentile I bruise easily. I have a very simple question for someone who actually knows perl as I stumble through it. I have a variable and I want to...
Forum: SQL Server 2005 February 6th, 2008, 07:56 PM
Replies: 2
Views: 622
Posted By robprell
search the internet and learn what a "fact table"...

search the internet and learn what a "fact table" is and a "dimension table".

When you create one fact table, at least two dimension tables and load them with data and link them with inner joins...
Forum: SQL Server 2005 February 6th, 2008, 07:54 PM
Replies: 2
Views: 622
Posted By robprell
You can create star schema on ANY rdbms. But you...

You can create star schema on ANY rdbms. But you would be using rolap, not molap.
Forum: SQL Server 2000 February 6th, 2008, 07:53 PM
Replies: 3
Views: 2,151
Posted By robprell
build a command string and then execute it. ...

build a command string and then execute it.

something like:
set @cmd = 'sp_rename ''dbo.employees.id3'',' + @name + ', ''COLUMN'''

then execute @cmd
Forum: Flash (all versions) February 6th, 2008, 03:51 PM
Replies: 2
Views: 6,819
Posted By robprell
I believe the data grid was not supported...

I believe the data grid was not supported currently with AS3. It is only available with AS2, and Flex currently. So I believe what your request is not currently possible. I stick with AS2 for that...
Forum: SQL Server 2005 February 5th, 2008, 05:37 PM
Replies: 1
Views: 1,531
Posted By robprell
So you want a 1 for every Mon thru friday and a...

So you want a 1 for every Mon thru friday and a zero for every sat and sunday.

There are two different methods for doing this. One is to create a date table and put in one row for every day and...
Forum: SQL Server 2005 February 5th, 2008, 05:34 PM
Replies: 1
Views: 589
Posted By robprell
I have purchased a number of books and not seen...

I have purchased a number of books and not seen much of help from the book sources. I, although a big fan of books, had better luck learning online on the subject. The books I have, and I have a...
Forum: SQL Server 2000 January 28th, 2008, 11:33 PM
Replies: 3
Views: 935
Posted By robprell
I don't think it's a database problem, I think...

I don't think it's a database problem, I think its a bandwidth problem based on what you described. Get a fatter bandwidth internet connection. Database isn't web, it's not network bandwidth...
Showing results 1 to 25 of 385

 


All times are GMT -4. The time now is 10:19 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.