Steve,I have been using SQLServerCental.com for many years and recently rejoined when I moved to a new job. From the outset your site has impressed me with its content and quality of its memebers. This is a site I am proud to be a member of and one I am proud to promote to all I […]
2004-12-06
I tried to disable the firewall, but it did not work the same!
2004-11-19
One alternative:select x.id, min(x.ordr) ordr, min(x.vin) vin, min(x.vout) vout, sum(y.vin-y.vout) sldo from yourtable x cross join yourtable y where x.ordr>=y.ordr group by x.id order by min(x.ordr)Can't remember of the top of my head how this will compare performancewise to the above suggestions, but I'm sure all 3 options suggested so far will vary in comparison […]
2004-11-19
Hi Dave!I am a newbie when it comes to SQL, sorry for inconvienience, your answer worked perfectly, but I meant to say minutesWith your above answer, can you change that to return MINUTES instead of hours and exclude holidays that are in TableA . Lets say TableA hasHolidayDate 2004-08-09 00:00:00.000 2004-09-24 00:00:00.000 2004-12-16 00:00:00.000 2004-12-26 00:00:00.000 […]
2004-11-15
1 reads
I am NOT an expert.But you can try this.1. Do a transaction backup.2. Then do a restore of your database to the date that you want to roll back.3. Backup or copy out your database.4. Restore your database back to today.5. Delete all records.6. Copy back from your backup (from step 3)This will not work […]
2004-11-08
When configuring replication, what permissions are needed by SQL Server to connect to a subscriber? I ask because our replication was configured using SA to connect to the subscriber. I would like to limit permissions to what is needed by replication to perform its work and am guessing that dbo or possibly the combination of […]
2004-11-02
3 reads
I am running some DB maintenance plans and they are failing and I am getting a error message in sql server error log "Login failed for USER NT AUTHORITY/SYSTEM"What is or who is NT AUTHORITY/SYSTEM?Taj
2004-11-02
3 reads
- Trust me -CA-ERwin is NOT THE TOOL for youWhen LogicWorks owned the product, it was dynamite. When Platinum took over, it was still a good tool. CA has made every effort to kill the product's reputation - very successfully, I might add.We still use it, but there are so may bugs in it that […]
2004-11-02
Yes, but:declare @a varchar(1000) select @a = ISNULL( @a, '' ) + CONVERT(VARCHAR(10),id ) + ',' FROM sysobjects ORDER BY idSELECT @a Works. That is, with no calc in the order by it concatenates all rows.
2004-10-19
How do you set a varbinary number ie 0 to a varbinary field in a DTS using Active X VBScript? Any help will be greatly appreciated
2004-10-19
1 reads
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