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.
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...
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...
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...
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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.