Thanks for your info. By the way, to fix the public execute permission, I copied an existing script in this site, and modified it: declare @procname varchar(100), @command varchar(100) declare Crs insensitive cursor for select name as ProcName from sysobjects where type = 'P' order by name for read only open Crs fetch next from […]
2003-06-19
Another way would be to use the OR method (Better name?) Select * From xx Where (Col1 = @param1 OR @Param1 Is Null) and (Col2 = @param2 OR @Param2 Is Null) If any of the params are not supplied, they are null so the statement is still true. There was another thread a week or […]
2003-06-17
Hmm. Maybe i have to learn dynamic sql at some point...But would it be possible to add some kind of "flag" that says whether the user is interested in the specific criteria or not (e.g 1 if yes, 0 if no), and then in the where clause use only those criteria whose flag says 1??? […]
2003-06-17
1 reads
Who owns the package, if its different from the owner its saves it as the new user.package name.
2003-06-13
You can use the following query. SELECT t1.bal_date, (SELECT sum(income - outcome) FROM your_table t2 WHERE t2.bal_date <= t1.bal_date) FROM your_table t1
2003-06-12
1 reads
Hello NPeeters, quote: 1. Problem solver. Anyone can code something, but it starts to get difficult when you're debugging. Seen a lot of good coders fail completely when they encountered an issue somewhere. They either did not know how/where to start looking or they just gave up and marked the bug as 'hidden feature'... 2. […]
2003-06-11
Hello sbuckby, quote: We had exactly this same problem. Our client provides a work order system that we HAVE to use. We can extract a CSV from it. We use some VB to parse the records on the way. The client system has some field rules that don't fit our field rules ALL of the […]
2003-06-11
1 reads
Hi John, quote: problem of 'updates'. I want to somehow know when a row has been updated. I've been reading about triggers, timestamp (rowversion), programmactically set a flag, etc and at this point I would appreciate some guidance. I'm not sure in which direction the guidance should go. If you want to know how to […]
2003-05-26
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