Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sqlserverbest

    Base hardware/software req list for Datawarehouse using sqlserver 2000

    Thanks, I was looking for more like what mrdenny had replied - base but little detail. What about the failover server etc... Any chances I can get an architecture diagram for the whole configuration.
  2. sqlserverbest

    Hardware/Software requirements list

    Thanks, The datasource is going to be just one. It is going to be a incremental load of approx 40MB of data everyday. It is planned to keep the data for not more than 1 year. Users may be between 20-30 concurrent users. Please understand it may not be accurate but can I get some...
  3. sqlserverbest

    Base hardware/software req list for Datawarehouse using sqlserver 2000

    Thanks, The datasource is going to be just one. It is going to be a incremental load of approx 40MB of data everyday. It is planned to keep the data for not more than 1 year. Users may be between 20-30 concurrent users. Please understand it may not be accurate but can I get some...
  4. sqlserverbest

    Base hardware/software req list for Datawarehouse using sqlserver 2000

    Hi, I am looking for base hardware/software list for a datawarehouseing project using Sqlserver 2000. Thanks Anand
  5. sqlserverbest

    GetExecutionErrorInfo routine question

    Variables declared in Activex script are of type varient. If you go through the help from Microsoft GetExecutionErrorInfo needs minimum variables of type long to populate error code, string to populate error source and string to populate error description. So when you are using activex...
  6. sqlserverbest

    Dynamic Select

    I tried this sql query and it said I need to declare @rowcount variable when it is already declare. What is the problem here. DECLARE @sql varchar(1000), @rowccount int SET @sql = 'Select @rc=count(*) From ttg_position_stg' EXECUTE sp_executesql @sql, N'@rc int output', @rc=@rowcount output...
  7. sqlserverbest

    Dynamic Select Statement

    That me again!!! I tried this code making it much simpler and it said I much declare @rowcount variable when it is already declared. DECLARE @sql varchar(1000), @rowccount int SET @sql = 'Select @rc=count(*) From ttg_position_stg' EXECUTE sp_executesql @sql, N'@rc int output', @rc=@rowcount...
  8. sqlserverbest

    Dynamic Select Statement

    How do print the value of variable @totsum declare @totsum money, @sql varchar(1000) set @sql = 'select @totsum = sum(price) from product' execute(@sql) print str(@totsum,15,2) I am getting the message as @totsum not declared. Your help is appreciated.

Part and Inventory Search

Back
Top