Hi guys
Has anyone found a method in sqlserver 2000 to 'aggregate' strings in a Group By query. Like using 'Sum' for numerics...
e.g. table values:
cGroup cText
A L
A ...
I'm looking for dates in an SQL table, but the results are incorrect.
The datetime column looks this way by opening and viewing the table in SQL Enterprise:
8/10/2005 9:44:41 PM.
My q...
what does the following T-SQL means :
DECLARE @CLAIMERTABLE TABLE (ProdId varchar(100), Disclaimer text)
I have created a database which shows the administrator as the dbo owner. I have created a user which I want to be the dbo owner. How can I delete the default dbo owner and create my own
Hi there.
I am coming across a particularly frustrating little error...I've scoured the internet and have yet to find an answer which works for me.
I have installed SQL Server 2000 Rep...
Hello experts,
I am having the above problem, i don't have nay idea how to fix it. The errors are on the following line;-
45, 52, 76, 83, 90
Please see below for code;-
CREATE PROCED...
I have a Windows 2003 Serever Standard Edition (SP2). I have some scripts that I use to backup a SharePoint Database SQL Server 2005. The below script ran successfully on c: drive. I needed to...
Just examining my event logs, I am getting these errors from SQL. I've done some research but haven't gotten the error stopped.
Windows Event Viewer:
Failure Audit, MSSQLSERVER, Category ...
I have a field that I would like to only display the date as mm/dd/yyyy. Current field shows mm/dd/yyyy hh:mm:ss AM.
I would most likely create a view that will create a field that will di...
T-SQL, SQL 2005, VS 2005, ASP.NET, C#, Windows XP Pro
How can I trim outside spaces and blank lines from a TEXT field? I have a function that parses out each line of a TEXT Field into separa...
Is it possible to have a join in a delete query. Lets say i have a select statement that looks like this, is it possible to delete from the tblTemp table using a similar join, at the moment i...
Hi,
I have a situation where I'm transferring data between two MS SQL 2005 servers and one of the tasks is to retrieve data from one SQL server [S1] (it is also a Linked Server) and export it...
I have a table in MS SQL 2005
It looks similar to:
PrimaryId
Name
GroupId
Where PrimaryId is the primary key for the table.
I want to enforce that within a group, names are uniqu...
we just virtualized our sql server development box and installed SQL Server 2005 standard edition. Previously we were running sql server 2000. We moved over all the databases and I setup the...
Hi
Does anyone know whether this is possible.
I want to insert 2 values into a table, only if 1 of the values match the value in a table column
i.e
@Number VarChar(100),
@Code VarCha...
How can i get the "RowId" of a table in Sql Server?
Suppose I have a table like this
id(int) logged(datetime) keyPressed(char)
1 05/17/05 11:00:00 PM H
2 05/17/05 11:01:00 PM ...
How to do this:
select * from consent_properties where
(select streetaddress,count(con_consentid) as consents
from CONSENTS con, adults adl, CONSENT_PROPERTIES conprop, property_ids pids...
I want to convert some ntext fields in a table to varchar, keeping the same column name and data. Is there a way to do this in sql?
Thanks, Tom.
After SP 4 installation on MS SQL 7.0 I found problems with clients (ODBC) connectivity. Connection using Name Pipes works fine, but TCP/IP connection fails. The error message on clients is SQ...
Hi Experts
I have a SP that creates a varchar(200) string that creates from a table entry such as (A+(0.75*B)) a string such as (0.093000000000+(0.75*0.004087939911))
I now need to evalu...
Hi all, i keep getting this error message when I try to add a new item into my database
Cannot insert explicit value for identity column in table 'MenuItem' when IDENTITY_INSERT is set to O...
Hi again,
I need to create a function that returns a boolean value, to be used in a CASE expression.
I have tried with 'RETURNS BIT' but it is not considered as boolean an SQL fails in the c...
I get the following error:
Msg 1087, Level 15, State 2, Line 16
Must declare the table variable "@table_name".
In the following code:
=============================================
DECLA...
I want to create a stored procedure in SQL server 2000 with a parameter that will default to today's date minue 30 days. I would also like to ability to over ride the default value in the stor...
