I am working on a project that will be in different stages. The first stage is to move the web reports. To do this I have a site in TX and a site in UT. I have SQL 2000 in TX and SQL 2008 (ent ed...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23725217.html
Zones:
MS SQL ServerDate Answered: 11/07/2008 Rating: 6.9 Views: 0
I viewed searched and found one of the questions that pertains to my issue "MS SQL substring a character" The response did not work for me however i was hoping to get more assistance with a simila...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23795494.html
Zones:
SQL SyntaxDate Answered: 10/07/2008 Rating: 9.3 Views: 5
I am looking for a SQL rounding function that always round UP to 2 decimal places.
2.7888 rounds to 2.79
2.78001 round to 2.79
Thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2393...
Hi -
I have a web server with Windows 2008 and SQL 2008. Someone is attempting to crack the SQL server with about 60 login attempts per second all day long. They are trying different common us...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2393...
I'm converting from Sybase to SQL 2008. I'm converting some stored procedures. In several places I am using select....into to create local temp tables (#tablename), update different table element...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2411...
These are the values I enter into the following columns on a Table named Main.
Workstation = COOLWD,
Username = Domain\Username,
Domain = Top.Middle.com,
WakeUpType = 6,
MacAddress = 00:c1:4a:...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2431...
I understand how data gets inserted and also updated. I know that the PK Column is what helps the Update command know how to update a specific record. However, my Brain doesn't know how to translat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2431...
I have created SQL statement from 4 different tables which contains many columns - one of them being a phone number column. I have copied these results to Excel and sent them to the enduser as req...
http://www.experts-exchange.com/Database/Miscellaneous/Q_24345885.html
why wont this like work?
select *
from users
where P_Employee_ID LIKE '______[^a-z]'
returns incorrect results. im trying to get 000001-999999, no alpha chars.
http://www.experts-exchange.com/Database/Miscellaneous/Q_24386463.html
There was a post on this site at:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24347726.html
this was a great help to get me started I got it to work for a top 5 on a yea...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_24385214.html
Zones:
SQL Syntax,
...Date Answered: 05/11/2009 Rating: 7.8 Views: 0
