Recent content by nbrk

Kurt thanks for your input Nbrk

Kurt, Thanks for the bad news. There has to be some kind of tool out there that interfaces entrprise to a version manager. Surely?? Nbrk

Sorry to say but we have Crystal Enterprise..any ideas?

Dave, Thanks for your quick response. Have you heard of an interface into PVCS that integrates into Crystal? Nick

Hi all, Does anyone use a version manager to source control their crystal reports? If so, how? I have heard through the grapevine that there is a 3rd party solution for versioning crytal reports...any one else heard of this? Thanks in advance

You are either going to have to use the "-c" option or create a format file. Good luck nberk

I have one question, why would you want to store decrypted passwords in the database? I have seen it done where the client application encrypts the password (through an API call) and then passes the encrypted password to the database that does a compare on the encrypted data for the match...

obviously vharchar is varchar......

Try this, remember this is a sproc, so create this first create procedure tabcount @tablename vharchar(64) AS select a.name, rowcnt(b.doampg) from sysobjects a, sysindexes b where a.id = b.id and a.name like @tablename after that you can really use this to your adavntage, by executing...

look at: set identity_insert <table_name> on It is in the Transact-SQL volume 1 manual Good Luck

If this is a single select dropdownlistbox then you can use the index... If index = 1 then If multiselect you are going to have to loop through and check the state FOR i = 1 to lb_value.TotalItems() IF lb_value.State(i) = 1 THEN END IF NEXT Good luck

You could try something like this....it may need some tweaking select name, code, start_date, end_date, class from test_table a where class = 'M' and convert(smalldatetime, start_date) < getdate() and not exists (select 1 from test_table b where a.name = b.name and a.code = b.code and...

don't forget you could do this in isql with the -i option

This is pretty crude but you could do this in an ISQL script Label: execute <stored procedure> waitfor delay &quot;01:00:00&quot; goto Label As I said this is pretty basic...hope it helps a little Good Luck

Ok, I am a little unsure of exactly you want...would the &quot;waitfor&quot; SQL statement be the kind of thing you are looking for? Good Luck