But why do you want to create the temp table in two steps, is there any specific reason, you can as well create it with the CREATE table #mytable (column1 datatype ) syntax directly right? Sorry if I am missing anything here. Well if you are passing the table structure as input parameter to the […]
2004-03-16
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
1 reads
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
Hi All, We program intensively in TSQL / stored Procedure, many business logic is in there. And I need to distribute the jobs to some SQL programmers. Is there any documentation tool that can properly / precisely dedscribe the flow of TSQL programs / stored procs ? Thanks for any help, Krist
2004-03-13
1 reads
SELECT YearNumber, MonthNumber, SUM(Occurances) AS CountOfData FROM (select YEAR(DateField) AS YearNumber, MONTH(DateField) AS MonthNumber, Count(datacount) As Occurances FROM datatable GROUP BY SQLDate)Dates GROUP BY YearNumber, MonthNumber Order By YearNumber, MonthNumber This should give you what you are looking for.
2004-03-11
Oops! ...but that analyzer is not bad at all. It doesn't hurt to reference it twice
2004-02-27
Just looking for others who have had to implement field level encryption their databases. A. What program/utility did you decide on? We have been looking at dbEncrypt from Appsec Inc. B. What performance impact did you encounter? C. Did you have to re-write many of the stored-procs? D. What processes also had to change like […]
2004-02-24
4 reads
While the answer of using the -e startup parameter is correct, it is only temporary. If you want to permanently move the errorlog, I thought you needed to change it in the registry. Am I not correct?
2004-02-24
This is all set now. It was timing out when trying to log on to a linked server using an outdated password. I updated the password in the linked server's properties and it is working now. Thanks for the reply.
2004-02-24
How much memory are being used by SQL Server instances? Can you post the result of "select * from sysprocesses where waittime > 0 order by waittime desc"? If there are any queries running, verify whether they are running in parallel.
2004-02-19
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