Hello,
I am trying to to execute the following query in MS SQL Server:
SELECT tblProducts.ProductName AS [Product Name],
SUM(tblOrderDetails.Quantity) AS [Quantity Sold],
SUM(tblOrder...
I have table A with two columns
Location_ ID, ITEM_ID
1 location many items (min 1 , max 5 items per location)
In my report I want to concat all item_id delimited by ',' by each loca...
SQl server 2000, in Windows 2003 server
Server 'gsbsqlrep' is not configured for DATA ACCESS.
First of all, I used
sp_addlinkedserver gsbsqlrep
and it said, gsbsqlrep is already exists. ...
I am looking for a good How to Guide on setting up a cluster for SQL 2005 ent on a Win 2003 ent box (2 servers exactly the same) SAN is not yet installed but will be soon. I know i have to wai...
hi i get this error when trying to load SQL Server Management Studio Express. i used CTP version previously. i uninstalled the CTP before installing the new one.
both also gave me this erro...
I am trying to move my overgrown transaction log from one drive to another.
-I can't get the shrink command to work.
DBCC SHRINKFILE(NAG_CDR_Audit_Log, 1)
I also tried to run the deta...
If you need to alter more than one column in a table, does MS SQL support doing this in one ALTER TABLE statement?
Or is it necessary to use multiple ALTER TABLE statements?
My computer has been running slow for some time. I have been abel to correct all Event error messages except one. That is the Event ID 17052 which states:
Event Type: Error
Event Source: M...
I'm trying to update one column of a table with the following query:
UPDATE Utable
Set Amt =
(SELECT
Sum(Amt)
FROM Ptable
WHERE ID IN
(SELECT ID FROM UTab...
This is the following error that i get.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver spe...
We are trying to add SA (default SQL account) to the new SQL database.We are getting error 15405:cannot use the reserved user or role name 'SA'.Microsoft SQL-DMO (ODBC-SQL State:42000)
Wher...
I have a Transact-SQL stored procedure, I have written, which returns results that include a datetime field. I am trying to use the DATEPART() function to parse out the field, so that the dat...
i am getting this error Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ':'.
Server: Msg 259, Level 16, State 2, Line 4
Ad hoc updates to system catalogs are not e...
How do I add a field to an existing table that be auto incrementing for all the records that are already in the table?
ideally in query analyser please
SQL server 2000
tia
Does anyone have any experience of migrating SQL Server servers from standalone servers
to virtual servers running under VMWARE ESX
The environment i have is a mixture of Windows NT4 and...
I have a SQL server Database that shows "<Database name>(Loading)...but I cannot be able to stop it. I tried to detach it but I got a message cannot be able to detach a Database that is in a r...
I've imported a CSV file into my SQL server where it sits a table. All the datatypes are VARCHAR. There is 1 field that I would like to convert from VARCHAR ->>NUMERIC with 2 decimal places; ...
Current::
SELECT DISTINCT product_type, COUNT(*) AS Count, severity_code
FROM dbo.probsummarym1
WHERE (dept = 'it- operations') AND (product_type= 'other / to be determined')
G...
what does the following T-SQL means :
DECLARE @CLAIMERTABLE TABLE (ProdId varchar(100), Disclaimer text)
Hello
I keep recieving the following message in Event Viewer:
"The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs." Event ID 17896
It is an informatio...
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(...
I have a simple stored procedure -- see code below
if I want to use that s/p in a query, this works fine:
drop table #garytesttable
create table #garytesttable (cus_no char(20))
insert...
Hi, I need to convert Julian dates to datetime. For example, 105031 is the 31st day of the 5th year of the 21st century, or 1/31/2005, or 98129 is the 129th day of the 98th year of the 20th c...
I have been asked to fix a load of records which were broken by a bug in a recent software upgrade.
I have identified the relevant data, and created a sort order column xkey...
I have a ...
I need to count the number of rows with todays date. The column is datetime type.
I used this query
SELECT COUNT(*) FROM tblreport WHERE AccountNumber = '00001' AND FileDate = CONVERT(dat...
