Search results for query: *

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...

I am sorry but I miss communicated myself. I have a value for Talk_duration of 228. I used this script to get a result: cast(cast(Talk_duration as numeric(10))/60 as dec(5,2)) as Talk_duration And I get this result: 3.80 I am sorry for the miscommunication.

Here is the conversion: cast(cast(Talk_duration as numeric(10))/60 as dec(5,2)) as Talk_duration Here is the result. Talk_duration is in seconds = 228 results in minutes = 3.80

I am trying to create some system reports. I recieve the data into SQL thru a DTS package and it is received as a varchar(255). The only problem with that is that the information I am having problems with are seconds. I am then converting to numeric(25) in the query. now the data that I am...

In the help menu do a search for 'cast and convert' and that is everything you need to convert a date to any style you want. There are still other ways besides this and if they don't help you just reply to this post.

I am USING a DTS package to create an automatic output file every month. I need to be able to sequence that out file name. For example: products20030401.txt (current month) products20030501.txt (Following Month) Is this possible and if so how? Thank you very much for your help.