Recent content by rute67

Where do you see a different number of columns in my table than the insert. I have 9 columns and I am trying to input 9 items. I have been trying to figure that out for a while now.

I am getting this error when I have created a cursor. Can someone please help me figure this one out. Probably something small but I just can figure it out. Server: Msg 213, Level 16, State 5, Line 57 Insert Error: Column name or number of supplied values does not match table definition. Here...

You can also try where Enpatient.last_name not in (select last_name from physicians)

that will only give me a whole number ex: 27, 23, 24... But the problem is that I need to get the entire number. EX: 26:14:29.000 or 23:34:09 something like that.

I have tried both and all I get is the time but not the correct one. if I the time was 27:13:30.000 and I use char or varchar I get 03:13:30.000.

I am trying to format seconds into hours. I am using the following: dateadd(ss,sum(cast(duration as int)) ,'12/31/2099') this gives me a value of 12/31/2099 00:00:00.000. the problem falls when the sum of the seconds falls greater than 24 hours. instead of getting a value like 12/31/2099...

SP 3 Worked thanks for the help.

I am trying to connect to my local analysis server. I am running Win XP Pro. I am already part of the OLAP Admin group and have all the access i need. The problem is that ]whenever I restart me computer I connect to analysis but when if I close and reopen analysis then I get an error...

I am trying to fax using a DTS package. Does anybody or Has anybody done this before? Can you please point me in the right direction. Thanks Greg

Can someone help me login to a secure site created in PHP using a perl script? I need to be able to login and download information. Thank you for any help.

That was one way that We had thought of but we were trying to see if there was a different way of doing it. We didn't want to have change mulitiple records for 4000 members. But if that is the only way then I guess we have no choice. Thanks for all the help.

Sorry forgot example for the last problem Example: Member Effective dates John Doe 1/1/2003 - 1/31/2003 2/1/2003 - 2/28/2003 3/1/2003 I need to be able to get the 1/1/2003 effective date Example: Member...

Let me start be giving the problem. We are a health company ad we have member that sign on with specific effective date and we are having a problem getting information for these members. Following are three difference issues which I have already resolved the first two but am not able to anwser...

Got it..... Thanks for all of your help

that script worked but how can I get the set @i = 228 where 228 equals the field name that I am trying to use. I tried it with the field name and it gives me an error: Server: Msg 207, Level 16, State 3, Line 2 Invalid column name 'Talk_duration'. Where I know that Talk_duration is a valid...