Search results for query: *

This has been asked before but unfortunately that solution did not work for me. I and looking for the ADP data dictionaries and I understand that they are installed with the software however I am not at the property that has the software and they are not intelligent enough to get me what I need...

Hi all been a while since i have posted. I have this trigger that is killing me. here is some back ground info. CREATE TABLE #Png ( [RId] [int] NOT NULL, [RType] [char](3) NOT NULL, [SysCode] [varchar](7) NOT NULL, [Idnumber] [int] NOT NULL, [Date] [datetime] NOT NULL, [TypeAPoints] [int]...

Hi all, I’m new to xml and xslt. I’m more a SQL /vc6/c# kind of a guy. I’m working on displaying an xml file that has nested nodes. I have figured a few things out but I am now having trouble with templates. They make since but I don’t understand how to assignee the out put of one to a...

Hi all, I just began using Visio and I am using the 2005 enterprise architects version. It seems to have a lot of bugs but its forward engineering ability is nice. My question is there a way to track changes between updates? For example I have a db that I modify on the server that I keep a...

Hi all, I don’t normally post over here it’s not my dep, but you can find me often on the SQL boards. Anyways I have a question. My company formerly supported Corel suite. Management has since decided that we would go with the Microsoft office suite. It has fallen to us to get the users to...

Hi all, I have some questions and a scenario that I need some help understanding. I have several tables that are continuously updated by several interfaces. I need to lock those tables then perform several tractions without the triggers firing. Here is the code I am about to use. ….. BEGIN...

Ok here is one for you How do you use a variable in an IDENTITY function? Example declare @stuff int set @stuff = (select min(somevalue) from sometable ) select idnumber as idnumber, amount as amount, IDENTITY(int,@stuff,1) into thattable from someothertable

Hi all, Got a question. I have a table I am trying to group and the group needs to be groups of incremental dates. I know I have seen threads about this before but now I can not find them and I can not think of how to do this simply. Let’s get some sample data: date amount 5/1/2005 10...

Can you execute a sp in a select statement? Like… select * from ( sp_whatever 3456) as XX

Ok I have a huge problem now. I need to retrieve all errors and messages from a job that ran and failed. In viewing it in job history the small description box cuts off the message in it. I don’t have sp_help_job…. anything and I’m not sure that they would have helped me anyway. I’m looking...

Hi all. I have a problem and solution and I wanted everyone’s opinion on it. My problem I writing a sp to merger accounts. It combined basically everything. In testing I have discovered that in some cases there is only one row for tables that have triggers that cascade across tables that I...

Hi all are you ready for some of the ugliest code that you have ever seen? I need to re write this code but I can not figure out how to do it. Originally this code was just used so I could move on and finish the rest of the sp and now I optimizing it. Thank you for any suggestions and help...

Hi all, it is question time. I need to change the order in which services shutdown in several different OS mainly server 2000. does anyone know any thing about this. I have searched and found how to get the services to start in a specific order which by the way a nightmare in reg editing but I...

Hi all, I’ve a Question. I have a large app that is not very user friendly and I need to write a program that will take control of a specific form and enter data into it. We bought the crap software and are not able to write our own version of it due to legal restrictions. All I want to do is...

Hi all, got another question. I have a table that has a row idnumber that can not be null and contains an int between 1 and 500000 and I need to find the missing numbers. Like I have row 1 and 2 but there is no row 3. I had an idea but then I do not believe it is on the right track. select *...

Hi all hate to repeat myself but the DTS package thread is really quiet. I’ve got this DTS package acting up that does not make sense. Here is the link to my other post. http://www.tek-tips.com/viewthread.cfm?qid=999727&page=1 It is acting like the statements in an SQL Task in a DTS package...

Hi all, got a stupid question here that I want to confirm the answer to. In a DTS package, inside of an SQL Task if there are multiple queries does server try to execute them concurrently? I was informed that id tries unless you put a go after each query. Thanks for your answers.

Hi all. I have a few questions about what server 2003 can do and if it helps my situation. I have a small network (between 10 & 15 computers) at home & my friend’s house. Currently out network is broke apart with ½ on the DSL internet side and the other ½ on the Cable internet side. An associate...

Hi all it is question time. If you can not guess I am not a very good programmer. But I usually can find what I need. This one has got me stumped. I have a program that has 6 views that all have the same variable recordset I need to from the main frame gain access to a member of that...

Hi all. This is my first time posting on this board I’m usually on the SQL, VC++, or crystal boards. I have a small home network (10-15 computers). It is connected to my friend’s house via buried copper. We just got a cable internet connection. We already had a DSL connection. Ready for my...