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...

After some digging it appears that the version is 2003 for enterprise architects, Microsoft just relabeled it to 2005. I know how to keep my model up-to-date with updating from the server. The problem is that I want to track changes made every time I update it. Does Visio have a system that...

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...

here is my idea create table #results ( item varchar(50)) insert into #results {call RefSearchHeader ('12345,12545')} declare @v varchar(8000) @r varchar(8000) set @v= '' DECLARE list CURSOR FAST_FORWARD FOR SELECT item FROM #results OPEN list FETCH NEXT FROM list INTO @r WHILE...

well in the last conversion that i did i actualy used a comand line text replacment tool to do the job. I had to export the file from an old system, clean the file, then import it into our new system. As for your specif task I think that an active x script will do they arnt that hard to write.

sorry it took me a mint to find the comand DTSDestination("SBR-ORIG-AMT") = CDbl(DTSSource("Col029") this is an active x script not sql code so you have to use that lanuge

not real sure if this helps but in EM when I select properties on the server under the server setings i can change the language to british english.

if you are using the dts wizard i belive that it only smples like the first 200 rows when it does the transformation templet. use the wizard an when you get to the transform check your column mapping to make sure that it is not ignored. look at that and let us know

something like this should work declare @begindate datetime, @enddate datetime select @begindate = '5/1/2005', @enddate = '5/1/2010' create table #workweek( begindate datetime,enddate datetime) -- only need if it is not set to 7 SET DATEFIRST 7 -- create that nasty table insert...

are you using QA if you are check the tools->options-Connection property tab see if set rowcount is set to anything other than 0

As a test open your excel file and select the first blank row and all the rows after and delete them using the delete in the edit menu(do not just use the delete key). Then try to import them.

sorry im im in the middle of a project right now perhaps this will work SELECT products.productName, emailAddress, (SELECT MAX(datemodified) from userhist b where statusid in(3,2) and b.userid = a.userid and eventid = 1) as datemod , users.userid, eventid, statusid FROM products, userhist a...

I'm so sorry I misread your post. you can delete the not in the last where clause. see how that works. sorry bout that

from a quick glance you are not limiting yor userideas like in the first query SELECT products.productName, emailAddress, (SELECT MAX(datemodified) from userhist b where statusid in(3,2) and b.userid = a.userid and eventid = 1) as datemod, users.userid, eventid, statusid FROM products...

I see 2 items DECLARE @SQL NVARCHAR(2000) DECLARE @DB NVARCHAR(20) DECLARE @EMPLOYID NVARCHAR(20) SET @DB = 'AA' SET @EMPLOYID = '0101' SET @SQL = 'UPDATE #T1 A, '+@DB+'.DBO.UPR00102 B SET A.ADDRESS1 = B.ADDRESS1, A.ADDRESS2 = B.ADDRESS2, A.ADDRESS3 = B.ADDRESS3, A.CITY = B.CITY...

iknow this is stupid but some time si have problems if my if are not enclosed try if (@@ROWCOUNT = 0)