I have created a report with cascading parameters according to an example in the book Professional SQL Server Reporting Services by Paul Turley Chapter 4. The parameters are set up and working correctly as far as the cascading goes however when I hit the View Report ... I get no detail. I know the...more >>

Hi all, First of all: *** HAPPY NEW YEAR TO YOU ALL!!! :) *** then, here it goes; I've downloaded SQL Spy 6.0 from Hybridx (got it from http://files.webattack.com/localdl834/sql_spy_setup.zip). It's a freeware tools to monitor SQL Server activity. I use this tool to watch how my apps (crea...more >>

I have table Rooms with roomID,dateStart and DateEnd field. Then I have table user with dateStart and dateEnd field. Now I would like to get section of all free dates of rooms for selected user. for example: roomID dateStart DateEnd --------...more >>

I have a table with two fields Field A and Field B. Field A is unique but Field b can be duplicated. 111 AAA 222 AAA 333 AAA I just want one of the values in Field B and I don't care what Field A is returned, but I need one. Basically I have 700 dups in a table of 20,000. Need...more >>

Hi there, I have a requirement in which I need to find the most frequently phrases/words (excluding the, a, an, is, was, were....) using SQL Server full text search. I have imported all the documents onto SQL Server with a import tool and I am able to see the contents in a table which I have ...more >>

I currently have a table with 4 columns in it. For example: Table: Wine |Region |Location |Grape |Color |------------------|-------------------|-------------|------- |Napa |California, USA |Pinot Noir |Red |Napa |California, USA |M...more >>

I'm using VB.NET with ADO.NET and would like to programmatically create a database and then create all the necessary tables for that database -- is this possible? If so, not finding much in my many .NET books nor online -- they all seem to cover "once connected..." and nothing about actual ...more >>

Hi, My SQL Server has about 80 users online during the day but when all of them log off and close their connection, the server memory stays at 1GB and does not free it to OS. The next day users log in and make connections to SQL Server, this memory is certainly required but I want to know tha...more >>

I am using the following in a view and it is returning a whole number. Why doesn't it return a decimal? ROUND(dbo.RepairOrderTasks.MinutesWorked / 60, 2) Thanks. David ...more >>

Hi - I have a table that contains information that I would like grouped by month and name along with a total based on a table value, if possible. I'm not sure how to do this. My table has the following columns ProcessDate = Contains the date the item was run DB = Contains a mainframe ...more >>

In my accounting system which uses SQL Server with ODBC when the manager computer executes a report which takes about 1-2 minutes to complete the other clients' PCs who are using POS Screen almost freeze. The server is HP370 G3 w/2GB RAM, RAID 5 HD, DB Size: 3.5 GB Why this happen, is there ...more >>

Suppose I have this: CREATE PROCEDURE sp1 AS BEGIN TRANSACTION -- Do some inserts and/or updates COMMIT TRANSACTION GO CREATE PROCEDURE sp2 AS BEGIN TRANSACTION -- Do some inserts and/or updates COMMIT TRANSACTION GO CREATE PROCEDURE sp3 AS BEGI...more >>

Hi there, I use sqlmaint to backup a database, I've just moved some DTS's that do the imports, and a job across to a new server, and am having problems with the paths for both the reports and the database because of spaces in the directory names....admittedly this isn't a BIG problem as I can ...more >>

Hi, I'm not sure this is the right group to post. Please help me out. There is a column named "nt_username" in sysprocesses table, which told me who is using SQL 2000 db currently. Somehow this column is blank now. Can somebody tell me what happened and how to fix it? Because "nt_usern...more >>

been staring at this too long: SELECT 1 AS IsActive, firstname = CASE WHEN CHARINDEX(' ', [firstname]) > 0 THEN SUBSTRING(RTRIM([firstname]), 1, CHARINDEX(' ', RTRIM(firstname))) ELSE firstname END, lastname FROM (SELECT DISTINCT ...more >>

If I have a Text field on SQLServer 2000 and a user enters in some information and saves it but then later deletes the text, it leaves the following formatting code in the field: {\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Arial;}} \viewkind4\uc1\pard\lang1033\fs16\par } Can ...more >>

Hi Freinds, SQL 2000 I added RAM to SQL server and make it 4GB from old 2GB SQL EM memory tab shows all memory utilized, but when I ran sp_configure, it show just 3GB of ram in use Also on win task manager I can see that SQL is using only 2GB of memory. What should I do to let SQL use al...more >>

Hi all, Happy New Year! As per the title really... I have 2 SQL Servers on the same network, I'd like to copy 3 DTS's and 1 Job from server A to server B - is there any easy way to do this or is it simply recreate them on the other machine time? Any information appreciated. Regards ...more >>

Hi Freinds, SQL 2000 I added RAM to SQL server and make it 4GB from old 2GB SQL EM memory tab shows all memory utilized, but when I ran sp_configure, it show just 3GB of ram in use Also on win task manager I can see that SQL is using only 2GB of memory. What should I do to let SQL use a...more >>

I have an ADO command object that has a parameter of type "decimal". The table that I'm trying to update has a field to store percentage values. For some reason, my ADO code is failing. This is basically the line is calling a SP: objCmd.Parameters.Append objCmd.CreateParameter("@PercentD...more >>

Hello, I have an internet site, that supports ms-sql server 2000. The hosting company for some reason have problems on there wizard of creating columns on db, and doesn't support the auto-increment. How can I do alter to a column, with an sql command, to an auto-increment one ? Need sampl...more >>

Hi NG, I've to purge out old data from a logging table. E.g. I've to keep at least the last 1'000 rows of a table regardless of its date. Can I use the TOP int clause or do I have to compare the time stamps? Example: create table tbLogs (sText nvarchar(4000), dtDateTime datetime) ...more >>

Hi, I am not a programmer, and I have a very limitted knowledge of how to use SQL. I have an Access Database and pre-written querries. For example, I have query for Products, and I have many fields in this query. In many cases, all fields have the same information, except products. For every ...more >>

Hello, I have a long running stored-procedure. End users can start this = procedure anytime they want (It runs a search on some data). My problem = is, if they ever (and they do) start this sproc a couple of times all at = once, they will break the process. (Not so much the stored procedure...more >>

Hi, Is there a way to create a list of fields and their data types in a table other than using generate script? We'll be working with a call center and they will be sending us data in Excel sheets. They're asking for fields and data types but they're not sophisticated enough to decipher a S...more >>

Does anyone know how to create an MDX (not Trans-SQL)using a between or some kind of other formula? I know how to make it Trans-SQL, but I don't know how to do it with MDX. For example: If sales are between 5 and 5.99, put a 2, If sales are between 6 and 6.99, put a 3, else put zero. Th...more >>

I am building a Payroll application that will be storing Employee details. When an employee's details are changed, the changes remain as "Proposed Details" until they are authorised and accepted by someone in the PayRoll dept. Also, every change to the Employees table should saved in an audit...more >>

Before killing the users processes (with SqlServer.KillProcess), I would like to send a message to them. How to do that with Sql-dmo? Thank you...more >>

I am using a DTS to get data from FoxPro Database. What's best way to connect to FoxPro Database and How to do that? Thanks a lot and Happy New Year. ...more >>

Hi all I insert data into table A through an asp page which executes encrypted sp for inserting data. I worked fine till i used a trigger on the same table which uses xp_send mail for insert, upate. the following scenareos occur 1.when i remove the trigger, data is getting inserted from asp...more >>