Recent content by TheJFM

I'll try this today sirwally - you are a star! ** Don't reach for the moon when you have the stars. TheJFM **

Thanks very much I feared that might be the case. I was wondering if I could create an XML output that would give me what I need? And in views for quick checks I guess it's a series of specific views - huh? ** Don't reach for the moon when you have the stars. ** TheJFM **

Hi I would use a view if I know the parameter to be passed will not change even if the underlying date will change frequently. i.e. if you always want the result to reflect vehicle_type of 1 If, however, the parameter will change then I would use an sp. i.e. if I want to know the results for...

Michael, The choice between sp and view depends on how you plan to use the info. Either is valid depending on circumstances ** Don't reach for the moon when you have the stars. ;-) TheJFM **

What the OP is referring to is not a parameterised query. It is a simple view over a table whose content is changing. I agree the select * is not good syntax but not the root of the problem. There is no reason at all why a query on the view should not reflect changes to the underlying data. As...

Hi What do you mean by the vehicle_type table? Does the vehicles table reference it? ** Don't reach for the moon when you have the stars. ;-) TheJFM **

Hi all, Here's the problem. I have added a descriptive extended property to all objects database, schema, table, index, column etc. I want to create an output (preferably web, but a sql view would be useful too) that will read the property name and value and group hierarchically. i.e. in the...

You can get the transformations to reset themselves in line with source and target. Take a look here and it might give you some helpful tips to progress this http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspcoll_7g6m.asp ** Don't reach for the moon when you have...

Hi, I have a situation where financial information in the source system can be amended or reversed. All records are passed to the DW with each transaction being a fact in the Tran_mvmt table Dimensions include customer, agent etc with all dimensions being Type 2 with begin and end date I...

Hi, I have table A with an field (int) that hold values equating to dates. e.g. 21456 21457 To get date values this is joined to table B 21465 2004-02-01 21457 2004-02-02 I need to update the field in table A so that the numeric value is equal to the date + 12 months. How can I do...

Hi all I am querying a view (on a Sybase server) through a sql DTS. One of the fields returned is a numeric field. Some of the records return 0 even though there is a value in the field. When viewed through the DTS query builder preview a – is returned. If I add convert function to varchar...

Thnx ** Don't reach for the moon when you have the stars. ;-) TheJFM **

Hi Would SQL 2000 see the drive if I added a LACIE USB hard drive on the server and would I be able to create a DB on it? Thansk ** Don't reach for the moon when you have the stars. ;-) TheJFM **

Thanks!! ** Don't reach for the moon when you have the stars. ;-) TheJFM **

Hi I know I should know this but ... how do I get the number of rows per table back quickly from a database? Ta ** Don't reach for the moon when you have the stars. ;-) TheJFM **