Hi all, Its great to see that so many ppl helpout each other. I hope I can do the same on day :), anyway Can any one please guide me that how can i make a runing column in result set e.g. i have a query select au_id,au_lname,au_fname from authors which returns au_id a...more >>

Hello, How do I set the column of a table so that where it equals null it gets populated with a certain value. What I have tried is: update HAIRCUT set HAIRCUTCD = '001' where HAIRCUTCD = NULL and update pipe_pipeNo set ContractId = '001' where ContractId = 'NULL' and upda...more >>

Hello, I've an issue with converting varBinary data into other data types. The column definition is varBinary(2498). How do I pull the data out for a user? Here's what I've tried thus far: DECLARE @myval decimal (5, 2) SET @myval = 193.57 Insert INTO Test_Tbl1(varBintst) ...more >>

When I look at the execution plan of a query all steps are 0%. Now when I change my local settings from Dutch to United States it comes up correctly (same query of course). See here for Dutch: http://www.entrysoft.com/be.jpg Here for US: http://www.entrysoft.com/us.jpg Is this a known bug?...more >>

Hi, I know how to allocate a table to a particular user defined filegroups, while creating it. But how can one allocate other data objects like Stored procedure, functions, views to a particular filegroup Thanks in Advanc GYK...more >>

Sorry for reposting but I have removed all fields and tables that weren't necessary for this problem so it will be much easier now :) DLL: CREATE TABLE [dbo].[CodeLink] ( [CL_ID] [int] IDENTITY (1, 1) NOT NULL , [CL_COID] [smallint] NOT NULL , [CL_SNID] [int] NOT NULL , [CL_Begin] [sm...more >>

search word: ok if i use SELECT * FROM sometable WHERE someColumn like %searchword% it will return results that include these characters ex: look I would like to search the word "ok" in the db as a whole word. YES: dsfd dfdf ok dfdf NO: dfdsf look dsfsdf...more >>

Hello, Table 1: MainID Qty Message 1 3 "Apple" 2 5 "Orange" 3 5 "Banana" Table 2: MainID SubID 1 "A" 1 "B" 1 "B" 1 "C" 2 "F" 2 "F" 2 "H" 3 "A" 3 ...more >>

I have table with columns of start and end date. startDate endDate ID 2003-11-24 23:00:00 2003-11-24 23:10:00 1 2003-11-24 23:15:00 2003-11-24 23:20:00 1 2003-11-24 23:25:00 2003-11-24 23:35:00 ...more >>

Hi I know it's possible to do the following, but not sure of the SQL required. I've two tables, table A and table B Table A has amongst others, two columns 'person' and 'address' Similarly, Table B has amongst others, two columns 'person' and 'address' What I want to do is to get a sing...more >>

Hi, Does anyone know how I can reset an auto-increment field in a table (Microsoft SQL Server). So that it starts counting from 0... again? Thank you Maz. ...more >>

Is there a way within a curor to wait for a command to complete before fetching the next row? declare victim_cursor cursor for select spid from mast.dbo.sysprocesses where spid >=@spidlow and spid <= @spidhigh and db_name(dbid)='OnePoint' open victim_cursor fetch next from victim_cursor ...more >>

Hi, I tried to use table variable in sp_executesql statement, it failed. So I assumed that table variable can't work with sp_executesql because sp_executesql doesn't treat table variable as "variable" . Can you confirm this? thanks Joe...more >>

My db table looks like this FILENAME FILE_CREATED FILE_MODIFIED test 9/12 test2 9/13 10/13 .. .. all FILE_CREATED field have value, only some FILE_MODIFIED have value. I need to get the value of FILENAME column and this is what i have SELECT FILENAME FROM REW_FILES ...more >>

Is there anything in SQL Server 2000 that allows me to pull the greater of 2 columns in a query? Example. I have a row with 3 cols. In col1 is a generated key. Col2 has a date and Col3 has a date. In my query I want to return only the generated key and the column that has the greatest...more >>

I have a sql server table with a unique id for an individual and 11 languages, if they speak the language the value if 1 if they don't it is 0. How do I just query to get the individual and the first 5 languages they speak? I do not code well, and this is really baffeling to me. THANKS!!...more >>

I have three different stored procedures that have been performing very poorly. We finally tracked the problem down to SQL Server choosing a sub-optimal index in the query plan. For some reason it is insisting on choosing a clustered index scan instead of utilizing another index. We are havin...more >>

Our users have potentially dirty legacy data that they need to get into our application. We provide a set of staging tables, which map to our source tables, that the users do their ETL into. Every row in the source tables has a generated integer id. Every row in both the source and stag...more >>

Hello I have a function written in C that gets a string as input and returns another string that is manipulated by the function according some rules. I need to make an index on a field in a table in sql server 2000 based on the output of this function. How can I make it? I also need to write ...more >>

Looks like my last post didn't take. I received the following code from Pat (thank you!) CREATE TRIGER tiMyTable ON MyTable FOR INSERT AS UPDATE myTable SET strata = Rand() WHERE EXISTS (SELECT * FROM updated WHERE updated.SID = myTable.SID) EXECUTE sp_sendmail ...more >>

sp_depends doesn't return objects outside of current db how do I write a query that returns all objects names inside a procedure? for example, sp_find_objects @proc='get_employee_info' ...more >>

Hi All Wondered if you could help. Basically I have 2 tables that contain all the data I want for my report, but I need to put it in a particular way and I need to display it in an ASP page so my queries got to be manual rather than an MS Excel/Query 'munge'. To be honest, the report itse...more >>

Dynamic Query for Searching data I have a stored procedure which takes three parameters. The parameters would be null or would have values. Currently I am doing like the below listed code and it takes a long time to execute because of the Varchar conversions. Is there an easier and fast...more >>

Hello all, Does anyone know why I can't do this:? declare @numspec int EXEC(" SET @numspec = 3 ") I tried a multiline Exec with concatenated strings, but even this simple one doesn't work. ?? Thanks. Mia J. *** Sent via Developersdex http://www.developersdex.com *** Don't ju...more >>

Hi, Is it possible to save how a string looks? Say I string with the font strikethrough on can I save the string like that? Deke...more >>

This msg didn't appear first time for some reason (thanks Steve for letting me know :) I have a Codes table and a CodeLink table. I need a query that returns all the rows from the CodeLink. But I need them grouped by Code if the field CO_Group = 1 (CO_Group is a bit field of codes table). ...more >>

I am trying to use a SQL case statement inside another SQL=20 statement to calculate different values depending on the=20 value of another field. For example: SQLString =3D "SELECT bom_detail.id_seq as 'Item #', " _ & "Part as 'SSF_Part_#', Assembly as 'Subassembly_#', " _ & "lv as 'Level', ...more >>

I'm using bcp utility on SQL2000-SP3, from inside a stored-in procedure using this working syntax: exec master..xp_cmdShell 'bcp myDB.dbo.myTbl out \\eyad\rpl_root\myTbl.dat -Smysrv -Uuser -Ppas -CRAW -c' everything is ok for that. but when inputting: exec master..xp_cmdShell 'bcp m...more >>

I have two database dbA: dbA dbB: dbB dbA contain 2 tables: tbl_01A tbl_02A dbB contain 2 tables also: tbl_01B tbl_02B how to if I want to get the value from tbl_01A, and the recordset of tbl_01A would used for tbl_01B, in stored procedure. thx~~ ...more >>

Hello All, I'm facing the following two issues in a stored procedure: 1) I'm trying to open a cursor on a dynamic SQL Statement. Can this be done and if so what syntax would I use? 2) As an alternative to the above issue I tried to Insert the values of the dyamic SQL statement using the '...more >>

I have two fields in a table: SID and Strata. What I would like to do is when a new SID is inserted into the table, have a value assigned to Strata based on the Rand() function for only that SID. (one of two values at 50% each) Then I'd like to use xp_sendmail to send the SID and Strata values ...more >>

Hi I'm passing the following SQL statement to my SQLServer: RESTORE DATABASE myDB FROM DISK 'd:\mssql\backup2\myDB.bak' WITH MOVE 'myDB' TO 'd:\mssql\data\myDB.mdf', MOVE 'myDB_log' TO 'd:\mssql\data\myDB_log.ldf' However, when I run this, I get the following error: Server: Msg 3234, ...more >>

I am trying to write a SP that essentially calls another SP twice with different arguments and then returns the two recordsets as one. Here is the code as it runs in iSQL for testing. This works, returning 54 rows. DECLARE @OfficeCD VARCHAR(10) DECLARE @FiscalYr VARCHAR(4) DECLARE @iAppUs...more >>

"Jacco Schalkwijk" <NOSPAMjaccos@eurostop.co.uk> wrote in message news:#dOUcUvxDHA.3416@tk2msftngp13.phx.gbl... > Regex will be supported Yukon via the CLR languages. Can you provide me > with a scenario where you have used regex in SQL. It would be interesting to > see what you can do with it....more >>

I have a question in regards to updates and non-clustered indexes I have a table with 500,000 rows with a clustered 5 column PK and a one column non-clustered index. I added a new Money column to the table and updated it with a 0 and noticed to take a very long time. My question is why would an u...more >>

Is there a way to direct the output of following query to a table/tables? select col1,col2,state,amt from t1 order by state compute sum(amt) by state compute count(col1) Can i achieve the same output by using rollup/cube grouping clauses.? ...more >>

Dear Friends I am having a table where i have three columns 1. Category 2. Invoice Number 3. Amount The category can be ABC , XYZ , PQR The invoice is 100 200 I want to use the Case function so that there will be columns with Invoice number say 100 and 200 which will show the amou...more >>

I have 10 values I want to pass as parameters into a stored procedure and have those param values evaluated against the conditions that are stored in a SQL table and return the NOTE field of those rows where the condition is true. The conditions are just strings that I want to use to compare th...more >>

Hi!! I need to alter a primary key to accommodate one more col. ex: FK PK MANU PK HEAT PK GRADE PK PROJ <- new column How do I create a script to do this and populate the new column so that where the MANU column has a value of '4' insert into the new PROJ column the valu...more >>

i.e. mymachinename\mysql2000...more >>