I am a Web developer. I am new to VB 6.0 and Crystal Report. I have joined an organisation where there is an application running(developed in VB6 and crystal report 7). I have to modify one report. In two columns I have to make minor changes i.e put > and = operator. I am encountering following...more >>

Table1 contains many, many datetime values in Col1. What is the best method to select all values in col1 where the time (date doesn't matter, just time) is between 4:00 PM and 4:00 AM? I need to get all values between 4 PM and 4 AM, also all values between 4 AM and 4 PM. I've tried datepart...more >>

I currently have this stored proc but wish to pass the serverName as a parameter. How is that done? Create Procedure PFT_InsertPatInfo @PatNo int AS SET NOCOUNT ON DECLARE @CheckForPat int SET @CheckForPat = (Select COUNT(*) FROM [MDsync3\OFFICEMEDIC].OfficeMedic.OfficeMedicData.Pati...more >>

To all: I am a beginner on SQL statement and need to know how to write the right SQL Statement to obtain a new column of results that will come from the addition of two dataset located into two different column. For example, I have the following table: ID# Customer_1 Cus...more >>

Hi, I work on SQL Server 2000. I would like to convert code into a stored procedure. However when I work on this, I get an error: This stored procedure takes all the records from a subordinates table and dumps it into a Tree table. What I do before this is to drop the existing tree and stac...more >>

Hi, I use sql 2000 server and full text search. I would like to use fulltext thesaurus feature. Some how the thesaurus function does not work. What would be problem and how to solve it in SQL 2000 Server not SQL2005 we don't have enough money to upgrade it : ) ? Thanks There is a table ...more >>

SQL 2k. I have a stored procedure that returns a dataset. I need to call that procedure in another procedure. Here's the idea of what I'm doing (oversimplified but it should illustrate what I am asking): Procedure1: SELECT c1, c2, c3 FROM Customers SET @iError = @@ERROR IF @iError <> 0 R...more >>

I have a UDF to count the number of responses taken for a specific survey and use it to update the surveys record: ALTER FUNCTION [dbo].[AIM_fn_updateResponseCount] (@intSurveyID int ) RETURNS int AS begin declare @return int SELECT @return = count(*) FROM usd_response WHERE surveyID = @i...more >>

I need to insert a two-letter state abbreviation into a 'state2' field in my sql database in the first 67 records of the county_details table: insert into county_details (state2) values ('al') where couid in between 1 and 67 ....doesn't work, error being there are non-null fields that can't ...more >>

Hi all, I have created an endpoint at certain port# but I can't access it thorugh IIS. CREATE ENDPOINT GALACTIC_endpoint STATE = STARTED AS HTTP ( SITE = '*', PATH = '/GALACTIC_EP', AUTHENTICATION = (INTEGRATED...more >>

DECLARE @space_in_MB INT SET @space_in_MB = 10081216 SELECT @space_in_MB/1024 -- Gives the output as 9844 But in real division, 10081216 / 1024 gives 9844.9375. How can I get that decimal value (with only max 4 digits after decimal point) from the query? Thanks! Anna ...more >>

I have got VStudio 2005 profesinal on my machine. Does that mean I have SQL Server 2005 installed ? I can't see any in my start->programs All I can see Sql Server 2005->Configurations Tools can somebody help me ...more >>

I got a mathematical question here; I have two counters and I want to get the percentage of improvement between the two counters .i.e. if counter1 = 20 and counter2 =35 what is the improvement percentage between the two counters. I have tried this: ((35 - 20)/20)*100% = 0.75 ...more >>

This must be one of the most common queries. Still, as a programmer, I've never been comfortable with SQL. So, I'd appreciate your help. Query: SELECT c.AccountNumber, c.Name, co.Name AS ContactName, co.Phone, co.EmailAddress, sp.StateProvinceCode, a.AddressLine1, a.AddressLine2, a.City...more >>

Ive created a query with group by that utilizes COUNT however i don't want it to count 01/01/1900 eg 01/01/2006 02/01/2007 03/03/2006 01/01/1900 01/01/1900 count should be 3 is this possible using groupby ? cheers mark ...more >>

I have to create a report to run monthly that summarizes data across a row, as well as down a column, based on a 2 character business area, as well as a 2 character channel. There may be shipments of a particular business area in one month, and there may not be shipments in another month. ...more >>

In my line of bussiness it is not possible to help every client on this issue (several thousand users) What I need to achieve is transferring backup to the server by using SQL Server to do it and restoring it with SQL Server. A solution for SQL 2005 would be perfect (it is not necessary to solve...more >>

All, I have a table containing the following data: CustNo Qty Brand 302 3 Brand 1 302 1 Brand 2 400 1 Brand 1 402 2 Brand 3 The report needs to look like the following (below) where the Qty is summed per custno & brand. ...more >>

Hi All, I have one user using integrated security that cannot login to any database on my server. I have checked his login/permissions several times and I have hundreds of other users that can login fine. I believe that his problem lies somewhere between his network account and his softricity s...more >>

Using SQL 2000 Table 1 idlot idrma part etc...... 1 11 a 2 11 b 3 11 c Table 2 idseed idlot recqty etc..... 1 1 50 2 3 45 I need to write a query that returns the idlot wh...more >>

Hi everyone! I have two SQL Server 2005, Server_A and Server_B. On Server_A, I created a linked server (Server_B). On Server_A, I created a view that looks like: CREATE VIEW [dbo].[vwTest] AS SELECT LastName, FirstName FROM [Server_B].test.dbo.table_1 The view returns corr...more >>

Hi! I'm putting together values into a temp table, then I'm updating table Subscriptions with the data in my temp table. The problem is I need the @@identity in return from the inserts, inserted into the temp table for later use. So this is how I would want it to work: insert into Subscr...more >>

All, I have a a sql script that updates some tables in a database but the database name can be DB1 or DB2. Before I use the "USE DataBase" command, I would like to find out if which database to run the update against so the script won't fail. Is there a statement I can use to do the fol...more >>

HI all, I have a adjacency tree model. Each leaf node in the tree will have a value. But each leaf node needs to roll-up total to its parent node, then that parent node needs to roll up to its parent. All the way up the tree to the root. I don't think that this is simple GO CREATE TA...more >>

tbl(fld1,fld2,fld3) fld1 fld2 fld3 2 3 4 3 2 5 2 3 4 3 9 5 3 9 5 i want to make like below fld1 fld2 fld3 2 3 4 3 2 5 3 9 5 namely, duplicate row deletion. i want to query stateme...more >>

Hi, I would like to catch the error of a DTS package and display it exactly how Entreprise Manager displays them. The environment used is one remote SQL server 2000 and one ADP client (2003) which triggers the DTS package through the OLE sp (creation of the package, execution and clean up). I...more >>

I'm trying to write a constraint that will evaluate true for any nchar string.... what nchar value will make this expression always true anystring <= 'the value I'm looking for' Rules: The only comparison allowed is <= No functions may be used such as unicode() etc The reason i ne...more >>

First i am newbie in vb and Sql server... Is possible to create and attaching, via vb classic or VBA, a sql database in this instance:\\DVD377-14D9E48C\SQLEXPRESS... I have Sql Express. Database name: mydatabase Database Table: mytable fileds: fiedl1 text format fiedl2 text format fie...more >>

Hi All, I want to know HOW and WHEN I have to use indexed views? Thanks, Nassa ...more >>

Hey guys, Im actually new to this axapta X++. for Axapta 3.0.. especially I really don't know where to find suitable resources to improved my skills.. I need you all to help me.... Currently I'm working on a project which require me to learn X++, where I need to catch up the X++ skills.. Fo...more >>