Search results for query: *

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 **

We guessing at a data store of up to 100 GB with a daily update of 3 GB (data growth will be less) Thanks ** Don't reach for the moon when you have the stars. ;-) TheJFM **

I am rebuilding 2 SQL servers to their new spec. 250GB Raid 0. I am in a dilemma over the best configuration. Do I put tempdb in one partition? How much space do I allocate? Do I put data, logs and indexes in separate partitions? If so what would be the optimum ratio of space 1:2:1 ? Here I...

Thanks The problem is that the data comes into Sybase on an adhoc basis. When it arrives the Sybase guys push it to us. I want our trigger to fire when and if the data arrives. I really didn't want to give the access to run an sp on our servers but I may have no choice. ** Don't reach for the...

Thanks James Unfortunately our Sybase deveoper on Unix has informed me that their BCP does not support hints. Any othjer ideas? Thanks ** Don't reach for the moon when you have the stars. ;-) TheJFM **

Hi I have an after insert trigger on a table. It fires on a table to table insert. However an insert by bcp from a sysbase server fails to fire the trigger. Any ideas people? ** Don't reach for the moon when you have the stars. ;-) TheJFM **