I have a function called check_sitrep_tree_func which calls a stored procedure called "Up" (which just displays something). When i execute the stored proc (exec Up) it works fine. But, when I ...
I have two Columns that I need to take the Max value of and limit on the higher of the two.
I was trying to do this:
SELECT MAX (COLUMN1, COLUMN2) AS EXPR1
FROM TABLE
WHERE EXPR1 > 100
...
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...
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...
Will running a defragging tool on a SQL Server adversly affect the data on it?/What is the proper way of defragging a sql Server?
Is there a function to get month name using integer value 1 to 12 in MS SQL?
Eg. 1 return January, 2 return February, 3 return March so on ...
I have this below query running in SQL+, I need to parse out the domain name from email address, how do you convert the following statement to run in MS SQL 7? I keep on getting error message ...
Is there and LDF and/or MDF viewer?
Hello,
I just got done building some reports on my report server (local workstation, windows xp) that runs a report from a database hosted on a server 2003 box with SQL 2000 running on it.
...
is there a way to add multiple columns to a table with one alter statement? does Sql Server even support such?
I feel really silly asking this question.
What is the formula for percentage? If I have a total of 1251 and sold 47 what is the percentage of tickets sold.
Thank you for not laughing to...
Hi experts, does anyone know what the root cause of the issue below is? The issue occurs when my website connect to a MS SQL database on another server. It seems to only occur when retrievi...
Hello, I am migrating some data, and I need to get rid of white space while doing so...
Here is the method that I am using to move the data, fairly straightforward...
However, when I move ...
New to SQL Server 2005. I'm wanting to batch upload data from a remote system (VMS) into a SQL Server 2005 database. I've scripted out into files, the commands I need to create the table(s),...
I am using Microsoft SQL Server 2000, now the log file size (.ldf) increase quickly up 50GB and the hard disk size can not handle anymore. I tried to backup the log file into a partition size ...
Hi,
I just installed Microsoft SQL Server Developer Edition on a Windows XP Workstation and I get the following error when I try to open Enterprise Manager:
The prodecure entry point ?Proc...
Hi guys 'n gals,
What is the easiest way to copy a Table from one database to another, which are located on the same server?
I'm using SQL Server 2000, if that makes a difference?
...
dear experts,
i created a job schedule using Database Maintenance Plan. now i want to change the schedule but encountered this error message:
Microsoft SQL-DMO (ODBC SQL State : 42000)
...
Looking for the most efficient SQL query to return rows that contain any non-numeric value in a specific field. The field is of datatype varchar, but I must identify any entries that contain ...
A user has been trying to print a report from a website and she gets a "unable to load client print control" error message.
We are operating in a SQL 2000 environment. We are running Windo...
Hi All,
I have an old MSSQL 2000 installation from a previous admin setup here and no one has the SA password. Does anyone know of any utilities to extract/find the SA password, or am I SOL?
Select OrderID,
'Sell--' + Convert(varchar(24), sum(CAST(Price AS DECIMAL(13,2))) )
From OrderDetail
GroupBy OrderID
I want to display price as varchar but somehow above code send an f...
For the life of me I can't figure out why this is not working.
My SQL Server is set to using US dates. I have a list of dd/mm/yyyy formatted strings that I would like to update the smalldat...
Hello,
I am using MS SQL, I am trying to update blank data on one table with data from another table. There are multiple columns I wish to update which are for example: "fullname", "descrip...
We have SQL Server 2000 installed on a Windows 2000 Proffesional machine. As this is not a suggested solution the installation has to be moved to a Windows 2000 Server machine.
I need to kn...
