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

...of 1 If, however, the parameter will change then I would use an sp. i.e. if I want to know the results for a number of vehicle types (say one day type 1 and another day type 3) or the vehicle type meaning might change ** Don't reach for the moon when you have the stars. ;-) TheJFM **

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

...you click on DatabaseName it expands into: SchemaName1 SchemaName2 If you then click on SchemaName1 it expands into the level 1 objects associated with that schema And onwards throughout the hierarchy? Any help appreciated ** Don't reach for the moon when you have the stars. ;-) TheJFM **

...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 the stars. ;-) TheJFM **

...sum(a.Tran_Val) ,b.agent_name from Tran_mvmt a inner join dim_agent b on a.agent_id = b.agent_id where @Range_Date between a.Begin_Date and a.End_Date group by b.agent_name Is this the right way to go? ** Don't reach for the moon when you have the stars. ;-) TheJFM **

...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 this in a single update? Thanks ** Don't reach for the moon when you have the stars. ;-) TheJFM **

...If I add convert function to varchar all the fields return a value. When I query the same view through DBArtisan or in Access the true value is returned for all fields with no need to convert. What is going on? Thanks ** Don't reach for the moon when you have the stars. ;-) TheJFM **

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

...it all in one partition and maximise the disc space. Will I pay heavily in performance? The servers will be read only by day – running queries, mostly in pre-aggregated tables. A large single load and update at night. Thanks ** Don't reach for the moon when you have the stars. ;-) TheJFM **

...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 moon when you have the stars. ;-) TheJFM **

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