RE: Create DB Users for New Databases
Thank you very much for the input. Any suggestions on how to automate the process of adding hundreds of users? Thanks again. WM
2003-06-19
Thank you very much for the input. Any suggestions on how to automate the process of adding hundreds of users? Thanks again. WM
2003-06-19
This is not what the poster is asking for. They are requesting that in the same query, return both scalar and non-scalar aggregates, ie count of all and also count of a single group, and given the format the poster wanted (repeating the scalar aggregate in each row), none of the solutions presented so far […]
2003-06-19
You need to use a CASE statment instead of WHERE clause to restrict the values going into the aggregate. The code below assumes that you can't have negative values in dbo.Defect_Data.SUMDEFECTS. So you don't need to restrict the input to the SUM. If you did, you would use a CASE statement as with QDefectCount, but […]
2003-06-19
Hi eletuw, I get this running when I remove the LOCAL FAST FORWARD option. Hm, now I only need to figure out, what this is doing? Cheers, Frank
2003-06-18
I made the chnages but still got the error. I am psoting the entire query in cae it might help. ========================================== DECLARE @ID INT DECLARE @Name varchar(200) DECLARE @Text nVarchar(2000) DECLARE @cDate datetime DECLARE @ColID int DECLARE @Type varchar(10) -- Declare the cursor DECLARE CURSOR_OBJ CURSOR LOCAL FAST_FORWARD FOR SELECT TOP 100 PERCENT dbo.sysobjects.id, dbo.sysobjects.name, […]
2003-06-18
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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