Recent content by jfcox

I have a table with three columns; column a is an identity column, column b is just an id number, and column c is a date. I have several blanks in the date column and want to replace them with nulls. I tried the following query which fails on a "subquery returned more than 1 row" error and I...

Thanks, but I need date1 to be a real date otherwise it doesn't sort correctly. I also only want it as mm/dd/yyyy. How do I convert what you wrote to a datetime?

I have a column that I need to get into mm/dd/yyyy format I can get it that way as a varchar but converting to a date gives me a problem. I thought it was my data but look at this example, select Convert(varchar,getdate(), 101) as date1, CONVERT(datetime, CONVERT(varchar(8), GETDATE(), 101))...

Interestingly, that doesn't work for me completely; If I go {table.type} in {?type}[1] that works, if I go {table.type} in {?type}[2] that creates an error. The value of that was passed in as Type was: interactive,home So, although there are two (or more) items in my list, it is not...

This ought to be simple but I'm missing something. I have a multiple, distinct parameter called "Type" that I am passing a comma separated list, for example; interactive,selfpaced,home I'd like to use something like this in a record selection formula: {maintable.type} in {?Type} If I...

Wow, thanks a bunch, I would have never come up with this on my own. Jim

That is correct

Obviously, I picked a bad example. Let me try with somthing that might inherently imply the outcome. Suppose I had a table of last_Name, Drivers Lic St., and Drivers License number. If I had data like this: Smith NJ 12345 Smith NY 98755 Jones TN 55554 Jones KY 6879 I'm looking for a...

Yes, they are essentially name-value pairs.

No, that doesn't matter. Thanks

Using the previous example, the result I need should look something like CustNo state1 partno1 state2 partno 2 1 NJ 60 NY 50 2 TN 30 KY 45 The state might be repeated but with a different PartNo. Technically, there can be unlimited numbers of...

I have a typical table that looks something like CustNo State PartNo 1 NJ 60 1 NY 50 2 TN 30 2 KY 45 The CustNo column is not unique but is the key. I need to create a single row on a spreadsheet or flat file that looks like this CustNo...

Hi, I'm running Crystal Enterprise at the momemnt but hate it. How does Reporting Services compare in terms of report design and deployment?

Thanks for all your suggestions as I tried them all. It still doesn't work and I get an error 'Error converting data to datetime' I think maybe Esquared's suggestion that I'm missing leading zeros might be valid. To be a little clearer than my first post, I have a date broken into three...

I have a table that has the date separated into 3 columns, month, day and year. All three columns are varchar in the database. I need to recombine those parts into a full date and convert the result into a datetime. I have tried casting and coverting combinations to no avail. One of the...