Joell
Last Activity: May 26 '11, 09:57 PM
Joined: Aug 22 '07
Location:
-
Thank you for your help. I completed started over and made the insert using all fields instead of using the * for all. Populating a value for each field worked. I appreciate the help. -
I am sorry I didnt send before. I am new to this type of help.
Here is my simple code:
INSERT PROF
select * from Chicaco_TEST
I have now checked all of the BIT data types and none of them are NULL. I dont know why the error message says it is a BIT type when neither the source or target table for that field is data type BIT.Leave a comment:
-
Conversion failed when converting the varchar value to data type bit.
When I try to insert values into an existing table, I am getting the following error. The table is not in bit data type format and neither is the target table. Conversion failed when converting the varchar value 'JOHN KUCHTA' to data type bit. Please help.
JOELL -
Sum up a column and then update a temp table with results
I am using SQL 2000. I want to sum up a column and then add that to a newly created table.
How do I do this in SQL Server ? Below is what I am getting the error on:
update #temptable
Set Aug_total = Sum(hist.amount )
Select sum(hist.amount )
from cust inner join hist on
cust.c_id = hist.c_id
where blah blah blah....
The error SQL returns is:
An Aggregate may... -
Thank you so much! I appreciate the info. I have not started running any queries on this new software. I was told by the vendor however that the log file can grow in 1 GIG size because of all of the records in certain products that create the history in the database.
Best Regards,Leave a comment:
-
Log file needs shrinking
Hello,
I need help with shrinking the actual log file. I keep shrinking the trans logs but then it just reverts back to a 1 gig size trans log fille even after I have shrunk the file. What can I do? how do I code this in SQL? -
Integrity Check help
Hi Guys,
I have set up an Integrity check on two different maintenance plans. Set up the same on both however one works, one fails. There is no error message either other than the job failed.
I have this integrith check on our system database maintenance plan. Any ideas to the error or what to check off on the menus?
Joell -
Thank you very much. I appreciate the help. Will see what I can do with the information you gave me. :)
JoLeave a comment:
-
Scripting from two servers - possible?
Hi All,
I am trying to report off of two different servers and sofware applications of information. Is it feasible to write a view, sql script that will pull information (not linked) in a timely manner from two different servers and then dump into Crystal for reporting?
The subreport route using Crystal will not be sufficient and very slow and the information will not be displayed in the output in the necessary format.... -
I was using c_quote >= getdate() -1
The query is supposed to run at 5am so I do not know if it will work correctly until tomorrow but I think this might work:
c_quote >= convert(datetim e,convert(varch ar,getdate(),10 1)) -1
Thanks for your efforts!...Leave a comment:
-
Select c_id_alpha Acct_no, c_quote, getdate() Getdate_column from cust where c_quote >= '09/14/2007'
406765 2007-09-14 00:00:00.000 2007-09-17 15:43:45.613
406789 2007-09-14 00:00:00.000 2007-09-17 15:43:45.613
406784 2007-09-14 00:00:00.000 2007-09-17 15:43:45.613
406786 2007-09-14 00:00:00.000 2007-09-17 15:43:45.613
406787 2007-09-14 00:00:00.000 2007-09-17 15:43:45.613
406788 2007-09-14...Leave a comment:
-
That query with the cast returns the same rows as just using the date field. I need to use the getdate() though. I just dont understand why it will not bring back the same results.Leave a comment:
-
c_quote is a datetime data type in my database. What else can I try?Leave a comment:
-
The is what I mean:
Select c_id_alpha, c_name, c_quote, getdate() from cust where c_quote >= '09/14/2007'
returns 9 rows
Select c_id_alpha, c_name, c_quote, getdate() from cust where c_quote >= getdate()
returns 0 rows
how can this be?Leave a comment:
-
the clock on that server is the exact time. It is correct. But, my query is still not pulling early the morning the day before data. I dont understand it. If I pull it now with an actual date it works fine.Leave a comment:
-
That would only 1 hour. We dont have people entering data until after 8am in the morning. Actually we only have one person adding in new customers. Could it be something else?Leave a comment:
-
ok its the getdate() function. I am trying to pull at 5am the previous day's new customers and add them to this table. When I put in yesterdays date, I get them when I put in getdate() -1 I dont? Am I not using the correct date function?
getdate() - 1 <--- is this not correct?Leave a comment:
-
SQL Enterprise not updating table
Hi Guys,
I have the following code in the Enterprise Job Scheduler and it runs successfully but the table is not updated. I first put it into a stored procedure but when they did not work, I put just the code to insert the records directly into the scheduler. Its supposed to update nightly at 5am, but when I run my crystal report the next day, nothing in the table was updated. Please help!
This is SQL script. I do... -
Thanks soooooooo much! You are awesome!
JoLeave a comment:
-
Ok I see where the job steps are. In the command window, I can type in my proc name sp_DailyOrders and it will know how to kick it off?Leave a comment:
No activity results to display
Leave a comment: