2004-10-06
SQL Server Agent
RE: DTS and Output from contained Stored Procedure
sorry, but I should have also asked you what version of SQL Server you are using.
2004-09-03
RE: count(*) problem
Syntax Error, Not surprising 😉One way:select vcFname, x.cnt from ( select fk_intprojectID, count(*) as cnt from tbl_ProjectsResearchers PR group by fk_intprojectID ) as x join tbl_Projects on x.fk_intprojectID = pk_intProjectID where x.cnt > 0Also the x > 0 implies that you want to retrieve the vcFname for projects that have researchers, correct ? If so: […]
2004-05-12
RE: Conditions for return codes
Here is the whole script for what will be the calling procedure. Area of interest is in red. This might clear things up so I cn get a reply.DECLARE @counter INT DECLARE @int_sche_id INT DECLARE @Count_Total INT DECLARE @srch_id INT Declare @cscd_srch_string varchar(500) DECLARE @vchSQLStmt varchar(1000) DECLARE @intRetVal INT Select @counter = 0 SELECT @srch_id = MIN(sa.srea_srch_id) From srch_elmt_assoc sa Join […]
2004-05-04
RE: Datetime grouping question
Hello Dana.Unfortunately at times naming conventions are out of our hands.In this case this database is for the Cisco VOIP phone system and we cannot change any field names.But to answer your question it does pass the syntax check.For anyone else having the same problem this is what I used for the grouping.For grouping by […]
2004-04-16
SQL Server 2000 Reporting Services
Hi,I was wondering if anyone that is using the Reporting Services for SQL Server 2000 has seen any performance issues. Please let me know 1) How many users 2) Type of Report (Financial, Bill Of Material.. ect) Thank you very much for any info that you can give me on this William O'Malley
2004-02-27
RE: what is PKM in SQl Server ?
OK, I'll bite! How about:Primary Key ManagerPortable Key ManipulatorPackage Kernel MandatePeak keyset marshalingSorry, I don't know, where do you see "PKM" in regards to sql server?
2004-02-15
RE: Contest 200401 - Try SQLCompare from Red Gate
If the contest is still on why does the email address no longer work?Hi. This is the qmail-send program at lance.cordhosting.com.I'm afraid I wasn't able to deliver your message to the following addresses.This is a permanent error; I've given up. Sorry it didn't work out.<contest200401@sqlservercentral.com>:This address no longer accepts mail.
2004-02-13
2004-01-29
1 reads
RE: installing SQL server
It sounds like you've installed the software which is a good step. The sql query you have above will run on a database called "RecipesExample" and a table called "ingredients". In Sql server, you can have many databases. In each database, you can have many tables. In your tutorial/book/class documentation or notes, were there instructions […]
2004-01-20
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers