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 38
Search took 0.01 seconds.
Search: Posts Made By: gregalb
Forum: SQL Server 2005 September 8th, 2009, 10:53 PM
Replies: 5
Views: 1,283
Posted By gregalb
Thanks for the reply. The field is CHAR. Thanks

Thanks for the reply. The field is CHAR.
Thanks
Forum: SQL Server 2005 September 8th, 2009, 08:01 PM
Replies: 5
Views: 1,283
Posted By gregalb
Add Left Padding

Hi,

I would like to kbnow how to update a field to add a left padding of 5 spaces. I have a column with numbers in it eg:

F1

2345
1256
1569
Forum: SharePoint Development September 2nd, 2009, 09:51 PM
Replies: 0
Views: 1,268
Posted By gregalb
File Tracking System

Hi,

I would like to use MOSS 2007 to track folders (file tracking system). I have created a site and a list with approximately 106000 entries. I have setup views etc and it all works - however the...
Forum: SQL Server 2005 May 19th, 2009, 05:56 PM
Replies: 4
Views: 1,130
Posted By gregalb
Hi, This is correct. I am trying to extract where...

Hi, This is correct. I am trying to extract where the owner and the occupier are different and enup with more than one row and I only want to end up with one line - it could be a data problem - not...
Forum: SQL Server 2005 May 19th, 2009, 05:31 PM
Replies: 4
Views: 1,130
Posted By gregalb
Select Distinct Query

Hi There

I have the following query:

SELECTdistinct
cast(RT_VALUATION.RT_VAL_ID1 as varchar) RT_VAL_ID1,
cast(RT_VALUATION.RT_VAL_ID2 as varchar) RT_VAL_ID2 ,
cast(RT_VALUATION.RT_VAL_ID3...
Forum: SQL Server 2005 March 11th, 2009, 11:16 PM
Replies: 2
Views: 899
Posted By gregalb
Delete Duplicate Rows

Hi There

I would like to know hoe to delete duplicate rows from a table eg

col1 col2 col3 col4 col5 col6 col7
HP 1 1 OCCUPIED 3 A CASKET
HP 1 1 OCCUPIED 3 B CASKET
HP 1 1 OCCUPIED 3 B...
Forum: Reporting Services August 24th, 2008, 05:39 PM
Replies: 0
Views: 1,334
Posted By gregalb
Move SSRS 2000 to New Server

Hi,

I would like to move my SSRS 2000 to a new server (new name) for the purpose of upgrading to 2005.
Can anyone tell me the stepa required to do this?

Thanks

Greg
Forum: Reporting Services May 27th, 2008, 11:01 PM
Replies: 1
Views: 1,819
Posted By gregalb
Arithmetic overflow error

HI

I have a dataset that has a date paramater @Datfrom and @Dateto. When I run the query from the data tab view it works but when I try and preview the report i get the error:

An error has...
Forum: SQL Server 2005 May 15th, 2008, 05:45 PM
Replies: 3
Views: 1,176
Posted By gregalb
Hey Peter, Sorry to reply so late but I've...

Hey Peter,

Sorry to reply so late but I've been away on course and a bit of leave.
There are three tel no's for each contact but sometimes there are more than one no for a type - sy day_phone. so...
Forum: SQL Server 2000 May 15th, 2008, 05:21 PM
Replies: 1
Views: 2,448
Posted By gregalb
Coalesce and replace function

hi there
I am trying to use the coalsce and replace function to extract thre fields into one (address) but am a little stuck.
This is my query but I keep getting an error when trying to pars it.
...
Forum: SQL Server 2005 May 5th, 2008, 03:53 PM
Replies: 3
Views: 1,176
Posted By gregalb
Select Statement

Hi There

I have a table that contains contact No's (telephone) for dog owners.
A dog owner can have more than one contact no (obviousley). The table fields are:

contact_dialler_1,...
Forum: Reporting Services January 14th, 2008, 11:17 PM
Replies: 1
Views: 922
Posted By gregalb
Help with date paramater

HI

I am trying to setup a date paramater in my report. I would like a user to be able to select a from and to date.
I have a main dataset and then another one for the date selection however when...
Forum: SQL Server 2000 January 14th, 2008, 03:51 PM
Replies: 3
Views: 1,200
Posted By gregalb
Thanks urt this has worked nicely.I have another...

Thanks urt this has worked nicely.I have another sinario. I would like to add a field based on the value of another. The field that I would like to creat is not held in the DB. essentially this is...
Forum: SQL Server 2000 January 9th, 2008, 08:27 PM
Replies: 3
Views: 1,200
Posted By gregalb
select Statement

HI,
I have a table that holds printing information (clientcode, Username, PapaerSize, Pages, DatePrinted).I would like to sumerise it as follows:
Client Code Username A4 Total Letter...
Forum: SQL Server 2000 November 15th, 2007, 10:56 PM
Replies: 2
Views: 1,005
Posted By gregalb
Thanks Peso I am using this in SSRS 2000 and...

Thanks Peso

I am using this in SSRS 2000 and want the "DatePrinted" to be (Year) as a parameter. I have written the following script and it gives me totals for December while December should be...
Forum: SQL Server 2000 November 13th, 2007, 04:43 PM
Replies: 2
Views: 1,005
Posted By gregalb
Select Query

I have a table that has - Printer, DatePrinted and Cost.

I would like to select the printer name and the total for each month and display the results as follows:

Printer Jan Feb ...
Forum: Reporting Services October 17th, 2007, 06:00 PM
Replies: 0
Views: 744
Posted By gregalb
RS 2000

I would like to know how to query a sharepoint list using vs 2003 ans wss v2.

Thanks

Greg
Forum: SQL Server 2000 August 29th, 2007, 04:00 PM
Replies: 1
Views: 1,027
Posted By gregalb
Help with cursor statement

HI

I have a database that holds dog data information. One of the tables is a textnote table that holds free text pertaining to a dog. the table has the followig fields - dog_id, text_id, seq_no...
Forum: Reporting Services July 23rd, 2007, 05:14 PM
Replies: 0
Views: 730
Posted By gregalb
Printing a Report

Hi

When I print a report directly from RS (by just clicking the printer icon) The report prints out with a background (black) where there are letters. If I export the report to say an acrobat...
Forum: SQL Server 2000 July 11th, 2007, 04:38 PM
Replies: 6
Views: 1,204
Posted By gregalb
Thank vijay I would like to update my table...

Thank vijay

I would like to update my table not just select from it

Thanks
Greg
Forum: SQL Server 2000 July 11th, 2007, 03:42 AM
Replies: 6
Views: 1,204
Posted By gregalb
Hi Vijay Yes the first segment will be 5...

Hi Vijay

Yes the first segment will be 5 (char) in length for all rows
Forum: SQL Server 2000 July 10th, 2007, 10:45 PM
Replies: 6
Views: 1,204
Posted By gregalb
Replace character

Hi I have data in a field

38307*412*11*
38703*412*11*A*
38703*412*11*AA*

I would like to remove the first * and replace the rest of the * with . and have no * at the end - how can I achieve...
Forum: SQL Server 2000 July 10th, 2007, 10:40 PM
Replies: 3
Views: 946
Posted By gregalb
Guys don't worry I figured it out

Guys don't worry I figured it out
Forum: SQL Server 2000 July 10th, 2007, 04:12 AM
Replies: 3
Views: 946
Posted By gregalb
Monitor disk space

Hi

I would like to be able to monitor the disk space on my SQL server. My server has four disks. I wold like to use a SP and be notified using xp_smtp_mail.
Can someone point me in the right...
Forum: SQL Server 2000 June 24th, 2007, 04:06 PM
Replies: 2
Views: 905
Posted By gregalb
concatenationg text fields into one line

Hi There

I want to concatenate some free text into one line. What it is, is that for every property id that i have there is a text field per line so that means that a property can have more that...
Showing results 1 to 25 of 38

 


All times are GMT -4. The time now is 01:28 PM.


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