Database Newsgroups: SQL Server database programming

Trigger question

Rob - 9 Sep 2006 11:40 PM - 1 message

Using Sql Server 2000... We have a stored proc that is executed as a Trigger "on Insert"... If there is any error in the stored proc, then the original Insert fails. Is there any code that may be added to the trigger or stored proc that would ...

xml file into table

UA - 9 Sep 2006 10:40 PM - 7 messages

I have a xml file which contains nested data. for ex. each Order has multiple order details records. The data should go into Order table and Order Details table. How should I parse the xml file data so that it loads into two tables using ...

'System.OutOfMemoryException' ?

nkw - 9 Sep 2006 7:52 PM - 5 messages

(SQL 2005 on my PC, A table with 13 million rows) I just did select count(*) from T13M It ran for a while and I canceled it. Then I tried to see what the estimated execution plan is. And I got the ...

Deferred drop

Dean - 9 Sep 2006 7:49 PM - 4 messages

Hi, I need some clarification. A few days ago, at our UG meeting, we had a discussion about some less-known new features in SQL Server 2005. Among these, deferred drop of large temporary objects - as described in [link] - was mentioned. An MVP, who made the presentation, stated that this deferred drop happens only when the object goes out of scope, and if it's not explicitly dropped. It somehow didn't sound right (being told, in a way, that cleaning up after myself is not only unnecessary, but actually a bad thing performace-wise), so I did some testing, and it seems that the drop is deferred regardless of how the object was dropped - explicitly (with DROP TABLE) or implicitly (when going out of scope). Of course, I might be wrong, and my testing method could be incorrect. ...

Formatting and returning Time from Text

jonefer - 9 Sep 2006 7:47 PM - 4 messages

I'm importing a time field as datatype - char, from a text file to prevent the DTS package from erring - for some reason, if I import it into a DateTime field it gets an error. So bringing it in as char has worked helpe aleveate ...

rows to column sql server 2000

xavier.sharon - 9 Sep 2006 6:20 PM - 5 messages

Hi all, the query gives me the foll o/p as column1 column2 A 1 B 20 ...

Copying data from 2000 to 2005. Indentity insert not working

Charlie@CBFC - 9 Sep 2006 3:54 PM - 4 messages

Hi: I'm at my wits end. When copying data from sql2000 to sql2005, identity columns are reseeded starting with 1. I have checked indentity insert on, but makes no difference. How the heck do copy data from 2000-2005 and ...

Views Vs Stored Procedures!

Child X - 9 Sep 2006 3:13 PM - 3 messages

Hi all, Just a quick question about when to use views in contrast to stored procedures. For example, i have the following table: Subject: - SubjectID - Name - Published - AccountID - CreatedDt Now my app requires to respresentations of the Data; 1) Administrators require: SubjectID, Name, Published, AccountID ...

"Order By" Parameter to a Stored Procedure

Alex Maghen - 9 Sep 2006 2:53 PM - 7 messages

Can I pass a Parameter to Stored Procedure which will be the ORDER BY column to be used in a SELECT? If so, what's the syntax? Alex ...

Migrate data from Access to SQL 2005

mikepallorad - 9 Sep 2006 2:05 PM - 3 messages

hello everybody using the SSMA migration from Access 2003 to SQL 2005 is cool. then Robert Burke saved me a lot of strain [link] but i couldnt quiet understand the link to ...

Migrate data from Access SQL 2005

mikepallorad - 9 Sep 2006 2:02 PM - 3 messages

hello everybody using the SSMA migration from Access 2003 to SQL 2005 is cool. then Robert Burke saved me a lot of strain [link] but i couldnt quiet understand the link to ...

Can an email trigger a DTS Package?

jaylou - 9 Sep 2006 11:27 AM - 5 messages

I get an email to let me know files are ready for processing. Can I set something up to kick off the job? TIA, Joe ...

ALTER TABLE

velmurugan(Internal) - 9 Sep 2006 9:44 AM - 4 messages

HI FRENS, I WANT TO DROP PRIMARY KEY CONSTRAINT FROM A TABLE USING ALTER TABLE,PLEASE GIVE ME THE SYNYAX TO DO SO. VELMURUGAN.D ...

Re: SELECT INTO temp table - Pros and Cons

Erland Sommarskog - 9 Sep 2006 9:22 AM - 2 messages

John Smith (some***@microsoft.com) writes: It is hard to find anything definitive, because the answer for many performance questions are "it depends". I think you make a fairly good summary, although I'm not sure that I understand the third point - you can get recompiles with CREATE TABLE + ...

HOW TO CALL A USD IN A SP

DEVA - 9 Sep 2006 7:15 AM - 6 messages

HI frndz, i have two usd then how to call these usd in a single SP ...

Alter Seed value of Identity column

Prasad - 9 Sep 2006 5:42 AM - 3 messages

Hi, I want to create temporary table, say "a" which has a column say "col1" which i wnt to be an identity for which I need to provide a seed value. I tried the following ...

Order by causing query to return very slow

mchi55 - 9 Sep 2006 3:31 AM - 2 messages

I have a pretty large query. It is selecting a distinct 2000 records. If the query returns 2000 records...it takes 11 seconds to run. There is a single order by clause on one column...a datetime column. The query execution plan shows the SORT as taking 75% of cost. ...

Even after year of coding I ask...

Chris - 9 Sep 2006 2:27 AM - 7 messages

Hi, When really should I use Char(n) Varchar(n) NVarchar(n) I have seen many definitions but I need an expert to confirm. I know NVarchar in non-unicode, however, what is this unicode and non-unicode. Spare my ignorance. Oh... and Joe Celko if you happen to spot this, try not to bang ...

SQL Server 2000 setup issues

spitapps - 9 Sep 2006 12:56 AM - 2 messages

I have webspace running on a machine with IP address 82.165.206.115 through 1and1.com. Then I have an internal server running on my network which is running SQL Server 2000. I have yet to be able to ...

can't connect to sql2k5 server remotely

=== Steve L === - 8 Sep 2006 11:32 PM - 2 messages

HI I set up two remote sql2k5 server, one uses windows 2003 server standard, one uses windows 2003 server R2. i stalled sql2k5 on both server the same way (both has sql2k5 sp1). i can't connect to server 1, but not server 2 (see error below). ...

Challenging query

Gordon - 8 Sep 2006 11:29 PM - 4 messages

I've got a challenge -- I have a one-to-many relationship - files to filecategories -- and but only want one row back per file, not matter how many categories it fits into. Distinct won't do it, because I have text ...

How to implement transactions

Stephen K. Miyasato - 8 Sep 2006 11:01 PM - 12 messages

I'm new to implementing transaction and can you help in this manner. I have the sp below. I use @@Rowcount to see if the name is already present in the database and if so pass a message to the program. ...

Making Sql Server public?

VMI - 8 Sep 2006 9:31 PM - 2 messages

How can I make my SQL Server 2000 public? I'm moving a web application to another domain and I need to connect to it via my SQL Server IP Address. In Query Analyzer in my PC (where the DB is located), I enter ...

how to return only numeric chars from column?

Rich - 8 Sep 2006 9:01 PM - 3 messages

Hello, How can I return only the numeric chars of this data? CREATE TABLE #temp1 (col1 varchar(10)) INSERT INTO #temp1 SELECT 'abc123' union SELECT 'defg1234' Thanks Rich ...

Top 2 max operations

Paul Ilacqua - 8 Sep 2006 8:22 PM - 6 messages

I would like to query this table below to get the 2 largest op numbers and depts per part. IE for 11551 I'd like to return 11551 1730 100 11551 1730 110 etc ...

error debugging in query analyzer

gv - 8 Sep 2006 8:17 PM - 1 message

Hi all, Is there a way in Query analyzer when selecting rows that I see the values of where an error occures? so I can see why it is failing at a certain row. thanks gv ...

Is it possible to return all parent rows but only first child row of each parent for a t-sql join?

Jia - 8 Sep 2006 8:13 PM - 2 messages

Have two tables order and orderline. Is there a way in T-sql to get an inner join to return all order records but only the first orderline record of each order? Sort of like: Select * from order inner join top 1 orderline on <join condition>..... ...

Passing a table into a function

SQL Ken - 8 Sep 2006 7:32 PM - 4 messages

I created a function and passing in a table however, it compains, Can we pass in a table to a function?? anhting wrong with this? can't see the error thanks Ken CREATE FUNCTION dbo.getLatestDate ( @Original TABLE (Indx INT, ID INT, iDate DATETIME) ...

How to tell if an Index has ever been used...

Rob - 8 Sep 2006 7:31 PM - 7 messages

Hi, Is there a way to tell if an index has EVER been used on a table (apart from going back in time and setting up a trace for it)? Thanks. ...

Help with SELECT statement

David - 8 Sep 2006 7:28 PM - 3 messages

Ok, I've got two tables, Clients and History. The relevant fields look like this: Clients ----------- ClientID AccountNo History ----------- AccountNo Year Value Each ClientID can have one or more accounts, so multiple records in the clients table for each clientid. Each account will have a record for ...

can Case test for < or > values?

Rich - 8 Sep 2006 6:49 PM - 4 messages

Hello, SELECT CASE replace(@s,'sec','') WHEN 12345 then 'y' ELSE 'n' end returns 'y' I want to test if the numeric portion of the string is < 15000. If I put 15000 in place of 12345 then the statement returns 'n' - only tests for =. ...

Mdf and Ldf files

ngorbunov via SQLMonster.com - 8 Sep 2006 6:35 PM - 3 messages

Is there some sort of command that can tell me which mdf and ldf files are associated to which databases? Thanks, Ninel ...

Trigger testing

Rob - 8 Sep 2006 6:01 PM - 2 messages

We are currently having the following process finger-pointing issue... Assume you have the following situation... An Orders table A Shipments table An Invoice table A separate program takes Orders information and Inserts rows into the Shipments table (at time of shipping) ...

Can I create an index on a varable table

SQL Ken - 8 Sep 2006 5:52 PM - 2 messages

I have a table defined inside a function. Can I index it? If so How? please give me a simple sample code thanks ke n ...

Trigger Tricks ?

Rob - 8 Sep 2006 4:48 PM - 5 messages

I understand that if the code assiciated with a trigger fails, then the action that called the triger in the first place fails as well. Any way to circumvent this (and not have the underlying action fail) ? ...

Case-Sensitive Text Comparissons

Alex Maghen - 8 Sep 2006 4:09 PM - 2 messages

I like the current configuration of my SQLServer instance which, I guess, does case-INSENSITIVE text comparissons. However, inside a few of my StoredProcedures, I need to specifically do case-SENSITIVE text comparissons. If I want to do something like: ...

UDF function

Mark Goldin - 8 Sep 2006 3:57 PM - 15 messages

Can I create a function that can be a part of a SELECT statement and it would be capable of accepting a parameter that is a column name from one of the tables in the statement? Thanks ...

Update row with cursor joining to another table

wnfisba - 8 Sep 2006 3:53 PM - 2 messages

I have the following cursor process. My syntax joining to another table is failing. Is this possible??? Joining to another table to get a data value for the update within a cursor??? WHILE @@FETCH_STATUS=0 BEGIN ...

Exec cannot see Inserted?

Michel Racicot - 8 Sep 2006 3:40 PM - 5 messages

If I do the following withing a trigger: declare @SQLText NVarChar(4000) set @SQLText = N'select *, cast(''I'' as varchar(1)) as FlagUID into ' + @TmpTableName + ' from Inserted' exec (@SQLText) SQL Server tells me that "Inserted" is not recognized anymore... ...

INSERT LOTS of values

wnfisba - 8 Sep 2006 3:07 PM - 4 messages

I have to INSERT Lots of Values from an Excel spreadsheet to a #temp table and then use the valus in this #temp table to update rows in our database. How can I INSERT LOTS of rows, over 22,000, to this #temp table with the ...

Query Works fine in Access but not in SQL Server

Richie - 8 Sep 2006 3:00 PM - 1 message

Hello Experts, I am trying to create a Stored Procedure in SQL Server 2005 from a query that works fine in Access, but it does not work on SQL Sever and returns a empty table. Any suggestions. Thanks. Richie =========================================================== SELECT tb_Question.QuestionID, ...

Query Works fine in Access but not in SQL Server

Richie - 8 Sep 2006 2:59 PM - 3 messages

Hello Experts, I am trying to create a Stored Procedure in SQL Server 2005 from a query that works fine in Access, but it does not work on SQL Sever and returns a empty table. Any suggestions. Thanks. Richie =========================================================== SELECT tb_Question.QuestionID, ...

Query Analyser Debugger

Michel Racicot - 8 Sep 2006 2:44 PM - 2 messages

When I set breakpoints in the Query Analyser Debugger, they don't work. (The Stored Proc is executed but the debugger doesn't stop on my breakpoints!) How can I make him stop on my breakpoints? ...

pull table Schema

gv - 8 Sep 2006 2:29 PM - 5 messages

Hi all, Is there a quick way to pull table Schema of a table? Like to see the name, datatype, size thanks gv ...

Query Problem

FARRUKH - 8 Sep 2006 1:44 PM - 3 messages

We have a Invoice column which has a varchar datatype. the data is very messed up. there is an int data(14786555), char data (letter) and also empty field in a Invoice column. I am trying to run a query that only bring int ...

Update/Insert and Delete Query Optimisations

Pieter Rautenbach - 8 Sep 2006 1:31 PM - 2 messages

Hallo NG, Consider the SQL queries attatched below. I have two versions each for two different tasks I want to perform. The one task performs either an insert or update, depending on a condition. The other task performs a delete. ...

Check constraint script problem

SQLGuru_not - 8 Sep 2006 1:17 PM - 7 messages

I am running SQL 2000 SP4. I submit the following syntax for the check constraint but when it is in SQL it is changed and all my parantheses are gone except a couple. Weird. Please help. Syntax going in: ...

Get last date in result set

kishor - 8 Sep 2006 10:50 AM - 17 messages

Hi, I need to get the last date of when stock levels hit zero so I can then do a datediff to calcualte days out of stock. Here is a table with sample data productid,stocklevel,date 1,10,1/1/2006 ...

Managed Stored Procedures

rocket salad - 8 Sep 2006 10:45 AM - 8 messages

I would appreciate hearing some different points of views on this subject. Are / how are you using them? Are you avoiding them? Why? Are these so different to the extended stored procedures of 2000? I'm looking into what's new in 2005 before we start migrating our software - ...

Rounding datetime

Sn0tters - 8 Sep 2006 10:13 AM - 7 messages

Are there any problems rounding up dates like this DECLARE @FiveDaysPrevious DATETIME SET @FiveDaysPrevious = '12/12/2006 2:12:12' SET @FiveDaysPrevious = DATEADD( HOUR, 23-datepart( HOUR,@FiveDaysPrevious ), @FiveDaysPrevious ) SET @FiveDaysPrevious = DATEADD( MINUTE, 59-datepart( MINUTE,@FiveDaysPrevious ), @FiveDaysPrevious ) SET @FiveDaysPrevious = DATEADD( SECOND, 59-datepart( ...

Deallocate cursor overhead

devjnr - 8 Sep 2006 8:07 AM - 2 messages

Analyzing an environment I noticed that there are lots of udf and sp that use cursors. The only action that is done is "close cursor" but none deallocate. Do you think would be godd or great idea to add deallocate at the end? ...

query same table twice for different users in one query?

Paul - 8 Sep 2006 7:30 AM - 4 messages

How do I do the following in ONE query: I have a table, it has the structure of msgID, fromUserID, toUserID, msgContent fromUserID and toUserID are numerical IDs, linked to another table (users), which has a first and last names for each userID. ...

How to limit date Range

hon123456 - 8 Sep 2006 7:27 AM - 6 messages

Dear all, I want to limit a select sql statement for specific month. e.g. for Jan it is : select * from table01 where tradedate >= '01/01/2006' and tradedate <= '01/31/2006' ...

Log Shipping & Query Plans

Bryan Aldrich - 8 Sep 2006 4:08 AM - 1 message

I have noticed that on our setup that every time the Log Shipping restore happens, dm_exec_cached_plans and dm_exec_query_stats get completly whiped out. Is this normal? We are running on Sql Server 2005 Enterprise Edition SP1 on Windows Server 2003 R2 EE ...

Access current active workbook from DLL

hon123456 - 8 Sep 2006 2:42 AM - 2 messages

Dear all, I will write a DLL by using Visual Basic. Then I will call the DLL in Excel VBA. Some variables will be passed to the DLL from ...

DECLARE and table strucutres

Man-wai Chang - 8 Sep 2006 2:32 AM - 6 messages

We knew that we could retrieve the structure of a table via INFORMATION_SCHEMA.COLUMNS. Is there a way to convert the structure into a DECLARE variables statement? For example: From this: Table_A ( f1 char(10), f2 integer ) To this: Declare @f1 char(10), @f2 integer ...

Visual Basic 6.0 vs .NET Framework

wrytat - 8 Sep 2006 1:32 AM - 9 messages

I don't know where is appropriate to post this question, but anyway... Our company is going to develop a system (that includes finance, inventory, store, delivery and etc.) using MS SQL Server 2000 as the database. The program also requires the user to be able to access via the Internet using a ...

SQL Guru's - please help paging with a distinct recordset

PepperFleming@gmail.com - 8 Sep 2006 12:19 AM - 6 messages

Hi Guru's, I'm trying to use SQL Server 2005's new Row_Number() function to make my life paging data easier, but have run into a little propblem trying to page a set of distinct values. Here is my query: ...

Attach and detach a standby database in SQL 2K5

jxhyao - 7 Sep 2006 11:41 PM - 2 messages

Hi gurus, If I restore a database DB_A into a standby mode (i.e. restore database DB_A from disk= .. with standby = ...), I can run sp_detatch_db to detach the DB_A, but I cannot attach it back because I got the following error ...

use sp as default column value

gerry - 7 Sep 2006 11:05 PM - 4 messages

i am trying to do what i would think is a very simple thing, define the default value for a column as the return value from a stored procedure within enterprise manager, when I enter the sp in the column Default Value , ...

Are SProc parameters stored in a system (2005) table!

Mark In Atlanta - 7 Sep 2006 10:23 PM - 3 messages

When a stored procedure is created or when it compiles are the parameters saved in a table separate from the SProc text. I'd like to query them. Thanks ...

Import XML using FOREACH Loop container

UA - 7 Sep 2006 9:36 PM - 4 messages

I have a table which contains the file location for each vendor. For ex. tblVendor Vendor Location ABC C:\ABC\Results1.xml SBC D:\Results2.xml ...

xp_smtp_sendmail send out corrupted email message for large attach

BF - 7 Sep 2006 9:09 PM - 6 messages

I use the following way to send out email message from my stored procedure: EXEC master.dbo.xp_smtp_sendmail @FROM = 'a**@bbb.ca' , @TO = 'a**@bbb.ca' ...

inner join in an update

Arne Garvander - 7 Sep 2006 9:01 PM - 4 messages

How do I update columns from one table with columns from another table? update employees set employees.address1=employees1.address1 , employees.city=employees1.city, employees.state=employees1.city, employees.homezip= employees1.homezip inner join employees1 on employees1.emplid = employees.emplid ...

Computing Medians The Joe Celko Way

JLS - 7 Sep 2006 7:48 PM - 5 messages

I have been researching the best way to calculate median values using SQL. Most of the threads I come across include a semi-canned response from Joe Celko which I have some questions about. First, Celko says, I adapted this SQL to my situation but, unless I am mistaken, it ...

TOP 10 for each group

MS User - 7 Sep 2006 7:48 PM - 11 messages

SQL 2K I got a table 'Sales' with columns CompanyID Deptid ChrgAmt Load I want to generate a report with Top 10 Deptid (in terms of ChrgAmt, Load) for each CompanyID. Thanks for your time. Mike ...

UDF that take a UDT as a parameter (CLR)

Andy in S. Jersey - 7 Sep 2006 7:10 PM - 6 messages

I have a feeling that I can't do this, but thought someone might have a way to work around this. I have a UDT type, called interval, that I want to be a parameter to a UDF. Let's say interval 1, i1 is [2:4] and interval 2, i2 is [3:5]. ...

Help with SQLServer2.Connect()

SteveM - 7 Sep 2006 7:04 PM - 1 message

Hi, The short version of what I am needing is this: I need a way to code (In c# and preferably in SQL-DMO) a connection to a named instance of SQL Server 2000 that is running on a machine with other named ...

Table reaching max value of identity very early

Steve Reid - 7 Sep 2006 6:51 PM - 7 messages

Hey guys, Hopefully one of you has seen this before...... We have a new which we have seen reach the max value on four occasions in testing. When I look at the amount of data in the table, it contains about ...

Crosstab, Pivot?

dev648237923 - 7 Sep 2006 6:30 PM - 10 messages

I have a table that has two types of results for each part: part, type, result ---- ---- ------ a 1 1 a 1 4 a 1 5 ...

using variable as servername?

Rick Charnes - 7 Sep 2006 6:28 PM - 2 messages

Inside my stored proc I have a SELECT statement which uses a table on a server whose name I only find out when the proc executes. I'd like to pass this servername as an argument. Is that possible (well, without ...

conditional driven Stored Procedure

Ashton - 7 Sep 2006 6:09 PM - 2 messages

/************************************************/ Example Table /************************************************/ create table UserInfoTest ( FirstName varchar(100), LastName varchar(100) ) /************************************************/ Example Data /************************************************/ insert into userinfotest (firstname, lastname) values ('John', 'Doe') insert into userinfotest (firstname, lastname) values ('John', 'Moe') insert into userinfotest (firstname, lastname) values ('Larry', 'Moe') insert into userinfotest (firstname, lastname) ...

Paging with ROW_NUMBER on filtered records (SQL SERVER 2005)

bert.vanderauwera - 7 Sep 2006 4:05 PM - 6 messages

Hi, I've got the following question. I always used this technique with temporary tables to cope with paging in sql server 2000 but now that we got sql 2005 running in our company i've got to rewrite the paging ...

encrypt a field in a table

harry - 7 Sep 2006 3:37 PM - 2 messages

I need to encrypt a field that contains confidential information, but I also need to decrypt that field later. This must be reasonably strong, not just a rotate or simple addition. Thanks, _harry ...

FOR XML AUTO, ELEMENTS Problem

Amos Soma - 7 Sep 2006 3:33 PM - 3 messages

I have a column ('ProblemResolution') in a table ('Incident') that holds plain text. I am doing a query against that column and converting the results to XML as follows: Select ProblemResolution From Incident Where RowID = 2 FOR XML AUTO, ELEMENTS ...

how do I test the cost of udf?

Justin - 7 Sep 2006 3:23 PM - 6 messages

I am currently doing performance tuning, in particular, query tuning. Before I used a user defined function to get the result set. The new query now uses "set-based" approach to get the result set. I am pretty sure the ...

sql query similar to excel pivot table

manaparai vincent - 7 Sep 2006 3:15 PM - 3 messages

hi, i met one problem in sql server my table name is : student ...

trying unsuccessfully to produce OSQL error

Rick Charnes - 7 Sep 2006 3:01 PM - 4 messages

I have a .CMD file with an OSQL command that does a simple -Q "DELETE FROM MYTABLE". Under some circumstances this table does not exist, and I'd like to know about in the batch file. I'm trying to trap for this ...

Question: How to pass ADS username from C# to trigger

costasz - 7 Sep 2006 2:40 PM - 2 messages

We are thinking of moving to SqlServer 2005 and I have come across the following problem and I am looking for a "best practices" solution to it. Currently we access all of our data through stored procedures. Any auditing we do happens on the client side. We are now looking to add a ...

Delete with inner join

Arne Garvander - 7 Sep 2006 2:34 PM - 3 messages

Is this the proper way of doing a join in a delete or update? Is the a better way? delete useraccount where useraccountid in ( select useraccountid from UserAccount with (nolock ) inner join employee with (nolock) on employee.personId = UserAccount.PersonId ...

current Date query

mark - 7 Sep 2006 2:00 PM - 3 messages

i need to query a date between two values, kindve like this :- mydatecolumn between '07/09/2006 00:00:00' and '07/09/2006 12:00:00' however i need those dates to be variable per day (SP) so :- mydatecolumn between getdate() 00:00:00 and getdate() + 12:00:00 ...

Unable to debug Stored procedure with VS 2003

AtulSureka - 7 Sep 2006 1:47 PM - 1 message

Hi, I am trying to debug Stored Proc with VS 2003 according the steps mentioned in [link] . Break point in SP is not getting hit. After going some articles I have installed SQL Server 2000 SP4. It is still not working. ...

Problem tuning procedures with temporary tables

Johan Sjöström - 7 Sep 2006 1:43 PM - 7 messages

I'm using SQL Server 2000. Is it somehow possible to use the Index Tuning Wizard or Display Estimated Execution Plan with stored procedures using temporary tables? For instance, running the statements below give the following error: "Server: Msg 208, Level 16, State 1, Procedure test, Line 1 ...

INSERT query

Hitesh - 7 Sep 2006 1:29 PM - 3 messages

Hi, I have a very basic query question. I have two tables tblabc and tblxyz. tblabc has three col abcid, abc1, abc2 tblxyz has three col xyzid xyz1 xyz2 I want to insert value in tblabc from tblxyz where xyz1 like '%OPEN' ...

Swap field values in UPDATE

David - 7 Sep 2006 1:13 PM - 3 messages

I would like to be able to update customer and insurance dollar values in one pass using the UPDATE. Below is my code so far for the update but it only updates the Insurance columns. For example, what I want to accomplish ...

SubtractWorkingDays

Sn0tters - 7 Sep 2006 12:21 PM - 5 messages

I've just written this UDF as a compliment to GetWorkingDays, which I see around the net a lot. I'm just looking for general comments and to leave it here for anyone who wants to use it. /*==============================================================================/ ...

SQL Server 2000 Driver for JDBC SP3

Yman - 7 Sep 2006 12:18 PM - 4 messages

Hi I'm trying to register the JDBC driver, I found the articles on how to do it but there are no instruction on which tool to use or the command. If any one has any idea that would greatful. ...

Number of page per table in the cache

××™×œ ×©×¤×™×¨× - 7 Sep 2006 12:16 PM - 4 messages

Hi, In SQL server 2000 . Can I get list of tables and the number of page per table that currently exist in the cache ? Event table list without number of page will be good. ...

Select from a diffrent database in a Stored procedure.

Karsten Lundsgaard - 7 Sep 2006 12:11 PM - 6 messages

Hi I have a Stored Procedure in Database DB_A, where i'm getting data from Database DB_B, both on the same SQL 2000 server S. Like. Select * from DB_B.dbo.Table_A A, DB_B.dbo.Table_B B ...

XP_CMDSHELL error

Chandra - 7 Sep 2006 11:27 AM - 4 messages

Hi I'm trying to execute a stored procedure which contains the below line. exec master..xp_cmdshell 'echo abcd' I granted permissions to the user by using the follwing lines sp_grantdbaccess 'LimitedUser' go grant exec on xp_cmdshell to LimitedUser go ...

From a browser insert or update data to a SQL Server 2005 table?

Mark In Atlanta - 7 Sep 2006 10:23 AM - 2 messages

Sorry I included this code but I needed to demonstrate how clear and simple I am pursuing an answer to my question and how dumb I feel. This is an HTML text box and a submit button. I want to enter data into the ...

My scheduled task failed!

Jeff - 7 Sep 2006 10:14 AM - 3 messages

Hey MS Sql Server 2005 I have a scheduled task which failed. Where can I see the reason why it failed? By the way, in the Job Steps Properties window I listed (in the "command" field) up the stored procedures I want the task to execute: ...

Split zipcode + city

Lasse Edsvik - 7 Sep 2006 8:20 AM - 15 messages

Hello I have a problem, I was given a table full of addresses and I found that zipcode and city were in same column, so I need to run an update that separates those. Problem is that there are 2 spaces so I cant just split at a space. ...

Working Days

Phil - 7 Sep 2006 6:53 AM - 3 messages

Hi, I wonder if someone can help me with a date Query, I have read a few threads how to find out the number of working days between 2 dates but what I want to do is add 15 working days to a specific date, can anyone help I am using SQL ...

Retrieve PDF Image in Sql Server

S - 7 Sep 2006 6:44 AM - 2 messages

We are storing PDF Images in a table in Database. I need to extract the binary data and pass it on to the application code to export (PDF Image) to another format (TIFF) to feed another system. I have gone over this article listed below. Is there another way to extract ...

Error Message

Prasad - 7 Sep 2006 4:57 AM - 5 messages

Hi, Is there any way to get the error message within a stored procedure. I have to store the SQL Server error message in a table. TIA Thanks P ...

SQL 2000 Database Performance

DotNetNow - 7 Sep 2006 3:59 AM - 7 messages

I have been chasing problems with stored procedures taking longer and longer to run, progressively getting worse. I have looked at parameter sniffing as a possible problem, trying remedies that are documented, but with no luck. For example a stored procedure is running pretty well , and then I make a ...

Best table structure for that?

ibiza - 7 Sep 2006 3:14 AM - 8 messages

Hi all, I have a webpage where users can search for some text in a textbox. I'd like to have a feature that displays to them their last 5 or 10 queries they've made. I don't know what structure I should have for the table ...

Slow data transformations from Oracle into SQL Server 2000

gorf - 7 Sep 2006 1:28 AM - 1 message

We have a DTS package that kicks off 5 times a day. It pulls data from 6 different Oracle views (300 records for one, 10000 for another, 70000 for the largest) and stores that data in staging tables. Then the data is modified and used to insert records and update records ...

How does a view work

SQL Ken - 7 Sep 2006 1:23 AM - 9 messages

Can anyone explain to me how does a vew work internally? If a view is a replicate of a table, will it be faster to query from a table then a view? Thanks ...

Feed Newline Character Into SQL Command?

Create Table code by Sql Management Studio has error

CONCAT Function

Help - How to Evaluate for and Strip Duplicates?

Change Query Table

Getting latest status record

Duplicate Database Table Names

Best way to insert data into tables without primary keys

Consolidating Rows into Columns

Changing data

Adding fields to a select into

Multi-User insert issue

Dynamic SQL Limitation

What is new in Sql Server 2005 cursors?

Logging an error during a transaction

Select Query Help Needed

Managin encrypted data

Create dynamic denormalized view

Cloning Datasets

Query Help

XQuery and Hierarchical Data

Syntax Error

error converting datatype varchar to numeric

Update Query in SQL 2005 with inner join

nesting select statements

Constraint such that only one record per group may be flagged

Viewing large fixed-formatted files

Do not rollback sql stmts executed before RAISE ERROR

VB running an executable

IF ELSE Statement

SELECT ... FROM TB_X WHERE FIELD1 IN (@PARAM1) @PARAM1 = 'A','B',

Help with Multiple Joins

insert statement problem

Add not null column without default

money vs decimal

How to do sizing on Memory requirement of SQL Server 2000 ?

How much impact to join table by isnull() or case when

syscolumns

SQL statement - Trim parentheses

When to do index maintenance, the cost of not doing it.

exec question

Time difference between two values SQL SP

Weighted Parameter Options

Joining to a one-to-many

SQL Server 2005 - Recursive CTE

SQL Server 2005: testing if user / schema exists

updating data with stored procedure value

problems sending email from a trigger

Accessing session specific data from a view

Backup Question

REVOKE ALL not working in 2005

MySQL as linked server

why does this not work: parameters on SqlCommand 'grant'

working with gaps in date series

Decimal value issue

How to get table data ?

updating data from different table

Where can deadlock exceptions occur with SQL Server (MSDE)?

cannot open table in sql server management studio express

isting_of_server_rôles_for_a_login

Parameter Array

DBO ID on a table

Join two tables on two databases, but no common field???

Generic function

Send Mail Using SMTP

normalization materials

Why the database data file is lost?

newbie needs help deciphering Sql Profiler Trace

Blocked by sysobjects?

Query Dilemma

Logins

How do I get the "xa_switch_t" exported by Sql Server

Re: Question on In-Line Table Functions

Report help

Question on In-Line Table Functions

Is this dumb?

Locating Data Discrepencies

Why do I get different results with this?

Database partition clearification?

newbie: sending email from stored procedure

Sql 2005 ranking functions: super kewl or just ok?

decimal (11,2) to a fixed-formate

using unknown number of parameters to filter query

Request data replication/warehouse advice

SQL Server and Active Directory

Where to Store Lookup Values

OpenRowset SP call erroring out

stored proc insert,update and cursor

Need help with my stored proc

Combination and count problem

If NOT EXISTS

import from a spreadsheet be

SELECTing out duplicate rows

Where to store text files that contains embedded html

Update Records

1.9 million line transaction in profiler with no begin end using WAITFOR

changing column definition

SP random order

Storing Files in Database

Passing a set SQL statements to a SQL Server Stored Procedure from

List *MY* items that don't appear in the database

output parameter with default value needs to be specified in sp

Converting varchar to numeric problems

try catch....

Identity column as a foreign key - help needed in logic

Passing Array/Table Parameter to Stored Procedure

index size question

Field name parameter query in sql server 2000

Retrieving all order details for a specific product?

exec sproc within sproc fails to commit

Strange blocking problems

How do I get the "xa_switch_t" exported by Sql Server

Query pblm

get all month...

SQL Date Format

SQL Server Express w/ C# 2.0... Cannot find stored procedure...

using dbcc on linked server

xp_cmdshell doesn't work

arranging month from january to december

TSEqual 2005 & compatibility levels

Unicode Comparison.

Query help in Datatime

SQL Profiler "Server processes SQL server trace data" option info

problem about adding columns "alter table" statement in t_sql

Stored procedure help

What is the search query for that?

Use T-SQL to restore DB with the latest backup set

How do I place multiple records of a sub-query in one record?

17207: udopen: OS error 32 occured while create/open physical device

Primary Key

Query working in EM and QA but not in Store proc

Please help me with a SELECT

Triggers: using checksum()

Security (How to protect SQL Server)

Postcode problem

Implicit conversion from datetime to int not allowed

String concatenations

Mitery variable

Query Problem

Query Problem!

DATEPART Gives different answers on different machines?!

Deadlock problem

About Cursor on Dynamically created Tables.

Numbering rows in SELECT query?

SQL Emergency! Need Help

Incorrect syntax near the keyword 'End'.

Union-Record count difference when a column is used in the select

Creating 2nd transaction form inside db ?

Restoring data from SQL2005

Windows Integrated Security

Requesting network information

Date between two wildcards

Record searching question

Unicode Comparison.

SQL server 2005 query problem

SQL 2005 Ordering in 2 directions

newbie: comparing dates in sql

Add a Column at Particullar Position n MS SQL Server

testApp error LNK2005: "unsigned long * Table_CRC16" (?Table_CRC16@@3PAKA) already defined in CRCTes

get data between specific rows

SQL server connection problem

Query question

newbie needs help with trouble shooting

Problem updating large number of records

Trigger When Row Changes

How to list all indexs from a table?

import 1 mln records = problem

Displaying numeric values

Doing JOIN with multiple table on multiple fields in each table

½«SQL 2000 Ç¨ÒÆÖÁ2005¼¯Èº