what is the alternative for oracle's UTL_FILE in SQL server...more >>

Hi I want to have a trigger than when record is inserting into table A, the trigger inserts a record into table B I want the identity value from Table A to be one of the values inserted into table B. How do I get the indentity value from tableA in my trigger so that I can insert int...more >>

custs table contains custid, phonenumber, lastdate custid,phonenumber,lastdate 123, 1112223333, 8/2/2004 555, 4567891233, 4/5/2001 123, 9996665555, 9/9/2005 555, 7878787878, 10/11/2005 newtable contains custid, phonenumber newtable will already contain all distinct custids from cust...more >>

What's the difference between these 2 statements (if there are any): DELETE TableA FROM TableA, TableB WHERE TableA.ID =3D TableB.FKID OR DELETE TableA FROM TableB WHERE TableA.ID =3D TableB.FKID Do they both work the same? Thanks, Yosh...more >>

Hey all, I have a Stored Procedure that does a series of BCP's using the xp_cmdshell. The procedure has 9 bcp calls that have static file names and output locations. Further, there is a cursor that contains 4 bcp's, where the path and filenames are dynamic. When I execute this SP in query ana...more >>

Hey all, I have a Stored Procedure that does a series of BCP's using the xp_cmdshell. The procedure has 9 bcp calls that have static file names and output locations. Further, there is a cursor that contains 4 bcp's, where the path and filenames are dynamic. When I execute this SP in query ana...more >>

I need to obtain the result showing below also the the business rules are indicate below as well. Any help would greatly appreciate. Once again, Thank you. IF OBJECT_ID('Tempdb.dbo.#Fcran', 'u') IS NOT NULL DROP TABLE #Fcran GO CREATE TABLE #Fcran ( FCRAN_Id INT NU...more >>

I have a view in sql server with some triger which allows me to do insert, delete, update on this view, so that I can treat the view as a table in the sql server. Now I am trying to use ADO.net to modify the view. I use some structure provided by the ADO.net like: sqldataadapter da=new ...more >>

Hello. I am extending an existing proc and encountering a strange issue. I hope someone can shed some light on this. Here's my problem : insert into : table with decimal(14,2) columns ( where you see math ) sql statement : TRUNCATE TABLE dbo.tbl_met_wos INSERT INTO dbo.tbl_met_wos SELEC...more >>

Hello... I'm experiencing something that has me stumped. The following query returns identical recs when ran from qa on 3 servers. when I run it on the 4th server, server005.fg2.dbo.addrNotes returns a rec set from the local server instead of Server005 (database fg2 exists as a development...more >>

I have an HR feed that I'm using to provision AD. We have situations were the same person (same username) appears in the feed twice. One time they'll be listed as active, another time listed as inactive. How can I write my view so that when there are duplicate usernames, it only returns...more >>

I have a .bak file (about 150MB) that I received from another person and want to put the data into my Sql Server Database (Sql 2000). What would the best way to copy it in? I have already created a Database called SD1. Thanks, Tom ...more >>

I have a situation where I need to change a database's name both the logical name, AND the physical filenames. I have found several methods that change the Logical name only but keep the old filenames which will not work in my situation because there is a high probability a new database m...more >>

Hi all, My calendar says that 6th July 2005 lies in the 27th week. I do SELECT datepart(week, '06.07.2005') and I get 28 as a result. Do I have to use a different function or configure SQL server in another way. I'm using the German version. Thanks, Ivan ...more >>

DELETE TableA FROM TableA, TableB WHERE TableA.ID =3D TableB.FKID Is this the correct syntax? Thanks, Yosh...more >>

On the face of it, the words "bin packing" seem to very accurately describe this, but I'm not sure anymore. The situation is packing ordered products into shipping cartons. However, we don't have complete freedom to choose what items go into what cartons; for several reasons they have to be pa...more >>

Hi All, Ingres has some functions for converting UUIDs. Specifically, they are uuid_to_char() and uuid_from_char(). I'm new to MS SQL and would like to write some built-in functions (or any other solution) that will allow me to use the same code in MS SQL and Ingres. Example: select uu...more >>

Ok, I have two tables, its a one to many relationship The primary table, return only one record based on the select. However I want to return the max of one field from the secondary table, which returns multiple records Table A : Contact_id, Name, Address, Phone where contact_id = ...more >>

Hi all, How does one drop a constraint using an sql statement? Thanke, Ivan ...more >>

Hi All, I need function looks like HAS_DBACCESS for any user name. How can I check has user access to db? As a user or as a member of group. Thanks. ...more >>

Hello, Is it possible to use a user-defined data type in a table variable? Given that type1 and type2 are user-defined data types the following query: declare @cik_records table ( [col1] type1, [col2] type2 ) produces the error Column or parameter #1: Cannot find data type type1. ...more >>

Hi, I could not figure out this, I have 10 different SM.ItemGroup, SELECT Sh.ShiptoName AS [Cust Name], Req.RefNo AS [Reference No], Req.Reqno AS [Req No], ((Case When SM.ItemGroup='UCC' Then Req.Debtor Else Req.Corpname End)+ (Case When SM.ItemGroup='SVR' Then Req.Respecting Else Req.Corp...more >>

Hello I have a problem using user functions and group by Preparing Ambient To Run SQL Step 01 - Create Table CREATE TABLE [Tteste] ( [Coluna] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL , [Num] [numeric](18, 0) NOT NULL ) ON [PRIMARY] GO -------...more >>

We have a server, for various reasons has link to a loop back linked server. We have dozens of stored procedures that refer to the linked server in their code. They have worked fine for several years until a developer added an on update/insert trigger to a table. Now, when these stored proc...more >>

I'm fairly new to SQL programming, so I have a question concerning triggers. I want to cause a "status" form to open when the "today's date" is 4 weeks older than the "start date" of a project. I have fields in my "projects" table that contains the "start date", and when the project form op...more >>

What is the accepted way of Casing Table,Fields and Stored Procedures? This is a real problem when mixing and matching. For example, C uses lower case for everything, but when calling .Net functions - you have to use Pascal Casing (1st Character of all words Capitalized). In VB.Net, you u...more >>

I have a huge table from which I need to cull orphaned records. The records in this table could be referenced by any one of 8 other tables. Is there any practical, general purpose way to determine if a record in a table has inbound references? Is there general purpose query which will retu...more >>

Hi, any help on this would be great... I am trying to use a stored proc to update a column to be a concatenation of 2 other columns. This proc will only update the records that are in a certain date range and will be called after those date ranges are entered as parameters. The code below is w...more >>

Please help I'm trying to create a trigger that grabs the row being inserted updated or deleted in a given table and inserts it to another almost identicle table. For some reason I'm having a terrible tome making it work. Could someone please give me a simple example to build off of. H...more >>

Dear all, In order to forget once for all the web interface for these newsgroups and reading and writing from my mail client. Does anyone knows how could I add them to my Outlook 2003? Thanks in advance and regards,...more >>

Hello, how can i retrieve duplicate records? I have this table with about 6500 records, and i know that there are a few where a combination (Column1 - Column2) is identical how can i retrieve these? ...more >>

Hi, I want to implement a stored procedure which inserts a record in a table and returns the id... example: table Books id int identity title varchar(50) stored procedure 1 input argument title 1 output argument id Does someone have such an example of a stored procedu...more >>

Dear fellows, I'd like to implement any kind of task or mechanism which to capture all those queries greater than x minutes. An alarm system which inform me of info such as spid, loginname, and so on and in order to avoid that, from time to time do sp_who_3 for obtain critical information ...more >>

Hi, Any help of getting a tool to design best performance SQL queries on SQL Server 2000. The tool is also needed to visually see the query design (Joins, recommended indexing, ...etc) to fine tune. Thanks -- Ateyya...more >>

If I create a new sp in EM I have the date of creation; however, if I modify it, it retains the original date. Is there any way of finding out the most recent modification date of an sp inside sql server 2000? Thanks for any help. Bernie Yaeger ...more >>

Hi. I'm having a problem using aliases in queries. I want to use something like select id as [User Name] from table where [User Name] like '%john%' I get an error because the column User Name doesn't exist. How can I solve that? -- Regards, Diego F. ...more >>

Hi, Please give me a suggestion to write a sql query; (Connecting one parent table with two child tables in one to many relation) Sample Table structures are as follows:- TBL_PARENT (PARENT_ID, PARENT_NAME) TBL_CHILD1 (CHILD1_ID, CHILD1_NAME, PARENT_ID) TBL_CHILD2 (CHILD2_ID, CHILD...more >>

CREATE TABLE U(col1 INT); INSERT INTO U VALUES(2); INSERT INTO U VALUES(7); INSERT INTO U VALUES(9); CREATE TABLE V(col1 INT); INSERT INTO V VALUES(3); INSERT INTO V VALUES(7); INSERT INTO V VALUES(NULL); SELECT * FROM U WHERE col1 NOT IN(SELECT col1 FROM V); i expected it to ret...more >>

Is it possible that the index data SQL Server can be damage? What are its characteristics if the index broken? And how to repair it? Then How to prevent it? ...more >>