Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
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 72
Search took 0.01 seconds.
Search: Posts Made By: sshelper
Forum: SQL Server 2000 June 28th, 2007, 05:33 PM
Replies: 1
Views: 744
Posted By sshelper
In SQL Server 2000, one way to do this is to put...

In SQL Server 2000, one way to do this is to put the records in a temporary table where the table contains an identity column that will serve as your RECNO column.

SQL Server Helper
How well do...
Forum: SQL Server 2000 June 13th, 2007, 09:49 AM
Replies: 1
Views: 652
Posted By sshelper
If you are referring to migrating your MS Access...

If you are referring to migrating your MS Access database to SQL Server 2000, refer to the following links:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/accessmigration.mspx...
Forum: SQL Server 2005 June 6th, 2007, 10:57 AM
Replies: 2
Views: 1,265
Posted By sshelper
Based on the error message that you get, when...

Based on the error message that you get, when adding a column in a table that already contains data, you have to either allow NULLs on that column or you have to specify a default value. Here's how...
Forum: SQL Server 2000 June 6th, 2007, 10:42 AM
Replies: 2
Views: 548
Posted By sshelper
Although this may be a duplicate post, I will to...

Although this may be a duplicate post, I will to answer it. Here's how your query will look like:

SELECT report_id, MIN(sched_id) as sched_id, ID13, ID14, ID15
FROM #tmp
GROUP BY report_id,...
Forum: SQL Server 2005 May 31st, 2007, 10:32 AM
Replies: 4
Views: 1,809
Posted By sshelper
If you are getting an error when you declare a...

If you are getting an error when you declare a variable as VARCHAR(MAX), maybe the database you are connecting to is not really SQL Server 2005 but SQL Server 2000. You may be connected to a SQL...
Forum: SQL Language May 29th, 2007, 11:47 AM
Replies: 2
Views: 1,233
Posted By sshelper
To only get one record, make sure that there is...

To only get one record, make sure that there is only one record in your T_ProgramLinks table. If there are multiple records in that table which have different URL values, then you have to put a JOIN...
Forum: SQL Language May 29th, 2007, 11:40 AM
Replies: 2
Views: 3,397
Posted By sshelper
Make sure that the data type of your parameter in...

Make sure that the data type of your parameter in your stored procedure is defined as either NCHAR or NVARCHAR, if this is SQL Server. If this is not SQL Server, just make sure that the parameter...
Forum: SQL Language May 29th, 2007, 11:37 AM
Replies: 2
Views: 1,407
Posted By sshelper
Check out the following link and see if it helps:...

Check out the following link and see if it helps:

http://www.sql-server-helper.com/faq/data-types-p01.aspx

SQL Server Helper
How well do you know SQL? Find out with the free test assessment...
Forum: SQL Server 2000 May 29th, 2007, 11:30 AM
Replies: 2
Views: 968
Posted By sshelper
You have to call the EXECUTE function to call an...

You have to call the EXECUTE function to call an SP and here's how to retrieve the return value:

create proc sp2
as
declare @x int
EXECUTE @x = sp1 5,6
print @x

SQL Server Helper
How well...
Forum: SQL Server 2005 May 23rd, 2007, 11:43 AM
Replies: 5
Views: 23,816
Posted By sshelper
a. To make your schema bound, in Enterprise...

a. To make your schema bound, in Enterprise Manager right-click on your view and select "Design View". Right-click on the window again and select Properties from the context menu. Then put a check...
Forum: SQL Server 2005 May 23rd, 2007, 11:38 AM
Replies: 3
Views: 1,768
Posted By sshelper
Try checking out the following link that returns...

Try checking out the following link that returns a comma-delimited string without using a cursor and see if it will help you:

http://www.sql-server-helper.com/tips/comma-delimited-output.aspx
...
Forum: SQL Server 2000 May 23rd, 2007, 11:35 AM
Replies: 3
Views: 3,911
Posted By sshelper
You have to specify the length of your @geography...

You have to specify the length of your @geography parameter because if you don't, it defaults to a length of 1. So even if you pass 'U.S.' to your SP, the SP will only read it as 'U' and it won't...
Forum: SQL Server 2000 May 23rd, 2007, 11:33 AM
Replies: 4
Views: 751
Posted By sshelper
First, you have to create a user-defined function...

First, you have to create a user-defined function that will accept the ID as the parameter and return the comma-delimited states. Here's a link that may be able to help you:
...
Forum: SQL Server 2005 May 21st, 2007, 09:48 AM
Replies: 1
Views: 755
Posted By sshelper
One way is to initially store the last identity...

One way is to initially store the last identity value in your first table into a local variable and then do the insert. Anything higher than that number are the values inserted to it:

DECLARE...
Forum: SQL Server 2000 May 21st, 2007, 09:39 AM
Replies: 3
Views: 655
Posted By sshelper
One way to do this is to use a recursive...

One way to do this is to use a recursive function. Here's a couple of links that discusses recursive functions that may be able to help you:
...
Forum: SQL Server 2000 May 18th, 2007, 03:50 PM
Replies: 2
Views: 496
Posted By sshelper
Your SQL statement is correct. One possible...

Your SQL statement is correct. One possible reason why you are not able to create the Tab_Add_Ach_qty table is that you don't have the permission to create objects in the database.

SQL Server...
Forum: SQL Server 2000 May 18th, 2007, 03:36 PM
Replies: 5
Views: 1,120
Posted By sshelper
Just a warning to the query I provided. If the...

Just a warning to the query I provided. If the customer has accounts in all branches and in some branches he has more than 1, that customer will not be returned by the query because his total...
Forum: SQL Server 2000 May 17th, 2007, 09:23 AM
Replies: 5
Views: 1,120
Posted By sshelper
You can try this query: SELECT CustomerID ...

You can try this query:

SELECT CustomerID
FROM Customers A INNER JOIN Branches B ON A.BranchName = B.BranchName
GROUP BY CustomerID
HAVING COUNT(*) = (SELECT COUNT(*) FROM Branches)

SQL...
Forum: SQL Server 2000 May 16th, 2007, 10:11 AM
Replies: 2
Views: 1,455
Posted By sshelper
Based on the error message, one of your columns...

Based on the error message, one of your columns in your WHERE clause is of smalldatetime data type and the value you are trying to compare to it is either before January 1, 1900 or after June 6,...
Forum: SQL Server 2005 May 11th, 2007, 11:30 AM
Replies: 4
SQL
Views: 515
Posted By sshelper
If you are going to show the first 35 words to...

If you are going to show the first 35 words to the user using an application, the easiest way is for you to do this from that application. If you really need to do it in SQL, what you can do first...
Forum: SQL Server 2000 May 8th, 2007, 02:51 PM
Replies: 4
Views: 1,074
Posted By sshelper
To get the output parameter of your SP, you do it...

To get the output parameter of your SP, you do it this way:

declare @DateofWeekN DATETIME
execute dbo.spGetProjectDateOfWeek 'ProjectID', 'BatchCode', 1, @DateofWeekN OUTPUT
select @DateofWeekN...
Forum: SQL Server 2000 May 7th, 2007, 11:28 AM
Replies: 9
Views: 1,421
Posted By sshelper
Here's another link that may be able to help you:...

Here's another link that may be able to help you:

http://www.sql-server-helper.com/functions/comma-delimited-to-table.aspx

Simply change the comma delimiter to a pound sign (#).

SQL Server...
Forum: SQL Server 2000 May 7th, 2007, 11:26 AM
Replies: 2
Views: 3,973
Posted By sshelper
To execute a script from the command prompt, you...

To execute a script from the command prompt, you will use the osql command. Try searching for this command in Google to get more information on how to use it or simply type "osql /?" to get the...
Forum: SQL Language April 30th, 2007, 09:10 AM
Replies: 2
Views: 884
Posted By sshelper
There are 3 ways of doing this and here's a link...

There are 3 ways of doing this and here's a link that discusses all 3 options:

http://www.sql-server-helper.com/faq/select-p01.aspx

Refer to the 3rd FAQ question.

SQL Server Helper
How well...
Forum: SQL Server 2000 April 30th, 2007, 09:06 AM
Replies: 10
Views: 14,938
Posted By sshelper
Here's a couple of links that may help you: ...

Here's a couple of links that may help you:

http://www.sql-server-helper.com/functions/get-date-only.aspx
http://www.sql-server-helper.com/tips/date-formats.aspx

SQL Server Helper
How well do...
Showing results 1 to 25 of 72

 


All times are GMT -4. The time now is 05:45 AM.


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