I think I got it... Select Coalesce(a.ryear,b.ryear,c.ryear) as rYear, a.rvalue as 'ValueOfSubID1', b.rvalue as 'ValueOfSubID2', c.rvalue as 'ValueOfSubID3' FROM (Select * From MyTable WHERE ID = 1 and SubID = 2) a FULL OUTER JOIN (Select * From MyTable WHERE ID = 1 and SubID = 1) b On a.rYear = b.rYear and a.ID = […]
2003-07-22
1 reads
Did you transfer any data recently into your prod from some other server? If yes make sure you check the proper check box. It will ask you drop and re create the objects.
2003-07-08
How about a startup proc to create an entry in a table with a start_column = getdate() and with a sheduled job running every 5 min updating the last row, setting its enddate column to getdate(). Can also check if some databases are accessible. Next the rules when database not accessible
2003-07-08
1 reads
It would be helpfull for us to see the code from the begining. However I suggest stepping thru the code in debug back several positions to see what is happening. Also may do a write to the debug screen or to a text file the values of all the variables that are used. I would […]
2003-06-30
quote: What should this look like when its installed and setup? (instances installed, etc) Each node will have two services for MSSQLSERVER, one with that name (as the default instance) and one with MSSQL$[instance name]. There will also be two services installed for the SQL Agent (SQLSERVERAGENT - default and SQLAgent$[instance name]). When you install […]
2003-06-25
you can try using Image data typ. check BOL for image data type.
2003-06-21
I also do this I use the commands (in the relevant place) : objFSO.CopyFile "src-Path\filename", destination-Path\filename",true [where last boolean is for overwrite option] and use the same folder and then objFSO.DeleteFile "Path\FileName" to delete the original. Hope this helps. Andy P quote: Andy, I just incorporated that code into a package and it worked like […]
2003-06-06
1 reads
I don't think there's a hard and fast rule on this question. Some store the repository in the msdb database and an argument could be made that this is reasonable given the nature of the meta-data being stored. An equally reasonalbe argument could be made to create a seperate database for the repository. This offers […]
2003-05-26
When in doubt, check Books Online. Quoting: quote: Before you start the Migrate Repository Wizard, create or identify the SQL Server database to which you want to migrate the Analysis Services repository. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agregserver_23hv.asp K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-05-22
A friend of mine uses NTMail from Gordano. Also, there are sendmail variants for Windows out there. It's open source, but can be a real bear to configure and secure. And I do mean bear. As in large grizzly with Sabertooth Tiger teeth. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server […]
2003-05-15
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