i would like to create a temp table and insert values into the temp table in a store procedure, is it possible?, i have tried it as follows create procedure mype as DECLARE @a varchar(100) set @a= 'create table #mytable ( itemcode varchar(15), itemname varchar(50), unitname varchar(15), unitprice money […]
2004-03-16
3 reads
That is the solution I have implemented. Thanks. From a curious stand point, I would still like to know if there is a rename command for VB Script to do this. Any one know? Robert W. Marda SQL Programmer bigdough.com The world’s leading capital markets contact database and software platform.
2003-12-22
1 reads
Hi, I found that using the following in the calculated cell works very well: ([Report Section].[Module].&[CASHFLOW], [Measures].[Amt],parallelperiod(month)) Parallelperiod finds the current member of the time dimension, and in this case (month) looks at the previous month dimension / measure. Regards, Andre
2003-12-12
1 reads
To ease coding it: select '[' + object_name(id) + '].[' + name + '] ,' from syscolumns where id = object_id('tablename') order by colid Copy and paste the result, remove the columns you don't want. Takes just slightly longer than using select *, and has the advantage of being modifiable so you can use it […]
2003-11-21
Also make sure all the resources that belong to sql are in the sql cluster group i.e. disk or services that may not have been included. Wes
2003-11-18
2003-07-30
1 reads
is it possible to reconfigure SQL server to work disconnected from the network I am using ASP & IIS 5.0 to generate web pages with data from SQL Server and i want to be able to view them on the same machine as i am developing at home.
2003-07-08
If data does not exist in both tables on [year_month] basis you can avoid the outer-grouping from jpipes solution. btw could you give a litle feedback on the percentage of cpu- and elaps-time you managed to save ?
2003-06-19
1 reads
Apart from the 1 line BOL and MSDN dedicate to it, I can find very little. I can only assume that if it's high and the server is processing thing acceptably then the high figure is a slow network and/or slow client.
2003-06-10
Do you want to replicate the schema or the execution of the stored procedures?
2003-06-10
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers