If have a field in a table, say it is named tbl_test. This tbl_test has a field latest_Update which is a date.
I want to do an if statement in another sql query something like this. Meaning tha...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23137837.html
I have a table with 3 fields that are key's (say a, b and c)
I have another table (table2) where I have the same keys, but it contains only a subsete of the fields.
what I want to do i s to up...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23165380.html
I would like to change db owner on a DB that i restored. I ran the following and it doesn't work.. Any ideas? Owner is currently called odbc and i would like to replace it with dbo
EXEC sp_ch...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23297648.html
Hi folks,
I have a database table named tblsales.
I want to create a stored procedure that will take two input parameters.These are @Year and @week.
When I enter these two parameters then stored...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23311311.html
How do I get a secondary COUNT in an SQL query?
I have a table called ITEMS as shown below. I have an SQL query with a GROUP BY giving me a report, but I need more detail in the report.
What SQL...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23445796.html
Zones:
SQL SyntaxDate Answered: 05/31/2008 Grade: A Views: 0
I would like to convert a date time field to a string . example the string should look like this
08/26/2008 10:30:26
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23682306.html
Zones:
SQL SyntaxDate Answered: 09/02/2008 Grade: A Views: 305
I want to enable bi-directional communication at the server level between SQL and Oracle servers.
I would like to get a hold of the SQL server for Windows NT Programmer's Toolkit.
According to th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10019087.html
How do I write an SQL-query that generates these results:
OrderID UserID UserName
--------- ----------- --------------
010101 ASMITH Anthony Smith
010200 (null) (null)
from ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_10019262.html
Zones:
DatabasesDate Answered: 08/06/1997 Grade: C Views: 4
Is there a comparable function to Access's PIVOT?? I would like to sum all
the records by employee location by Job Title, where i'd be doing a group by Job Title and pivot on Location;
JobTitle ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10030004.html
I have two Compaq Server
Prolian 800 : 1 PentiumPro 200, 128KB Ram & 4GB HDD
Prolian 6000 : 2 PentiumPro 200, 256KB Ram & 12GB HDD(RAID5)
Both running Windows NT 4 (SP3) and MsSQL 6.5 (SP4). I w...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10036301.html
