Hello, I have two table T1 and T2.I used Sql server 2000. Table T1 ID WorkerName Group 1 Rahim,Karim 1 2 Kamal,Adam 3 3 Rahim,Karim 1 Table T2 WorkerID WorkerName 1 Rahim 2 Karim 3 Kamal 4 Adam I want to replace Worker Name on T1 with 1st WorkerID on T2 ...
i put the format of a textbox using expression like Format(Fields!name.Value, "dd/MM/yyyy") can i somehow set a global format for datetime and currency/floats without having the need to set it for each textbox in part ...
I have Database in the sql2000 can i use the features of sql2008 without changing compatibility level ? Can i use reporting services with the database of sql2000 without change compatibility level? ...
The following statement BACKUP LOG [AMS_Prod_log] WITH TRUNCATE_ONLY works fine in SQL Server 2005 but it doesn't with 2008. It seems truncate_only is deprecated in 2008. Could you please let me know how to achieve this in 2008? What care needs to be taken like backup... etc? ...
Hi all, I have table with name Dates. Fields are: Date of Joining Previous Date of Visit Number of Visit Reffered Department For Date of Joining and Previous Date of visit fields entering the data from drop down list. like...Select Day....Select Month.....Select Year. Then how many fields should be created.....How can i design this ent...
So here's some code: statement.executeUpdate("CREATE TABLE SomeTable(id INTEGER IDENTITY, " + "text CLOB)"); which throws an exception "Wrong data type: CLOB in statement [...]". Is there a way to store CLOBs in Hsqldb databases? The documentation says it is. Or maybe my knowledge of SQL is so rusty that I forgot how to define the...
This is not asking how to convert an arbitrary string to datetime in MSSQL such as this question. I can control the string format but I want to know what the MSSQL syntax is for updating a datetime field using a date string. ...
My SQL is very rusty. I would like write a query to take field1 Field1 ---------- Soap -AC Coffee -AD and update it to Field1 ---------- AC_Soap AD_Coffee There will always be the dash between the 2 parts. ...
I have this query: select top(2) property_id_ref ,image_file ,property_name from property_master a inner join image_master b on a.property_id=b.property_id_ref inner join customer_master c on a.customer_id=c.customer_id When I execute it, I get the following result: 512 ~/propertyimg/3954493 id_1.jpg Commerci...
Hi all, I am developing project on hospital management. I am entering the data of Patien details. like PatientsProfile: Id,Name,Age, Address, ContactNo PatientRelativeProfile: Admittername,Age,Address,ContactNo, Relationship Patients Defect Profile: Injury_Accident, Murder_Attempt, Cancer, Other Previous Treatment References: Hospital...
I have a query like this: select foo.*, count(bar.id) from foo inner join bar on foo.id = bar.foo_id group by foo.id This worked great with SQLite and MySQL. Postgres however, complains about me not including all columns of foo in the group by clause. Why is this? Isn't it enough that foo.id is unique? ...
I'm having some trouble doing a "tree-like" query (what do we call this?) in SQL. Take a look at my diagram below (table and column names are in danish - sorry about that): Using MSSQL Server 2005, the goal is to find the most parent group (Gruppe), for each customer (Kunde). Each group can have many parent groups and many child grou...
Hello! I am running a service that does some computation and communicates with an ms sql server every minute or so (24/7, uptime is very important) and writes to error log if anything funny happens (like a timeout or lost connection). This works great, however once in a while I will get this error: Arithmetic operation resulted in ...
I have to insert 8000+ records into a SQLite database using Django's ORM. This operation needs to be run as a cronjob about once per minute. At the moment I'm using a for loop to iterate through all the items and then insert them one by one. Example: for item in items: entry = Entry(a1=item.a1, a2=item.a2) entry.save() What is...
CREATE TABLE item ( link MEDIUMINT UNSIGNED PRIMARY KEY NOT NULL, title TEXT NOT NULL, rank INT UNSIGNED NOT NULL AUTO_INCREMENT, notes TEXT ) ENGINE = INNODB; I'm having trouble implementing this. rank is a user given ranking that can be changed at any time, and items can be added and removed ...
In a SQL Server Execution plan plans what is the difference between an Index Scan and an Index Seek I'm on sql server 2005 ...
Given the following table: ID State Date 12 1 2009-07-16 10:00 45 2 2009-07-16 13:00 67 2 2009-07-16 14:40 77 1 2009-07-16 15:00 89 1 2009-07-16 15:30 99 1 2009-07-16 16:00 Question:How can i GROUP by the field "State", while still maintaining the borders between the state changes? SELECT...
Asking this question for a friend of mine. My client had send me a Back up file of a database in SQL Server 2008. I installed SQL Server 2008 Express Edition. Then i tried to Restore the given Back file with this but unfortunately its throwing an error "The media family on device is incorrectly formed . SQL Server can not process t...
Hi, I have inserted some data in table using encryption (encrypted by creating my own certificate.). INSERT INTO Person2(ContactID, eFirstName, eMiddleName, eLastName) Values (1, EncryptByCert(Cert_ID('TestCertificate'), 'FirstName'), EncryptByCert(Cert_ID('TestCertificate'), 'Middle Name'), EncryptByCert(Cert_ID('TestCertificat...
Hi, I'm having trouble getting a decent query time out of a large MySQL table, currently its taking over 20 seconds. The problem lies in the GROUP BY as MySQL needs to run a filesort but I don't see how I can get around this QUERY: SELECT play_date, COUNT(DISTINCT(email)) AS count FROM log WHERE type = 'play' AND play_date BETWEEN ...