Viewing 15 posts - 121 through 135 (of 250 total)
Thank you for your help. I will pursue the correlated sub-query idea. If I run into problems with it, I'll pursue 'plan b', and may post again.
CSDunn
October 14, 2006 at 1:50 am
more detail;
I have a Proc that contains a parameter called @AcctCodeValue varchar(1000). The user can provide one value or a comma delimited string of values to this parameter. One of...
October 13, 2006 at 3:20 pm
Thanks, I'll do that. What if I wanted to set up a UDF that would take a table field name as its parameter, and return the table field needed in...
September 15, 2006 at 11:37 am
Thank you for your help. I had thought about this approach, and will look into it further.
CSDunn
September 15, 2006 at 7:28 am
GP,
Do you have any recommendations for books on relation algebra? I'll look into what Chris Date has written.
Thanks again!
CSDunn
September 8, 2006 at 7:43 am
The tables and fields that form the query are as follows;
Table EOMVisaMC
[Name] nvarchar(30) NULL,
September 7, 2006 at 8:52 am
Thanks for the repsonses. I will post schema and sample data shortly.
CSDunn
September 7, 2006 at 7:42 am
Thank you for your help. I will check into this.
CSDunn
August 31, 2006 at 3:30 pm
Thank you for your help. Yes, I've heard that SELECT * is a sin, but this is not for production.
I just modified my first attempt, and now it looks like...
August 31, 2006 at 11:57 am
Okay, I can see how to use the function;
SELECT dbo.fn_split(@BillingTypeString,',')
But how do I join to the table that it creates?
August 17, 2006 at 12:54 pm
Viewing 15 posts - 121 through 135 (of 250 total)