I have a single table T with three fields F1, F2, and F3. I want to group by F1, sort by F2, and select the first occurence of F1, F2, and F3. So if my table looks like:
F1 F2 F3
01 01 A
...
Hi,
How can I convert hours into minutes eg, 02:35:00 = 155:00
I'm considering replacing a Sqlite3 database with MS SQL, but I want to make sure I'm not going to have problems with converting some of the non standard SQL commands.
In Sqlite3, you can i...
i'm trying to pull data out of a column that looks like such:
(Open,7/15/2008 9:23 Open,7/15/2008 10:26 Assigned,7/15/2008 10:27 Assigned,7/16/2008 14:11 Closed,7/16/2008 16:22)
All i ...
How can I use a GROUP_CONCAT function in ms sql. is there any alternative to this? I have a table likethis
Name---------------------------Favorite Color ID
Jim---------------------------...
Hi,
this morning I discovered that it wasn't possible to make Inserts anymore because there was a File which grew to > 61GB:
D:\sqldata\MSSQL\LOG\SalesLogix-LOG
which took all the HD s...
I am receiving the following error message in the SQL Server Error logs:
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
and ...
Hi there,
We are running MOM and having problems with the database. The log file reached 86GB and filled up the whole of the D Drive it was living on.
I wanted to take a backup of the databa...
Hi,
I need to give developers permissions to several SQL Server 2005 databases so they can ONLY view all the tables, views, stored procedures etc, but not create/edit/delete/modify any. If ...
I created a Mait Plan to back up all DB's except systems and 60 DB's back up fine execept this one. It gives me an error all the time. I was hopping that someone can give me some insite as to ...
I have a Date Field that returns the date and time. I only want the date. Is there a way to lop off the time???
Thanks
- Marc
I run this:
SELECT count(open_time)as Count,DATENAME(mm, open_time)AS Month
FROM probsummarym1
WHERE (datediff (mm, getdate ( ) ,Open_Time) > -4)
GROUP BY DATENAME(mm, open_ti...
(This is tangentially related to http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21182188.html)
Can anyone confirm whether it's possible to combine "standard" SELECT statem...
Hi,
Please kindly help resolve this error message.
Thanks.
Server: Msg 257, Level 16, State 3, Procedure user_master_verify, Line 6
Implicit conversion from data type varchar to varb...
Can somebody help me with this error :
//===STORED PROCEDURE CODE START
CREATE PROCEDURE web_ApplyCallCharges_Intl
@Month_Table varchar(50),
@Call_Zone varchar(5),
@Call_Type varchar(...
How can i use sp_change_users_login 'auto_fix' to update all my logins on a server so i don;t have to use
exec sp_change_users_login 'update_one',
'nsmith', 'nsmith'
over and over again.
Hi,
I have a SQL Server 2000 database with an nvarchar column containing a mixture of strings, e.g. "Introduction", "Appendix A" and section numbers, e.g. "2.3", "9.1" or "10.2",
I need ...
I've create a tablix report in SSRS 2008 that ends up being several pages when rendered. I want the column headers to repeat on each page so my users know what they're looking at. The MSSQL ...
Hi,
I have used MySQL for a long time in the WAMP setup but am unsure how I go about getting the WAMP setup with MSSQL.
This is probably an easy solution but a simple step through guide ...
In the SQL Server Service Manager I keep getting this error message. "The service did not start due to a logon failure."
Then I click OK, and I get this message
"Error 1069- (The service d...
Greetings,
I am looking for how to get the following 6 date ranges:
1) This week (first day(su), last day(sa))
2) Last week (first day(su), last day(sa))
3) This month (first day, last...
Hi experts
My SQL query :
SQL = SQL & " AND ((cint(ShipOther1) <= " & ProdWeight & " AND " & ProdWeight & " <= cint(ShipOther2)) "
SQL = SQL & " OR (ShipCost1 <= " & ProdWeig...
Example:
col1 col2 col3 col4 col5 col6
1 0 0 3 0 2
1 1 2 0 0 2
1 2 2 4 3 1
I want to be able to create a column that takes the highest value amonst all these fields on their respective ...
I have a Microsoft WIN2K3 R2 STD edition server with existing instances of Microsoft SQL 2000 and Microsoft SQL Express 2005 already installed. I am trying to install a new instance of SQL 20...
I have manually changed the service account for SQL Server Agent Service, SQL Server integration services, ful text indexing service from the local system account to a domain user account. The...
