Hi, I am facing a very strange problem with FTS. I have a full text enabled table in which i have column with few integer values. If there is more than one integer value in any row then it is separated by space. e. g. Id Field1 -- ------ 1 10 11 2 23 45 Now when i make a search...more >>

Ok, guys...I got a challenge here. I am working with SQL Server I have a highly normalized transaction database design. Assume that I have 8-12 "fact tables". Some people call them "nouns"...basically, I have alot of tables that maintain entities in my DB Each of these entities can have 1 or ...more >>

Hi, I'm looking into making a combined SQL Server / Index Server search on a website. So what I'm asking is if anyone knows how to search the Index Server within a stored procedure. Got any clues? Thanks in advance. Kind regards, Tony Lorentzen Freelance Webdeveloper, Denmark ...more >>

Hi All Please don't provide any URL.... I need to write a SQL query for my O/P looks like (Basically to rotate the data) Use the below script to understand the requireent..... Existing Records in the Table ---------------------------- PH USL 7.500 PH LSL 9.500 PH UCL 7.600 PH LCL...more >>

Hi, When I call an SP, I want to do an update to a record AND show the results in a SELECT statement, all within the same SP. How can I do this? For example, I have the following: UPDATE authors SET price = price +100 where authorid = 1 IF (SELECT price FROM authors WHERE authorid = 1) ...more >>

Hi All I need to write a SQL query for my O/P looks like (Basically to rotate the data) Use the below script to understand the requireent..... Existing Records in the Table ---------------------------- PH USL 7.500 PH LSL 9.500 PH UCL 7.600 PH LCL 9.400 PH Units NULL PH SSize 1.000 ...more >>

--SQL Server 2000 In one Stored procedure i bulk insert a text file with no problem... and in another stored procedure i bulk insert an almost identical file and get an error. i believe the table's from the looks of it are identical except for the names. sorry if this is a vague question...more >>

Hi All! I'm having some trouble getting Three DB fileds into one Total alais.... Tried the following: Select SUM({myfield1,myfield2,myfield3, Total.VALUE}) from mytable Select SUM(myfield1,myfield2,myfield3) as Total from mytable Anyone know a work around or how this is done? Thank...more >>

Hello all! I'm having some trouble getting the value of three db fields into one alias field..... Select Sum(myfield1, myfield2, myfield3) as TotalSales from mytable Select Sum({myfield1, myfield2, myfield3}, TotalSales.VALUE) from mytable No luck with either.... does anyone know a wo...more >>

Greetings, I am new to sql world, and want to learn the various ways a complex stored proc. can be debug, Thanks a lot. ...more >>

Hi all. I'm writing a fairly large SQL script and I'm a little confused on when I should use the "GO" statement and when I shouldn't. Is it basically that a "GO" should happen after every logical unit of work in the script or should one "GO" be sufficent for the whole script? SQL Server 2K...more >>

How can I find the collation sequence of a specific column ? TIA Boaz Ben-Porat Milestone a/s Denmark ...more >>

I am using SQL Server 2000. I have a table in which I have individual records for each time a judge judges a unit. Each event uses five judges and the sum of those five judge's scores makes up the final score (Gross Score). The fields include [Unit Name], [Judge Name], Contest, Date, [Total Scor...more >>

How Could I run a dynamic with a Sentence larger than 4,000 chars; if th sp_executesql can just run NText, NVArchar and NChar and they just admit values from 1 through 4,000. I have tried doing something like EXECUTE SP_EXECUTESQL @SqlStr1 + @SqlStr2 But it can not concatenate that sentence ...more >>

Hi, I would like to write a stored procedure that contains a where clause as following: Select field1, field2, status from table Where Status IN ( @a) @a could be new, pending, complete, new + pending, new+complete... ect. Can this be done? Thanks, Culam...more >>

I want to capitalize all the items in my 'Products' field inside my 'category' table in an sql database, but can't get ucase( ) to work on the query. Any tips? thanks in advance Muench *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get r...more >>

Hi, Recently I was running a query in the sql analyzer to view the execution plan. The query selects values from the table with a condition. None of the columns (both select, conditions) are indexed. For.e.g select a, b, c from d where e = 20; (none of a, b, c, d or e is pa...more >>

I've got a join question I can't seem to figure out. I have two tables, employees and policies. This is a one to many relationship (One employee can have multiple policies assigned to them) This query is based on a particular policy, I want to get a listing of all employees, and some field ...more >>

Hi, Is there any way to get an object ID for the the stored procedure or trigger that called the currently executing stored proc? That is almost like @@PROCID will give me the ID of the currently executing proc, but if @spCurrentProg was called from spCallingProg, or trigCallingTrig .. then I...more >>

Hey guys, I desperately need help. We have an SQL database that can be accessed successfully from console and windows applications. However, essentially the same code fails at login when trying to access web applications. The error message is: Description: An unhandled exception occurr...more >>

Hi all. We have data like this positionType id lastname ------------------------------------------------ Teacher 170011 Kline superintendent 170011 Kline We'd like to have the data output as the following for each id, positionTyp...more >>

Hello In ASP.NET I get the current Date Format String via the actual culture: CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern; This looks like 'YYYY-MM-DD' or MM-DD-YYYY and others. I would like to format my date according to that date format string. In Oracle this would be ...more >>

Hi, I have a table with 990 rows, I want to be able to copy these rows and attach them on the end of the last row, any ideas on how I can do this? Would appreciate the help. Thanks Damon ...more >>

I'd like to pass a list of UserID's to a stored procedure to be used in an Update statement. For example, I want to update the IsPaid flag to 'Y' for UserID in (1002, 1004, 1005, 1050), such as: declare @userIDs as varchar(50) set @userIDs = '1002, 1004, 1005, 1050' Update Users Set IsPai...more >>

Hi, I have a column full of rates which I need to copy into another tables column and then increase the figures by 15%, anyone have any ideas on how I can do this, would appreciate the help. Thanks Damon ...more >>

Here's a query string I'm using: Select top 10 Postid, postdate, Application, title FROM WePostings WHERE Application=News The Application field was originally a CHAR field and that had some spaced padding the value, so I decided to switch that to a varchar field and convert all of the fiel...more >>

Can a DTS package be triggered to run from an Access 97 front-end? IE. when a user clicks a button or something similiar. Thanks M...more >>

Hi all I'm tring to create the IIF function that exists in Access but not in SQL So I am doing this Declare @False nvarchar (255 Declare @Result nvarcha Set @expression = '2 = 1 set @True = '1 set @False = '2 set @Result = execute 'If ...more >>

hi this is what i have SELECT COUNT(*) FROM r5stock WHERE sto_store = 35 AND sto_stocktake = "current date" sto_store: store# sto_stocktake: date in format 03/02/2004 now what should i put in place of "current date" so that whenever i execute this statement it will automatically qu...more >>

Hello, Does anyone know if there is a utility out there that you can point at a table and have it produce SQL "Insert" statements for each row into a file that I can then run within QM? I find that DTS is finicky...sometimes saying that an import worked when in fact it didn't. This way I wo...more >>

Hello, What is the easiest way to determine the modified date of database objects (sprocs,udfs,table schemas) ? It sure would be nice if EM had a modified date instead of only a create date. Paul ...more >>

Is there a hard fast rule on when to define a Clustered Index vs a NonClustered Index for a table. Many of my tables have a UNIQUE GUID for the primary key. Should this be Clustered/NonClustered Some of my tables have an UNIQUE IDENTITY column seeded sequentially. Should this be Clustered/NonClu...more >>

Hello, I add my data from sqlserver to dropdownlist on formload.I wanted it doesnt load data every time on form load.I made if session is null then load if session isnt null dont load.I add to sqlserver a new data ans I make session is null.But in dropdownlist I coudnt see my new data.I use bel...more >>

I have a file which has duplicate key values but I need an SQL statement to select just one value where duplicates are found and base which one is selected on a record count. For example In table tblOrderHeader Customer Sales Rep Record Count 111 789 12 111 ...more >>

Data would be as follows: Id Value Date 1 123 2003/12/01 2 234 2003/12/03 2 345 2003/12/04 1 678 2003/12/02 etc.. I need a query that gives me only the most recent record for each ID, ie 1 678 2003/12/02 2 345 2003/...more >>

Hello All, I'm trying to assign the results of a store proc to a variable. Seems easy enough, but, constantly getting a syntax error near the key word exec..haven't done it before so excuse my ignorance.. Any help is appreciated. Here is the SP and below it is the code that causes the ...more >>

Can someone explain this, and most importantly how to correct it. Server: Msg 7347, Level 16, State 1, Line 2 OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[LINKED-TOTALVIEWDB]. [/usr/prms/run/db/statdb]..[schedule].SCHEDULE'. The expected data ...more >>

Hi, I'm trying to use sp_executesql but keep on exceeding the 4000 character limit. I've read you can use both EXEC and sp_executesql together but am having trouble with the syntax. Here's how my stored proc looks like: ALTER PROCEDURE UsingEXEC AS DECLARE @sql1 nvarchar(4000), @sql2 nv...more >>

Hi I have the following query SELECT fund.pi_code, fund.pi_name, trans_detail.fund_number, SUM (trans_detail.trans_amount_gl) AS budget FROM trans_detail INNER JOIN fund ON trans_detail.fund_number = fund.fund_number INNER JOIN budg...more >>

Sorry to be dense, but what is a "cube"? Is it a data type like ntext? Is it a file? Thanks for any clarity. Bob ...more >>

Ok, I've a table with a field that is 1440 bits long (for every second of a day). The field has an ASCII symbol for each bit, I have to convert each bit to it's ASCII Numberic equivelent and join that to another table to understand what happened that second of the day. I've created a mo...more >>

I have a small SELECT query where I need to specify a "yes" for value on a column if one or more of several other columns' values are yes. SELECT column1, <column2 should output "yes" if column3, column4, or column5 are yes> FROM table1 HELP? _____ DC G ...more >>

Hello all! I just installed SQL Server 2000, Developer Edition, plus SP3a for development purposes, but I can't seem to locate a clear description as to how this product is different from other editions. Does anyone have a web page I can look at or some quick info on this? I found the fea...more >>

Hi I have a proc that takes @ValueDate as datetime. I want to debug it but when I pass '2004/03/02' with or without quotes I get the following error [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specificatio I even tried passing CONVERT(DATETIME, '2004-02-03 00:00:00', ...more >>

I hope this makes sense. I need to pull some records from a database based on a specific criteria. So, I'm using a query string and want to pass that into the SQL Query statement to get the specific records. So, query string = 'news' and my SQL query will be '...WHERE category = query str...more >>

I am trying to optimize a stored procedure that uses cursors extensively. Each row in the data has a column of dynamic sql that must be run to determine if the row is valid, hence the cursor. While trying to optimize the procedure, I noticed that adding FAST_FORWARD to the declaration of the ...more >>

I have table1 with two columns: userid int dob datetime Some of the dates were incorrectly entered and only the year must be changed. For example, 2063-02-01 needs to be changed to 1963-02-01. I need a sql statement that will process the table looking for rows where the year in the...more >>

Hi Sorry, I made a small omission in my previous posting while cutting & pasting the SQL.... ---------------------------------------- I keep getting this error: Server: Msg 8630, Level 17, State 98, Line 1 Internal Query Processor Error: The query processor encountered an unexpected erro...more >>

How can I determine if a temporary table exists or not? I need to figure that programmatically to create a #temp if it does not exist. I cannot check in sysobjects as it is created in tempdb. I cannot check in sysobjects in tempdb as some id is attached to the name. Any information will be helpful....more >>

I need to select top ten records. What should I do in my SELECT ? -- with the best regards, Mikalai Beliashou ...more >>

I have a string stored in a table as a text data type and I wish to execute that string but can't seem to work it out - help ...more >>

Hi I have a table with a date column called date it is a smalldatetime and is a default as getdate now I am not sure how to create a dynamic view that will display all the previous days data that was entered thankyou for any help Mikey...more >>

Trying to run a nested loop within a SQL script. Continue to get errors about the nested loop, and 1 of the variables not being defined. Any help will be greatly appericated. Thanks, Darrick /****** Object: Table [dbo].[TUschedule] ******/ if exists (select * from sysobjects ...more >>

I read that use SELECT / INTO statement to directly create and fill temp table, places locks on system table. Does it mean that in interval of running that implicit transaction I cannot modify tempdb and create another table? BOL doesn't say anything about this behaviour. ...more >>

Blankhello professionals, is there any articles or simple codes, or maybe possibility on how to = assign the value or contents of the declared variables from vb6 going to = declared variables of stored procedure of sqlserver... thanx in advance! --=20 {ALEX}...more >>

Hello im trying to install sql 2k on a win 2k server machine and its driving me nuts..... as soon as i run the installation it tells me: "A previous installation created pending file operations on the installation machine. You must restart the computer before running setup" ok, ive r...more >>

In one of our reports, (stored procedure driven) if we select a date range of more than one day we get accurate information for the period re: sales and leads. However, if we select a day at a time we do not get the same results My question is: Is there a time frame that needs to be incorporated...more >>

Hi, I am getting following error when I try to execute a stored procedure which uses Transactions. "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION." The procedure does have both Begin and Commit Transaction statements. I would apprecitate if anybody can tell me why...more >>

Hi, All, (SQL7.0+SP3 using VB interface) I have a stored-procedure to set up the Fin_date to terminate the service for customers. You can run the SP again with different parameter @Fin_date and the Fin_date will be overwritten by the last one. today, a CSR told me that SP doesn't work well....more >>

I have a result of a select statement that looks like this: description category --------------------- abcd 0-1 abcde 0-1 abcdef 0-1 dcba 1-2 dbcbae 1-2 dbcferti 2-3 I'd like to have the following columns: 0-1 1-2 2-3 Is that possible? ...more >>

Hi I have a smalldatetime column named date in a table and wondered is there any way of automatically entering the date in the column for each new row of data entered into the table for the corresponding date it was entered Thanks for any help Mikey...more >>

I know how to GRANT permissions to one object at at time. But... What is the best way to GRANT EXEC permissions on "all" my stored procs in the fewest lines possible? Thanks ...more >>

I am attempting to assign a batch and line number for a set of transactions. The batch number is unique for each batch code date combination and the line number is unique for each for each batch code. The interesting thing is that if I run the query with a "top 1" everything works fine, any...more >>

I'm new to SQL Server and I'd like to create an insert trigger that will compute a column value based on another table. The test table I am using has 3 fields : Id (identity field), Alpha1 (Alphanumeric value) and TestId (value to compute). The trigger will access another table (name = Anoth...more >>

I am tring to create a trigger that takes each inserted row cleans up the address ( via a extended stored procedure ) and writes it to another table. The trigger works fine for single inserts but not for mulitrow inserts. I tried putting each inserted row into a temporary table from the inser...more >>

Hello All, When I run DBCC SHOWCONTIG (tableA) it returns everything expected, but, the 'Logical Scan Fragmentation' row. Why is that? Thanks in advance. Rob ...more >>

On the SQL server 7, stored procedures could be updated, but the timestamp is not changed. Does anybody know what is the way to do it? It makes very difficult to track back and see what happened in case of a problem. Thanks very much...more >>

Hi, how do i get the output parameter here? I get the error message "Invalid Column Name 'CAST_ID' for some reason I don't understand. CREATE PROCEDURE MTS_GET_NEXT_CAST @cast_id varchar(20), @cast_id_out varchar(20) output AS SELECT TOP 1 [CAST_ID] as CAST_ID FROM V_STEP_DATA ...more >>

Hello I have a small problem with a "select" statement. I have a table with numbers of columns. For now lat say I have in the table Three columns: id integer . Name varchar and CPU float. How can I get the top 10, highest 10 CPU (of course I have much more then 10 rows in the table)? I tr...more >>

I need to have the Order#,Line#,....etc in a table The SELECT examples are concerning out..(correct?) I need to know how to set up the table.. IDENTITY on Line# isn't working...doesn't reset on each Order. Can the MSSQL backend keep these fields for me? I already have a table for the Orde...more >>

A little help please :) I need Order#'s and Line#'s within the Order. Each Order should restart at line 1 I've tried Auto-incr and Indentity but it get this: ORDER# Line# Items.....etc ORD0001 1 aaa ORD0001 2 bbb ORD0001 3 ccc ORD0002 4 kkk ORD000...more >>

Hi ALL I use a @tablename in a select statement ie Select * From @tablenam I believe to get it to work and act as a select staemant I need to do Declare @str VarChar(300 Declare @tablename Varchar(300 ...more >>

I have severay tables all linked by a Client_Ref Field. Im need to find out if any of the tables are missing records for any of the client TAdmi Client_Ref VARCHAR(6 CompanyName VARCHAR(25 TComm Client_Ref VARCHAR(6 TAccount Client_Ref VARCHAR(6 TFee Client_Ref VARCHAR(6 TUser Cl...more >>

Is possible create a new table in master database with the flag 'System'? Thanks, Rui Oliveira ...more >>

I would like to add a word.doc to a table column or link the doc to the record. The doc is a mixture of text and graphics How do you add the doc and how can you read it ? ...more >>