Is there any way to implement ROWNUM in Oracle to select row no. Is there any way to select the row no when retrieving records as 1 Tv 2 Fridge 3 Radio...more >>

Hi all, My company haa a big detabase and i am working on a marketing and sale report. i had lot of junk data like: D-CAB PZTN4-3553-01 TOYOTA,Plate Hook A,7.0mm,(SET) TOYOTA LINER D-CAB (PZO53-0K003), Plate, Robot Hook A, 7.0 MM. i want to take out only ( D-CAB) but i coudnt make it from the...more >>

What permissions must I grant to allow a user to rename a table? I have my stored procedure rename a table when it is done, but it fails and says the user does not have permission. Thanks ...more >>

Is it possible to do something like this? select * into #tmptable from sp_executesql... ...more >>

Hello, I'm using SQL2000 and I have a table which has a field within it called "ImageFileName", what I would like to do is create a trigger to automatcially delete the disk resident image file that is contained within the "ImageFileName" field of the table upon the deletion of any of these...more >>

Hi All, I want to design a DTS Package that will read an EXCEL Document (One Data Source) and ONE SQL Server (2nd Data Source) and Execute one Query which will have a JOIN from Both the source and Export the result to another Excel Document. How Can I perform that using DTS? I have took ...more >>

I have a stored procedure that calls several other stored procedures. Is there anyway that a stored procedure can access a temp table created by another stored procedure? ...more >>

Is it possible to handle an FK violation error in SQL Server 2000? IOW, if I encounter this error, is it possible for the code in my proc to execute alternative code rather than immediately exiting with an error message? I can write code to always test for a FK violation before I try to inse...more >>

if exists (select * from sysobjects where id = object_id('#Tab1')) begin print 'Dropping old version of table: #Tab1' print '' drop table #Tab1 end CREATE TABLE #Tab1 ( StateCd CHAR(2) , AvgMonths INT ) Is any problem with the above code .. ...more >>

Hello, I don't know if this can be done, I'm not an SQL Server expert; But can you start a program ( VB app ) with a stored procedure. For instance if a record is written to a sql table then a trigger could be set to start a vb app from sql???? I'm trying to come up with a way to recogn...more >>

I would like to test if the day is Sunday (listed below), if 'YES' then delete the files in the directory with following critieria (E:\NewOrleans\*FULL.BAK) and create a new full backup file. If 'NO' (Sunday) create check to see if a E:\NewOrleans\*FULL.BAK file exist if 'NO' (E:\NewOrlea...more >>

Is it possible to pass a table to a stored procedure as an argument? ...more >>

I need some help with the @LanguageId part of this query to exclude/include rows to be returned. ctbl_content_rel can contain rows with different language ids, e.g 'dk' and 'nn'. If rows with the specified @LanguageId exists, then I want only those rows, otherwise I want only the 'nn' rows...more >>

SELECT {fn NOW()} SELECT GETDATE() Both return the current datetime but I cannot find a reference anywhere to fn Now(). Can anyone explain what fn NOW() is? Ron...more >>

I've configured my SQL Mail profile in SQL Server. In SQL Server Agent Properties it shows me my profile. I choose my profile (the same one that tested successfully in SQL Mail) and press 'Test' and I get the following error message... "Error 22022: SQLServerAgent Error: Unable to get th...more >>

I have a query that shows me which records will be duplicate; (Database schema is changing in next version, and the last column is no = longer part of the key structure, therefore, duplicate.) Query: select a.gl_cmp_key, a.sl_ledger_key, a.sl_acct_keyvalue1, = a.sl_dist_key, a.sl_dist_seqno ...more >>

Hi All: I am curious to know how SQL Server Procedure, View and other DB Object encryption work at the architecture level. Does SQL Server call any DLL or EXE off the bin directory for text encryption or what? Reason why I am sking this is we all know that SQL Server encryption can be easily ...more >>

I am looking for a way to list any default values for stored procedure parameters. For example with this stored procedure: CREATE PROC dbo.pr_GetSomeData ( @SomeInt int, @AnotherInt int = 0, @SomeDate datetime = NULL ) I'd like to be able to create a table that would look like this ...more >>

I just absolutely had to share this. The below email just arrived at our helpdesk from one of the suits upstairs: <suit> Just a quick one. When I hooked up my PC I plugged in grey cable that was about 20 feet long. It works but I'm wondering if I really need a proper Ethernet cable (usual...more >>

In a sales software system that I built, a sales person belongs to a department within the company. However, during their employment with the company, they might work in several departments. So I implemented department logging in the system. CREATE TABLE [USER_DepartmentLog] ( [UserId] [i...more >>

I have a asp.net form which is for orders with a field for numbers in it. What I want is when a user raises a new order the Order number field will be populated automatically with the next order number. I want this order number to be incremented on the database table. The order number is of the...more >>

Hi all, I am trying to do the simplest of concatenating... select lastname + ', ' + firstname from usertbl (example right out of BOL) however, I alwyas get: "Syntax error converting the varchar value 'Adkins' to a column of data type smallint." Something not set right on the serv...more >>

derek@programmer.net May 19, 12:57 pm show options From: "d...@programmer.net" <d...@programmer.net> - Find messages by this author Date: Thu, 19 May 2005 09:57:29 -0700 Local: Thurs,May 19 2005 12:57 pm Subject: Long Running Queries in Procedure Reply | Reply to Author | Forw...more >>

Hi, i'm getting this error after switching a field, outcontent from VARCHAR to NTEXT. select * from loglog where (ltrim(rtrim(outcontent))<>'') go Argument data type ntext is invalid for argument 1 of rtrim function. Can someone help advise how i should removed spaces from a field return...more >>

Hi, Functionality wise is there any difference between unique constarint and primary key? thanks ...more >>

Hello, Buddies Anybody Know if is possible to create tables or views in a store procedure? and if it is, Has it exceptions? where I can find references? Thanks in advence...more >>

Hi I need to upload and XML file into SQL. I cannot use openxml beucause it's a relational xml file. I cannot get enough info on sqlxml to use that so I'm uploading it via xp_cmdshell via dos command "type" . This text I insert into a table and apply whatever manipulations on it. The pro...more >>

Hi, I see that DTS is not available in the Workgroup edition of SQL server. Does anyone know if it's available in the Personal edition? If DTS is not available in an edition of SQL server, can I still use DTSPUMP functions in VB on the SQL server? Thanks in advance, -- Christy Warne...more >>

(I posted this in another newsgroup and it was recommended to me that I post in here) OK, that's an odd subject line. Let me try to explain what we have in our table: item language collectionID GUID the form1 english 1 5 el form1 spanish 1 ...more >>

Hi All, I am trying to get the sp_xml_concat (http://www.awprofessional.com/articles/article.asp?p=102307&seqNum=16) to work will no luck. Here is the errors I am getting: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '('. Server: Msg 137, Level 15, State 1, Lin...more >>

My team is developing a new software system that is replacing several existing applications. The applications being replaced focus on billing and customer relationship management. Our company is an international corporation that serves a large number of customers (hundreds of thousands) sp...more >>

I've got a SQL job I've set up that I'm issuing a call to 'sp_helpserver' in to determine if a given remote server is linked with the local server. If the remote server is not linked at the time of the call, I get an error... 'The server 'dbserver' does not exist. Use sp_helpserver to show a...more >>

I've created a table containing columns date, cost, orders etc. I want to write a query group by the month part of the date. Is it possible to write it. if yes how. Any suggestion would be greatly appreciated. regards shine...more >>

I've created a table containing columns date, cost, orders etc. I want to write a query group by the month part of the date. Is it possible to write it. if yes how. Any suggestion would be greatly appreciated. regards shine...more >>

I am trying to create a procedure within SQL Server 2000 that will update a table for viewing over our intranet(nightly process). The final output will show current balances within accounts. The way the logic works for calculating the accounts is that the accounts are allocated by years. ...more >>

I have an interesting problem where I need to calculate paths between connecting nodes. For example:- Node 1 is connected to Node 2 Node 1 is connected to Node 4 Node 2 is connected to Node 3 Node 3 is connected to Node 4 Want I need to return if I search connections between these two ...more >>

I'm modelling an approval process as a graph. Each node represents a stage in the approval process and each edge represents a transition from one stage to another. To move from one stage to another requires someone to take an action. To define who can do what at each stage, each transition is ...more >>

Hey all, I need to do a bit of cleanup on some existing data that includes special characters (e.g. '@', '#', '<', '%' etc). If the column holds anything other than a-z and 0-9 then I need to change it. The column in question is varchar (100). UPDATE tbl1 SET col1 = NULL WHERE col1 (???) ...more >>

In Access our users are able to define descriptions for the tables and views(queries). We migrated a few Access applications to SQL Server and our users are asking for the same functionality against the SQL Server tables and views they could define descriptions. I see we can define description...more >>

hello, I have my database server environment on the same pc where i have my development environment because i am still in the testing mode, but when i want to switch to the production mode, i want to install my db server on a separate computer so that clients can use the application. The ques...more >>

Shansinn wrote: > *Iam having SQL Database MDF file how can i restore the database > without LDF.Please anyone reply me and this is very very urgent * -- Shansinn ------------------------------------------------------------------------ Posted via http://www.codecomments.com ----------...more >>

Iam having SQL Database MDF file how can i restore the database without LDF.Please anyone reply me and this is very very urgent -- Shansinn ------------------------------------------------------------------------ Posted via http://www.codecomments.com ----------------------------------...more >>

Hi everybody, i need to write a store procedure thar recive as input a string composed in this way: TEXT1.TEXT2.TEXT3.......TEXTn Store procedure has to extract TEXT1 TEXT2 and so on, then use those single strings to various purpouse. can someone show me the manner to tokenize string ind...more >>

I have a non standard requirement that about 5 different users from different departments require sequential numbering for there records, however I want all records to be in the one central table. This comes about as each departments records ID's have a 4 letter acronym before the AutoNumber ...more >>

Hi, In northwind DB I calculate the total value of orders for each customer by this query: select o.customerid,sum(od.unitprice*od.quantity) as s from [order details] od join orders o on o.orderid=od.orderid group by o.customerid Now I want to know which customer has been the best in ...more >>

Hello Gang . I have a dynamic stored procedure which needs to be able to process a part of it's search a form field which may contain several word seperated by a space. ie: earth diamonds brazil ocea My dynamic stored procedure works great, right now the paramete containing the form input is a...more >>

Hi, Quick question I have problem getting the pointer position on a word in a text typedatefield. I am getting the error "NULL textptr (text, ntext, or image pointer) passed to UpdateText function.' ..... SELECT @Bptr = textptr(strData), @Bpos = charindex('replaceText' , strData)-1 FR...more >>