We are developing a reporting infrastructure to go with our Property Management System. We have standardised on Reporting Services 2005 for the production of the reports, however we find the R...
I have one table,
CREATE TABLE Wrongly_Merged_Alerts_test
(
SSN nvarchar(255) NULL,
SRCSSN nvarchar(255) NULL
)
These are social security numbers. I need something that will compare...
I'm partial to a tab size of 3 in the TSQL Query Designer. I've set it at 3 (SS1 - Tab Size.jpg). Yet, when I hit the tab key, the cursor only moves 2 characters to the right.
I just setup a Windows 2003 Server Enterprise at my office. It is on the network and running good. I installed SQL Server 2005 developer and created a new database. I plan on upsizing an Acces...
Hi guys,
I am just wondering is it possible to create a new SQL table automatically using the column headers from an excel file?
I am currently attempting to do it using SSIS but cannot ...
I have a stored procedure that I execute from my VB.NET application. I want to have 2 query options in the sproc so it will return different values depending on the variable I send to the spr...
I have a table that logs phone data. This table gets a row inserted every time a person who is logged into the phone system changes their state . So if I pick up the phone or hang up the phon...
I have I ASP.net in Visual Studio 2008. I want to use SQL Server Express 2005 as my Backend.
I cant seem to get the connectionstring right.
Here is what I can provide
SQL Server Expr...
Hi,
We are using SQL Server 2005.
I urgently need to find a way to find out who created some tables in one of our databases. Is this possible without purchasing some third party tool?
...
Hi Experts Basically i have switched the database properties update statistics,auto shrink to true I want to understand what is the interval SQL server will auto update statistics or auto shri...
I have a table called MyTable, with columns Id, Col1 and Col2.
I would like to add Clustered index to Col1 and identity to Id.
How do I do that?
How do I duplicate a sql table?
I would like to poll experts' opinion on the following problem.
This application allows user(s) to select a number of nodes in the tree. When submitted, the software will retrieve all le...
Friends,
I have the following qry:
Select ResultItemID, Lap, SectionTime From
SectionTimes
Where
SectionID=-1
AND SectionTime > -1
AND RunID=3
AND
SectionTime IN (Select Min(S...
hello:
i'm using :
<?php
$db = odbc_connect("DSN","user","pass", SQL_CUR_USE_ODBC);
$sql = "SELECT * FROM Products";
$result = odbc_exec($db, $sql);
echo odbc_num_rows($result);
?>
b...
I am using this function, it is working but i am getting several decimal digits, any way i can change it two
case when e.interestrate = 0 then 0 else abs(l.fin_chrg/(e.interestrate/12)) end...
hello:
i'm using php, and datasource and odbc connection to connect a sql 2005 server
could some expert here tell what is the same statement i shoudl use in sql 2005?
mssql_num_rows():...
My question is realted to converting rtf to text via a sql function or stored procedure - the sql function I have seen discussed uses the activex control "RICHTEXT.RichtextCtrl". I have no pr...
Hi,
I installed a copy of MS SQL 2005 Developer on my XP machine. I might have specified the wrong domain name or the login password for the id during installation for a named instance. Th...
Hi experts:
Any way I can get a count of elements that are larger or smaller than the average of the same column using just one query? For example:
MyCol
------------
10
20
18
Res...
Hello, I need a workinmg sample database for sqlserver express 2005 or 2008.
Running through many links of Microsoft and trying the ones from CodePlex, I haven't still succeed to find one to ...
I received a simple but good answer to my previous question on this matter.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23725831.html
What I have fo...
Using MS SQL 2005 on ServerA, Is there a native SQL Server mechanism that allows ClientB to attach and create a SQLserver database backup onto ClientB's local disk? If so, please send a link...
Is there anyway to completely lockdown a SQL database? What I mean is to prevent someone from physically takking a hard drive from one server and plugging into another computer and having accc...
Hello,
How do I go about obtaining the numeric value from smalldatetime.
I can get a numeric value that ranges from 0-23 if I use DATEPART hour, but I need the value to be displayed 1-...
