Hi Purple,
Thanks for your advice. I had once changed autoshrink to true. But now i changed to false and increased the size.Its been more than 2 hours and i think its has not changed to 8gb again. Its 11GB. So i think it worked. But i am planning to observe the whole day. If it does not roll back to 8GB, then it is solved. Once again thanks for your sincere follow-up.
sandyboy
Last Activity: Aug 16 '07, 03:54 PM
Joined: May 15 '07
Location:
-
Access doubt
Hi,
I am new to access but i have some sql experience. Can you guys please help me with this:
I have two tables t1 and t2. t1 has a column c1 and t2 has c2 . c1 and c2 are almost same.I want all the records in t1 where the values c1 and c2 are equal.
i.e select * from t1 where c1=(select c2 from t2). How can i do this in access. Can you guys please guide me. -
Thanks Purple for replying. Let me try this and get back to you.
This is unusual. My server machine is SQL 2000 and the client machine is SQL 2005.I hope thats why i have problem.Leave a comment:
-
Increasing Database Size
Hi,
Please help me to solve this problem. My database size is 8 GB , 5GB of data file and 3GB of log file. I increased the size of datafile to 10GB and log file to 3.5 GB with 11GB and 4GB by 20 MB autogrowth. After increasing i checked the data file using sp_spaceused and it was 10 GB.But after 30-45 minutes, when i check the database size, it has reduced to 5GB and 3GB. But the autogrowth is 11GB and 4GB.I am not able to increase... -
You can try this using string functions
Create a table called table1 having columns address information,cit y,state,zip,nam e.
Now insert the address information from original table to table1.Now you have to split this address information into city,state,zip, name.
code to extract the city name only
UPDATE table1
SET CITY=Rtrim(subs tring(city,1,ch arindex(',',cit y) -1))
code to extract...Leave a comment:
-
Hi All,
I have a database that contains 25 tables. In these tables the character data was stored as nvarchar datatype. Since i am not using any unicode data and the space occupied by nvarchar is more , i want to change the datatype from nvarchar to varchar. I cannot do one by one since there are 25 tables and each table has atleast 10 columns of datatype nvarchar.
How can i change the datatype from nvarchar to varchar...Leave a comment:
-
Hi All,
I have a database that contains 25 tables. In these tables the character data was stored as nvarchar datatype. Since i am not using any unicode data and the space occupied by nvarchar is more , i want to change the datatype from nvarchar to varchar. I cannot do one by one since there are 25 tables and each table has atleast 10 columns of datatype nvarchar.
How can i change the datatype from nvarchar to varchar...Leave a comment:
-
Changing Datatypes
Hi All,
I have a database that contains 25 tables. In these tables the character data was stored as nvarchar datatype. Since i am not using any unicode data and the space occupied by nvarchar is more , i want to change the datatype from nvarchar to varchar. I cannot do one by one since there are 25 tables and each table has atleast 10 columns of datatype nvarchar.
How can i change the datatype from nvarchar to varchar... -
Let the table be T1
SELECT distinct a.date,a.id,a.b alance
FROM T1 as C
JOIN T1 as A
ON C.ID = A.ID
WHERE A.date =
(SELECT min(X.date) FROM T1 as X
WHERE A.ID = X.ID) order by a.ID...Leave a comment:
-
Can you try this
SELECT id,majorcode FROM Table_name GROUPBY id,majorcode HAVING count(id)>1...Leave a comment:
-
No. I accept that is the solution. But i got this error. I dont know why i am getting this error
Error in compiling SQL Expression
Database Connector Error:'42000:[Microsoft][ODBC SQL Server Driver][SQL Server][Incorrect sybtax near the keyword 'select'.[Database Vendor Code:156]'...Leave a comment:
-
Thanks for your reply. I wrote the query
SELECT name,address,ag e FROM t1 where age>20 ,but got the error
Error in compiling SQL Expression
Database Connector Error:'42000:[Microsoft][ODBC SQL Server Driver][SQL Server][Incorrect sybtax near the keyword 'select'.[Database Vendor Code:156]'
So we need to query the database in SQL through CR using SQL commands only. Is there any other way to do...Leave a comment:
-
Try this code
Select * from view1_4t where dob=dateadd(dd,-90,getdate())...Leave a comment:
-
Thanks for the reply. I have done till here. Say for example the table t1 contains
the following fileds.
Cust_id
Name
Address
City
State
Zip
Age
Date of Purchase.
Now i want a report that conatins only Name,Address and Age. I want to do this in CR. So i connected to the database and inside SQL expressions Field i wrote the following query,
...Leave a comment:
-
Yes. I have a table that contains details of Customers. For ex,
I have to pull all the details of customers whose age is greater than 20.How can i do this in CR....Leave a comment:
-
Extracting data in SQL server using crystal report
Hi All,
I am new to sql server. I am working with Sql server 2000 which has tables
containing customer details. My question is :
Is there any way to extract the data in Sql server database using Crystal Reports. I know how to use Crystal report for reporting purpose but not for extraction.Sinc e my company will not have any sql programmer in future they are planning to do this way. Is this possible?
No activity results to display
Leave a comment: