Hi all, i do have a new module named as Project Costing, in which i have to create a Heirarchy of Activities, Some thing of this sort Project |---Phase1 |--Stage1 |---Phase2 |---Stag...more >>

Hi Friend, I am new to ASP with SQL 2000 connection. I need to use Server Side Include file for connect SQL 2000 using VBScript. According to my project, I will connect from my asp page to that include db file using function. I am using ODBC DSN. If you have Server Side Include sampl...more >>

Hi, I will try to explain: I want the proper grouping and display counts. This query works fine, see below some of the returned results. SELECT TempD.state, TempD.City, TempD.Zip, count(TempE.ID)AS total FROM TempE INNER JOIN TempD ON TempE.N...more >>

I'm not sure what this process would be called. I've got 2 columns... [A] = FamilyName [B] = FamilyMembers I'm trying to make this... [A] [B] Doe Alan Doe Bob Doe Betty Doe Joe ....into results like this... [A] [B] Doe Alan, Bob, Betty, Joe i.e. Group c...more >>

Hi, I am trying the following (what should be easy), select and I don't seem to get the correct results - I am getting some upper case results as well: select identifier FROM WHDATA1.DBO.ENDORSEMENT WHERE WHDATA1.DBO.ENDORSEMENT.POLICY_NUMBER = STAGE_PHX_FACT_POLICY_AP.POLICY_NUMBER AN...more >>

Why doesn't my identity property function normally when I try to insert through a view? --I create base table with identity property CREATE TABLE _t (id int identity ,num int) --then insert a value INSERT _t(num) VALUES (1) --create view on base table CREATE VIEW t AS SELECT * ...more >>

I am trying to get a table to display where my like rows would sum together, but now matter how I do it there are 2 rows (in my example) that always show as separate rows and I want to combine them. For example: ProductName Balance 30 60 90 -------------------...more >>

I have a table which gets it feed from external source. I need to chnge the length of the column on DBs which are in Prod. The table has couple of indexes and FK relationship (NOT on the column that I need to change). Number of records is around 36 million. I have never done something like t...more >>

I consider security A to be equivalent to C so I want to consolidate these positions. Three scenarios: If an account holds both A and C I want to add the C quantity to the A position and delete the C position. If the account holds A but not C then no action. If the account holds C but not...more >>

Hello NG How can I use a variable for datetime in a where clause. DECLARE @varDT AS DATETIME SELECT @varDT = x.TESTDT FROM(SELECT TOP 1 [LabelDateTime] AS TESTDT FROM TABLE1) Records Actually Total 6 Tried: SELECT COUNT([LabelNumber) AS TESTLC FROM TABLE1 WHERE [LabelDateTime]=@v...more >>

Hi.. I am a new programmer and inherited an application that has over 200 + tables. Does anyone know a quick or simple process to determine if a table has been utilized recently? Trying to avoid going through each SP and report. Would the diagramming tool work ? appreciate it! -- ...more >>

Hi all, I'm trying to search in a column and remove a comma and what comes before it. like this: AL, Alabama FL, Florida then should look like this Alabama Florida trying to use the replace with wild card but doesn't seam to work? Any id...more >>

Guess what? The DateTime rounding bug never got fixed in SQL Server 2005. You know, this one: SELECT CAST('10/25/2005 23:59:59.990' AS DATETIME) AS [990] SELECT CAST('10/25/2005 23:59:59.991' AS DATETIME) AS [991] SELECT CAST('10/25/2005 23:59:59.992' AS DATETIME) AS [992] SELECT CAST('10/25/...more >>

I have two servers that are linked together ServerA and ServerB. I can do selects from remote tables on both servers with no problems. The problem that i am running into is when I am doing an insert into a local table via a join with a local and remote table. Both Win2k3 server with SQL 200...more >>

We have an ODBC application running a query that runs much slower through our app than in SQL Query Analyzer. Is SQL Query Analyzer using ODBC to connect to SQL Server? If not, what technology is it using? Thanks in advance, Abram ...more >>

Hello, I've a problem setting up a constraint on a table. There are two primary keys in that table and one of them will be filled in through an access application, wether it be nothing or some integer value. What i want to do is to set a zero-value in a primary key column, how can i d...more >>

I have an sp that I am trying to run, but it keeps failing. Something like this if a.one='PA' then begin select * from a else select * from b end I keep getting errors. I have tried a CASE statement, but it does not seems to work...more >>

hi iam a csharp developer . the problem is i don't know how to select in systables of sqlserver ...more >>

i'll be appreciated any help ! ...more >>

Hi, I am getting this error while trying to join two tables on two different databases. How can I find out the collation on each and how can I make them similar? Plz help. Thnx in advance...more >>

Hi All, I'm working in a sp to get info from a users and companies table but I'm passing parameters for my where validation statement. CREATE PROCEDURE GetCustomers @searchKey varchar(50), @filter int AS select co.companyname, s.statusdescription, isnull(u.usermiddlename, '') as userm...more >>

Hi All Wonder if you could help, I have a bog standard table called STOCKPRICES that has served me well for a while, but now I need to change the structure of it and because a number of users have used it in it's present form I need to so the following in SQL script: a) Grab a snapshot o...more >>

I am new to SQL Server and I am trying to write a trigger where I am doing a delete on another table. I need to know whether this delete fails or not. How can I achieve this? -- TIA Altman ...more >>

I have one table of products: create table XPRODUCTS (prod VARCHAR(4)not null, pdesc VARCHAR(30), x1 INT, x2 INT, x3 INT, x4 INT) and another table of items: create table ITEMS (itemno VARCHAR(4) no null, descr VARCHAR(30), price1 INT not null, price2 INT not null) XPRODUCTS is created v...more >>

Is there a way of entering maintenance mode ("-m") through Enterprise Manager (2000), rather than running sqlservr.exe directly? Thanks! ...more >>

What are the most effeicent primary keys? Is a Varchar or binary datatype bad for a primary key? ...more >>

hi iam a csharp developer . the problem is i don't know how to select in systables of sqlserver ...more >>

How can I cast a datetime to a format of yyyymm? firstdate and seconddate are both datetime fields and I want to use them in the yyyymm format in my where clause below. Declare @curdate datetime Set @curdate = 2005/11 select firstdate, seconddate from dates where @curdate between ...more >>

I am using the following snippet of code to help me convert the date and time in a query I am writing. SELECT dbo.Users.FirstName + ' ' + dbo.Users.LastName AS Student, dbo.Subjects.Subject, Convert (Char(15),dbo.TrainingSchedules.RequestedDate,101) AS Date, Conv...more >>

Hi all, I have a somewhat unusual circumstance. I am submitting several stored procedure calls in one statement (from a remote handheld device, as it happens, using an rda.SubmitSql command - it's a LOT faster than sending them one at a time, so this can't change) to an MS SQL 2000 database...more >>

Hello there. I have a dynamic SQL query (I had to use it - I swear!) that returns a single integer value. However, I'm having trouble capturing the value in a local variable. Any ideas what I should do with my syntax (to get it working I mean...)? declare @SQLQuery nvarchar(1024) declar...more >>

I have two tables Table1 Item# -Descr-Amt xyz1- Orange - 250.00 xyz2 - Apple - 350.00 Table 2 Item#-Tax-Amt xyz1-Tax1- 2.50 xyz1-Tax2-3.50 xyz2-Tax1-3.00 xyz2-Tax2-4.20 I will like have a query to show data as Item#-Descr-Amt-Tax1-Tax2 xyz1-Orange-250.00-2.50-3.50 xyz2-Apple-3...more >>

We are web developer. The paging features of SQL Server providing will great to improve the development time. Is there any new features on SQL Server 2005 for paging? ...more >>

if it is possible, how would i go about creating routines (storedprocedures?) that can be invoked from a microsoft access ADP file that will backup (and hopefully have the ability to also restore) as SQL Server database? thanks for any and all help! ben...more >>

I am upgrading an Access DB to SQL Server. I have a table in the database that looks like this, tblContacts RegNo - Primary key Name Relationship Phone WorkPhone Name2 Relationship2 Phone2 WorkPhone2 Name3 Relationship3 Phone3 WorkPhone3 Name4 Relationship4 Phone4 WorkPhone4...more >>

Hi all, I have a DTS package that gets information out of a Pervasive db and drops it into SQL. I need a count on how many distinct loan number are associated with specific actions (ie Closing Date, Funded Date etc). I have 2 tables: 1 contains a reference number and description (ie 170 ...more >>

I have a table that I need to sum up grouped by month. However, every day of the month is there. Here's thy SQL to build the table: CREATE TABLE [dbo].[asr_article_views] ( [id] [int] IDENTITY (1, 1) NOT NULL , [log_date] [smalldatetime] NULL , [sec_id] [smallint] NULL , [sub_id] [small...more >>

SELECT MIN(Salary) FROM ( SELECT TOP 10 Salary FROM tblEmp ORDER BY Salary DESC) AS X As such the resultset of the above query will only have the record of the Salary column. I want the record of another column named EmpName as well in the resultset. So where do I accomodate the 'GROUP BY EmpN...more >>

Hello! I am looking for creative ideas to the following situation. Currently I receive multiple .dbf files coming in from multiple locations at the end of the day. I then use DTS to bring those files into their appropriate tables in a sql database. However, now we would like to get the i...more >>

I would like to execute a stored procedure listed below then capture or print out the execution time. Lastly rollback the transaction so that data does not change in the database. dbo.usp_Manual_toTraint 65823,'2004-08-01','TA_BB','2004-09-01' Please help me with this procedure. T...more >>

Hey all, I have this value in a field: 0.I.3.* Is there a way to make the above like the following: 1.I.3.* I have a lot of records that need this change. thanks, rodchar...more >>

Hi, I am new in T-SQL and I am trying to transform a personal number to a special format. I am using DTS to import two tables into SQL Server. One table has the personal number format, that the number is every time 8 digits long e.g. 00000001. Another table has the same number in the format 1...more >>

Hi there. Does anyone know of a way to get the following statement to work without using dynamic SQL?...... I'm trying to get a "select TOP" to work while passing in a parameter as 'N' for 'select the first N rows...' declare @NumberofRecords integer select @NumberofRecords = 5 sele...more >>

HI, How do I rewrite the first query using the datafrom query 2 so that I can do multipe inserts for all the units given this input: @EnrolmentID, @dteEnroled, @Outcome, @CourseID -- 1. This creates one unit enrolment using parameters INSERT INTO tblUnitEnrolment (EnrolmentID,Enrol...more >>

Hi all, I have a problem but am not certain if it is a server och programming question. The post is going to be rahter long... Anyhow, this is the scenario Setup: Sql2000ent sp3a, failover cluster, 2nodes Involved procedures and tables TABLE Applikationer CREATE TABLE [dbo].[applikatio...more >>

Hi, is there a SQLServer utility or tool to equip regular non-techie users with the ability to create, run and save their own reports? That would be similar to the Webintelligence product of BusinessObjects: It's basically a graphical drag&drop tool for creating SQL queries with "more Englis...more >>

Hi, I have heard that writing: SELECT FirstName, LastName FROM Customers WHERE 1=1 instead of: SELECT FirstName, LastName FROM Customers speeds up the response to get back records from the database. Is that true or just a myth? Thanks, ~yamazed ...more >>

Found an article today: http://www.dbazine.com/ofinterest/oi-articles/celko14 Tryed it in SQL server, doesnt work due to the fact that SQL server doesnt treat count as sum. This query gives the wrong answer, the usage of count taken from the Celko-article. SELECT COUNT(CASE WHEN x0 = ...more >>

I have a strange problem. I have reduced the problem to this: SELECT COUNT(CASE WHEN x0 = 'A' THEN 1 ELSE 0 END) AS a_tally ,COUNT(CASE WHEN x0 = 'B' THEN 1 ELSE 0 END) AS b_tally FROM (SELECT 'A') AS X (x0) I exppect this to give me the result a-tally = 1 and b-tally = 0. Ho...more >>

I got two same tables (invoice, invoice_history) When user insert the record, (i will save a copy in the table invoice_history) when user amend the record, (i iwll save the updated record in the table invoice_history_too) Now, I am worry that I don't know how to do that by trigger rule. If i...more >>

The Where clause is below. The data I am pulling has 4 fields with numbers in them. These 4 fields do not contain NULL values. I am trying not to pull a record if all 4 fields are zero but my query does. where GLBA.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID And GLCC.SEGMENT4 = VW...more >>

Hi, I am writing a code which is actually performing multiple inserts on a = table. Currently I am combining all my insert queries and passing as command = text to ADO command object. There is one more way by opening a recordset and call AddNew on = recordset multiple times and then batch up...more >>

We have a column called Commission that is derived by using the mathmatical expression ISNULL(ROUND(Price * CommissionPercentage / 100, 2), 0). This column then needs to be referred to by other columns within the query. E.g. I need to work out CommissionTax and CommissionTotal CommissionTa...more >>