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!

Register Log in
  • Congratulations TouchToneTommy 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

    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...
  2. 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
  3. 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...
  4. 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