Database Newsgroups: SQL Server database programming

sp_provider_types_rowset and some other stored procedures keep being executed

dragooon - 5 Aug 2006 10:58 PM - 10 messages

sp_provider_types_rowset and some other stored procedures keep being executed We recently experienced a very interesting problem. When connecting to SQL Server 2000 (SP4) using ADO, after the recordset is retrieved, we can see the following stored procedures kept being executed every we submit an ...

RE: use execute command or sp_executesql or direct sql ?

jou boetie, brandon - 5 Aug 2006 8:40 PM - 1 message

hallo , sussietjiel ek weet nie hoe om in jou goed in te kom nie, maar toe kry ek hierdie op die pc. ek probeer jou bel en laat boodskappe, maar jy bel nie terug nie. hoekom nie. jy hoef nie lank te praat nie. ek wil net weet hoe dit met jou gaan. ek tik hierdie brief vir jou van maputu!!!! kan jy glo. ek en wiehahn bly in n baie lekker woomstel by een van die susters van die bruid vir wie ons n nice troue gedoen het. bel so n bietjie op my sel, toe. ek het laas week probeer, maar die simpel telkom fone werk nie altyd nie. ek mis jou. groete aan jou familie. renata in engeland agter n man!!!!! brandon From [link] Posted via DevelopmentNow.com Groups [link] ...

data transfer compression

tbs - 5 Aug 2006 6:27 PM - 1 message

Hi, I saw that this question was asked back in 2002 and I am wondering if the answer has changed in 4 years. Is there a way to get SQL Server Express (or standard SQL Server, for that matter) to compress the data ...

Number of users per SQL server

Mervin Pearce [SACS] - 5 Aug 2006 1:11 PM - 1 message

Is it possible to determine the number of users that have connected to my SQL server using an API or WMI call? Windows has a number of licensed users in the OS structure I can pull out programmatically. Just wondering wrt MS SQL ...

Querying a local named instance - how?

dj - 5 Aug 2006 12:00 PM - 4 messages

I'm stumped by what seems like a simple problem: How do I query a SS2k named instance on the same machine? Here's my scenario - Machine name Alpha has SS2k installed as the default instance, plus it has SS2k ...

Beginner to SQL database

jyetying - 5 Aug 2006 6:47 AM - 3 messages

Hi all, I wanna to learn SQL database. Is there any SQL tutorial that can be find from internet? Can u show me the link? Thks all. ...

After Restoring Database getting this message "Cannot Modify record"

dpk.sinha@gmail.com - 5 Aug 2006 5:38 AM - 4 messages

Good Morning Friends I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I have got one application developed by some software agency using VB 6.0 and sql server 7.0. Since last 6 years everything worked fine. ...

Transform 2 Rows into 1

JP - 5 Aug 2006 4:33 AM - 6 messages

I have an Excel spreadsheet in which I imported into a Temp table. The temp table script is: CREATE TABLE [dbo].[Temp]( [year] [float] NULL, [week] [float] NULL, [teams] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, ...

delete duplicate items?

Qnguyen - 4 Aug 2006 10:48 PM - 7 messages

Does anyone know how to view and delete identical items on table? What is SQL command to do this. Thanks ...

Self-join based on datetime

stavros - 4 Aug 2006 10:24 PM - 5 messages

I'm trying to write a self-joining query that simply returns records from a table alongside the previous record (based on a timestamp) for each employee. I created a small mock-up table and wrote a query that ...

migrate from SQL Server 2005 Express to SQL Server 2005 Standard

contact1981 - 4 Aug 2006 10:12 PM - 2 messages

I was wondering if it was easy to migrate from SQL Server 2005 Express to SQL Server 2005 Standard? If so, do you know how I can go about doing the migration of data? Thank you. Sincerely, Eldhose Cyriac ...

SQL 7 and SMO

Lee - 4 Aug 2006 10:11 PM - 3 messages

I tried to connect to a version 7 database with SMO to do a backup and got an error indicating that it could not perform the operation becuase of the version. I checked the documentation and version 7 should be supported. Is ...

To send message to several directions of mail

L.Barzi - 4 Aug 2006 8:35 PM - 4 messages

I use xpsmpt.dll works to me very well but my question is the following one: I use the following code to ejeutar Extended Stored Procedures of sgte way as it indicates the page [link] ...

how to test operators in sql 2005 database mail?!

=== Steve L === - 4 Aug 2006 7:48 PM - 1 message

I posted this a while ago but didn't get any response. Hard to believe no one is experiencing the same problem but me. Any advice would be appreciated. Thank you! ===================== in sql 2000, i can create and test an operator. ...

unused variables

Bill - 4 Aug 2006 7:09 PM - 3 messages

I'd like to eliminate any unused variables that are used in my stored procedures. However, since I have hundreds of stored procedures this would be quite time-consuming doing this manually. Does someone know of a utility/tool that does this? ...

outer join -- losing records from parent table question

CRT## - 4 Aug 2006 7:01 PM - 6 messages

I want all values from MasterTable, and the associated SubNames from the view. If a subname is not assigned, return 'Not Assigned'. This seems to work: SELECT m.Value, ISNULL(v.SubName, 'Not Assigned') ...

copy two tables with new id?

jkarpago - 4 Aug 2006 6:45 PM - 6 messages

Hi: I have two tables and I want to copy some rows of origin table to destination table but these rows have to change its id to a new one. the problem is that the program that uses the tables insert the id, so ...

Insert Data

Bob - 4 Aug 2006 6:40 PM - 3 messages

I need to insert data from one table into multiple tables. I understand how to insert the data by coding to insert statements. However is it possible to do one insert statement into two tables (I do want to select the data ...

Returning selected rows

gv - 4 Aug 2006 6:20 PM - 14 messages

Hi all, I have some test data in a table like this. Name Address State Phone1 Phone2 Phone3 ...

TSQL Question

Mike - 4 Aug 2006 5:42 PM - 2 messages

Hi, I have char field that holds a value like '001' and I need to increment this char (like '002'). How can I do this? Thanks ...

"cleaning" some data on a table

Blasting Cap - 4 Aug 2006 5:38 PM - 3 messages

I have to do some work on a database that from a programming issue several years ago, there are names in a table (business names) that have a problem with apostrophes. What happened is that in some instances, there are 2,3 4 and 5 quotes in ...

Copy All Table/Index DDL + Data

Jordan S. - 4 Aug 2006 5:37 PM - 1 message

Is there a quick and easy way, using Management Studio, to copy a table from one database to another? While I found the SQL Server Import and Export Wizard, I found that when executed, it moves the data and creates a minimal ...

group by

skg - 4 Aug 2006 5:12 PM - 3 messages

i have a table with 5 million rows. It has a binary column. I am curious to know if i do a group by on that column, will it be faster if i have it as varbinary rather than binary ...

Create view of winning lottery numbers

sean-usenet - 4 Aug 2006 4:48 PM - 8 messages

Hello everyone, I hope someone can help me out with this. I have a table the contains past winning number for multiple lottery games. Following is the format of the table: DrawDate,GameName,SetNum,WhichNum,WinNum 2006-07-31,2by2,0,0,26 ...

Checking unique constraint from application

gary7 - 4 Aug 2006 4:41 PM - 4 messages

Hi Folks, I have a unique column contraint (Indexed, non-clustered, Not-Null, Not PK, the column value is nvarchar type(50)) on a dataset. I am trying to figure out how to check for the unique value before submitting update ...

Checking unique constraint from application

gary7 - 4 Aug 2006 4:40 PM - 3 messages

Hi Folks, I have a unique column contraint (Indexed, non-clustered, Not-Null, Not PK, the column value is nvarchar type(50)) on a dataset. I am trying to figure out how to check for the unique value before submitting update ...

Insert with Cursor values

Jo - 4 Aug 2006 2:17 PM - 5 messages

Hi there: I want to insert using a cursor. I have a table Services: ServiceId ServiceName SupplierId TextType1 TextType2 Flag 44 SomeName 787878 null ...

DTS Package runs, Scheduled Job Fails

moongirl - 4 Aug 2006 2:13 PM - 2 messages

I have been searching for the solution to this all day and have found many people who have had the same problem but I still can't get this resolved on my system, so I am really hoping someone can help! I ...

sp_executesql problems

paulwragg2323 - 4 Aug 2006 2:04 PM - 4 messages

Hi Apologies for the case of my posting below but I upper cased everything and I don't have time to change it all. I am having problems using sp_executesql in that the output parameter does not seem to get the ...

sp_databases called from code

Naria - 4 Aug 2006 1:26 PM - 3 messages

Hi, I basically copied and editted sp_databases to only show me dbs over a certain size and tested it in Query Analyzer and it works fine. I wrote an asp page (and tried it through VBScript as well) that calls the stored ...

sp_OACreate Execute permission denied

Martin - 4 Aug 2006 12:53 PM - 4 messages

Hi, we are using sp_OACraete in a stored procedure to create an OLE-object instance of an ActiveX-DLL. After migrating to SQLServer2005 we receive an "Execute permission denied on object 'sp_OACreate' database 'mssqlsystemresource' schema 'sys'" In Books online I get the Info "Requires membership in the sysadmin fixed ...

SQL Agent question

Blasting Cap - 4 Aug 2006 12:43 PM - 3 messages

I have a batch job that does some work to a table and once it's finished, I want it to run a completely separate batch job, and then return to the currently executing one. The "starting" job has about 20 steps in it, and the new job has 3 steps ...

BCP output perfect one minute, corrupt the next!

Matt Smith - 4 Aug 2006 12:31 PM - 3 messages

Hello, I have little experience with SQL Server, but I've written a stored procedure that extracts basic demographic information to be imported into another system. I'm using a batch file as a scheduled task that extracts the data via bcp. The ...

Performance issues using Parameters

Reg Besseling - 4 Aug 2006 11:30 AM - 7 messages

Hi all, (DDL's etc below) I hope someone can help with this as I have tried everything I can think of and had no luck I have a table with 11M rows and have created a simple report/query on it. ...

Problem Summing When joining a Sum from another Table

Sh0t2bts - 4 Aug 2006 10:57 AM - 5 messages

Hi, I am having a problem Joining Statement into my main query when summing the results, what happens is in the original query I get a result of 2 when included in the main query in increases to 12, Eh!! ...

SQLServer gets busy, users timed out, what does this Error Log mean ?

krislioe - 4 Aug 2006 10:08 AM - 6 messages

Hi Sql Gurus, (this is related to the post : [link]) Our custom application run on SQL Server 2000. On random period of time ...

Dynamic WHERE clause

ricky - 4 Aug 2006 9:30 AM - 8 messages

Hi Is it possible to create something like this: SELECT ... FROM .... WHERE TransMonth (CASE WHEN @DateType = 'UserEntered' THEN = @UserEnteredMonth ...

Dynamic SQL Problem..

arijitchatterjee123 - 4 Aug 2006 8:25 AM - 11 messages

Hi Group, Let me explain my problem ============================ declare @tableName varchar(200) set @tableName = '##TempTab' /* Some external dll creating this table definition. I am just passing the tablename to the dll. But if the dll not getting the suitable data from the ...

text variables?

Man-wai Chang - 4 Aug 2006 8:10 AM - 3 messages

I can't do "declare @var text". How could I get around it? I need to open a cursor to fetch a text from the table into memory.... ...

TIP:How to Eliminate duplicate rows??

jsfromynr - 4 Aug 2006 6:35 AM - 8 messages

Hello Newsgroup readers, Most of the time I had seen people looking for some solution to remove duplicate rows where table is not having any key ( by defination it is not a table). Let's say I am having a table EMP (with two columns for illustration) ...

-- Freelance Developers Community, who wants to help? --

Freelancer_To-Go - 4 Aug 2006 4:45 AM - 5 messages

Hello All, I am in the process of putting together a website that allows freelance developers of all (programming) languages to create a base for sharing files, articles, links, methodologies and interacting with other freelance developers through forums and chats. ...

Tricky Stored Procedure Question

ricardo.dapaz - 4 Aug 2006 3:40 AM - 4 messages

Hi there, I would like to create a simple search form to allow users to search for a job number based on a number of parameters. I think I understand how to use parameteres associated with Stored Procedures with a data reader to add various parameters. ...

Left (or Right) Anti Semi JOIN

Arnie Rowland - 4 Aug 2006 2:44 AM - 5 messages

How do I get one? From: [link] ...

How to join a table in another SQL server

Anderson - 4 Aug 2006 1:38 AM - 2 messages

Hi, all Does anyone know how to join a table in another SQL server, thanks in advance! -ja ...

Timeout - max pool size reached

tshad - 4 Aug 2006 12:46 AM - 10 messages

I got the following message on my Sql Server 2000: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. ...

decimal column to PIC9(09)V99

wnfisba - 3 Aug 2006 10:53 PM - 3 messages

We have to extract an amount column defined as decimal9(11,2) to a COBOL defined PIC 9(09)V99...The "V" indicating an assumed decimal place. So, 100.00 needs to be extracted as 10000. Can someone help me with this??? ...

deleting comments

Rick - 3 Aug 2006 10:47 PM - 3 messages

How can I eliminates comments about the numers of rows affected from a stored procedure? (see below) (3719 rows afffected) (5 rows afffected) (100 rows afffected) CustomerId Customer ---------------------------- 1 John ...

simple insert query

sintral - 3 Aug 2006 10:25 PM - 2 messages

insert into locationcatalog (cat_id, cat_id, cat_id, cat_id) values (117, 118, 51, 45) where catalog.cat_id = 44 in (select locationcatalog.cat_id from catalog.cat_id inner join locationcatalog on catalog.cat_id = locationcatalog.cat_id) This is what I have. What I'm trying to do is insert the values 117, ...

need urgent help to restrict TargetServerRole...

=== Steve L === - 3 Aug 2006 10:15 PM - 1 message

need some expert advices here. background sql2k with sp4 i granted some developers TargetServerRole for msdb to wirte and maintain dts for their applications but only found out that with that role, one can pause and even stop sql server! also, they can write dts ...

SMO Login and User Creation Fails SQL2005

JP - 3 Aug 2006 10:04 PM - 5 messages

Hi, I need to create a Login and then a user for a couple of databases programmatically. I can create the Login but not the user. IT complains about a parent and when I try to set the parent I got another error. Below is my ...

Import Filemaker Pro data into SQL Server

brian - 3 Aug 2006 9:53 PM - 2 messages

I could not find an import/export SQL Server newsgroup so I am posting here. I need to import data from Filemaker Pro into SQL Server. Any information would be appreciated such as links, etc. thanks Brian ...

CLR and Insert

Curtis - 3 Aug 2006 9:33 PM - 23 messages

Is it possible to insert records into the database from a CLR function? I need to insert thousands of records based on For Each loops. I have my function done except for the inserting part. I was hoping to complete the ...

Performance problem with SQL Server 2005

Kostas - 3 Aug 2006 9:26 PM - 12 messages

Hi all I am trying to optimise a number of slow running stored procedures and I'm having a strange problem. As soon as I create or alter a stored procedure it runs really slowly. Then at some point it suddenly speeds up. The problem is ...

sql server 2000 sample scripts

Jon Paal - 3 Aug 2006 9:10 PM - 3 messages

I installed Northwind and pubs Sample Databases for SQL Server 2000 but it didn't say where they were installed. How can I attach them to the database without knowing their location ? ...

deriving DB properties

Andrew - 3 Aug 2006 8:46 PM - 3 messages

Using SQL SVR 2005 Express, when I right-click on a DB, a Properties dialog appears, with a default selection of 'General'. The second section of the grid that appears is labeled 'Database', and shows properties including 'Size' and 'Space Available', ...

Recover .DBD files from LTO tapes

roberto.moreno - 3 Aug 2006 8:41 PM - 2 messages

PLEASE HELP!!! I have an LTO tape backup that contains Database files, im not sure what software was used to backup these files neither the software database from where the files came from. When i try to recover the data using (OS server 2003)Symantec BackExec 10d, the log reads ...

Update with Where Exists problem

Phill - 3 Aug 2006 8:35 PM - 3 messages

I'm running the following query to update some rows. The problem is it is updating rows that are not met in the Where Exists clause. Does anyone see where I've gone wrong? Thanks. UPDATE OUPT_PRD.REQUEST_LINE ...

where download full version of report service 2000

ITDUDE27 - 3 Aug 2006 8:19 PM - 2 messages

Can anyone point me to a link where I can download a full version of report services 2000? not the 120 days trial version. I would think this is out there on the web somewhere. R ...

Fastest way to translate data for normalization in MS SQL

sdwebguy - 3 Aug 2006 8:18 PM - 3 messages

I am running SQL 2005. I am importing data from a 3rd party that contains categories and subcategories. The data looks like this (the :: are just for visual purposes, representing the different columns in my table): categoryPathID :: categoryLevel :: categoryName :: categoryPath ...

How to do a restore a .BAK database - SQL 2005

Henry Jones - 3 Aug 2006 8:09 PM - 8 messages

I did a backup of a database using SQL 2000 about a year ago. I have two files. general.BAK and general.TRN. I created a blank database in SQL 2005 called general. I tried to restore in SQL 2005 this backup but was unsuccessful. I got an ...

problem using date in UNION query

Dan D. - 3 Aug 2006 8:06 PM - 4 messages

Using SS2000. Here is my query: select tblTasks.numTaskId, tblFranchise.numFranchiseId AS LicenseNumber, tblFranchise.numEnterpriseId, tblTasks.numCompanyId, tblFranchise.varFranchiseName, tblCompany.varCompanyName, tblTaskDetails.numTaskDetailsId, tblTaskDetails.numTaskId, tblTaskDetails.dtTaskDate, tblTaskDetails.numCommunicationType, tblTaskDetails.numCommunicationTypeResult, tblTaskDetails.numCompanyStatus, tblTaskDetails.intTStatus, tblCommunicationType.varCommunicationTypeName, tblCommunicationTypeResults.varResultName, 'Mailed' AS Item, '' AS ...

How to caught unknown exceptions when parsing the XML in stored procedures

jayanth.vishnuvardhan - 3 Aug 2006 7:46 PM - 2 messages

Hi How can we find out that there is some problem like invalida data type or data is null or some data type errors occured when parsing the XML in OPENXML. Basically what I want is , Is there any way to find out in the SQL ...

Concatenate with UPDATE?

Don Miller - 3 Aug 2006 7:43 PM - 5 messages

I guess I'm missing the trick to append characters (varchar) to an existing text column. I want to do something like this: UPDATE Notes SET NoteText = NoteText + '******' + @varchar WHERE NoteID = 99999 And I keep getting "Invalid operator for data type. Operator equals add, ...

server name woes

airwalker - 3 Aug 2006 7:06 PM - 3 messages

I just got bought a used computer, and Im trying to change the server name, I've changed the computer name and restarted the computer, I've also used query analyser and changed the server name, but when I try run an c# ...

BCP error - "Unexpected EOF encountered" when using native format

ScottC - 3 Aug 2006 6:54 PM - 5 messages

Hi all, I am getting the ol' EOF encountered error when trying to BCP into a table using native format. It works great using character format but unfortunately I need to use native format due to replication restrictions (trans replication uses bcp behind the scenes and allows ...

BCP error - "Unexpected EOF encountered" when using native format

ScottC - 3 Aug 2006 6:48 PM - 1 message

Hi all, I am getting the ol' EOF encountered error when trying to BCP into a table using native format. It works great using character format but unfortunately I need to use native format due to replication restrictions (trans replication uses bcp behind the scenes and allows ...

Database performance question

SAM - 3 Aug 2006 6:48 PM - 3 messages

Does anyone know of any utility to stress test a database without causing more overhead to the performance? I have a database that suspectingly is running slow or is being accused of running slow. I am not sure if it is the web servers, the web application or ...

VS 2005 and SQL Server 2005 Remote Debugging Issue

inkyuser - 3 Aug 2006 6:33 PM - 2 messages

I am having quite a bit of problems getting this to work properly. I am on a Windows XP Professional SP2 machine trying to connect to Windows Server 2003. I have Sql Server 2005 installed on the Server ...

Converting DateTime

Scott - 3 Aug 2006 6:09 PM - 3 messages

There maybe a more efficient way to write this, but I normally use the CONVERT() function like CODE 1 to transform a DATETIME field, dtMyDateTimeField, so it gets rid of the time part as shown. I do it this way so when I query from Excel, I only see 1/3/2006 for this example inside ...

Selecting the Top Nth Record and the Value of N increments by 1 Everytime

rishabhshrivastava - 3 Aug 2006 5:59 PM - 2 messages

Hi All, I want to Select the MAX of TOP Nth Record and this Value of N should be incremented by 1, I am using WHILE LOOP but getting an error Please let me know what am I doing wrong.. ...

Help with query please

bill - 3 Aug 2006 5:51 PM - 3 messages

Hi all. Can anyone help me? I have 2 tables, typical one to many relationship related by id. t1 id cola colb with a row like this: 1 xxx yyy t2 id colc with rows like this: 1 zzz 1 jjj ...

Insert with begin transaction without closing it.

Excequiel Aróstica - 3 Aug 2006 5:14 PM - 1 message

Hello! I am working in SQL server 7 and I have the following problem I have executed an insertion using before the insertion begin transactions without closing it, is to say without its corresponding commit or rollback, I have done commit, but the data in the table do not appear. It is possible that it ...

Inserting data into a partitioned view via Linked Server

SGCSNA - 3 Aug 2006 4:29 PM - 1 message

Is this even possible? When trying to insert data using the query below into a partitioned view that is on a linked server, I get the following error: 'SQLOLEDB' IOpenRowset::OpenRowset returned 0x80040e21: [PROPID=DBPROP_COMMANDTIMEOUT VALUE=600 STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID VALUE=True STATUS=DBPROPSTATUS_OK], ...

views - necessary to index if underlying tables are indexed?

KJ - 3 Aug 2006 3:45 PM - 3 messages

Hello, Just a general question: If I access a view using the same kinds of queries as I would the underlying tables, and the underlying tables are indexed, is it necessary to index the view, or are the table indexes used? ...

Join??????

Curtis - 3 Aug 2006 3:43 PM - 5 messages

Select Distinct t1.ClientID, t1.ScanJobHeaderID, t1.SearchEngineGroupID From dbo.table1 t1 INNER JOIN dbo.table2 t2 on (t1.ScanJobHeaderID != t2.ScanJobHeaderID) ...

Finding if SQL is 32-bit or 64-bit.

Matthew - 3 Aug 2006 3:23 PM - 2 messages

I know that Select @@Version works, but is there a better more reliable way to tell if its x64 or x86 that i don't have to parse the string. ...

Recovery model

David - 3 Aug 2006 3:18 PM - 6 messages

Hello, How can I find the type of recovery set to a database from the system tables? Thanks in advance ...

Retrospectivly apply a default constraint

Russell - 3 Aug 2006 2:48 PM - 2 messages

I have the code below which will add the default constriant I want. Is there anyway to make it apply retrospectivly to the existing records? ALTER TABLE JOB WITH CHECK ADD CONSTRAINT [Setpermanent] DEFAULT 'P' FOR USR_VB_JOBTYPE ...

How to Copy a DTS Package to Another Server in Enterprise Manager?

Emily - 3 Aug 2006 2:45 PM - 2 messages

I'll need to copy (or move) a DTS (Data Transformation Services) package to another database server. I want to know what steps I should follow in order to accomplish the task in Enterprise Manager. In Enterprise Manager, the package is located , under the current ...

Trigger. Check update on multiple columns

davethomas92 - 3 Aug 2006 2:24 PM - 5 messages

Hi, I have a table with 65 columns and a trigger to react one way when column 3 is updated and react another way when column 3 and any of the others are updated. Is there a quick way to check what has been updated. I know I could do ...

SQL Server 2005 timestamp

geir.forsmo - 3 Aug 2006 2:16 PM - 4 messages

Hi! Is it possible to use comparisons sql server 2005 timestamps, like operators greater than, less than on two sql server timestamps? We want to compare two fields in a record to see what is the latest, and so on. If you know how, please give me an example on how to do it? ...

Date Conversion to YYYYMMDD

wnfisba - 3 Aug 2006 2:11 PM - 4 messages

I have to convert a datetime column to YYYYMMDD format in an extract I'm performing. I checked SQL Server Books Online and there does not seem to be a conversion style for YYYYMMDD. Can anyone help me with the SQL here? Is there any way to convert this date ...

Inserting row into view???

Ted Locke - 3 Aug 2006 1:21 PM - 3 messages

This is kind of a repost. Is it possible to insert data into a view using case? Example would be: case when status = 'Fall-Off' then insert (select statement) else 'normal line' end I currently have this all posted from two days ago and I am under the gun to ...

Cursors

Robert Bravery - 3 Aug 2006 1:07 PM - 4 messages

HI all, I need to loop throu a cursor and then insert rows. But I need the cursor to be populated from data retrieved via a SP with Params how can thin be done Thanks Robert ...

Incorrect Syntax

robken - 3 Aug 2006 12:39 PM - 2 messages

I've have written the following piece of code, but it keeps saying theres something wrong with the syntax near the last "END" can anyone see what I've done wrong.. DECLARE @eu3 AS Varchar(5), @sup3 AS DECIMAL(5,2), @indid AS INT, @ind ...

How to load a list of Integer into temp table by SP

mullin - 3 Aug 2006 12:27 PM - 6 messages

hi, i have a sp and one of the input parameters is a list of integer, i.e. '2181440,2183149,21221111'. how can i convert it into temp table at sp? create table #table1 ( AccountCode int ...

Recognizing a function name without the Database and Owner

rmcompute - 3 Aug 2006 12:23 PM - 4 messages

I created a function as: Create Function u_fnSRWorkDayCalc And then used in a stored procedure, however, the only way I could get the stored procedure to recognize it was to code it with the Database and Owner: SvcReports.dbo.u_fnSRWorkDayCalc. I would like to port the stored procedure ...

sp_recompile for user defined functions

Y. NAKAGAWA - 3 Aug 2006 12:19 PM - 6 messages

Hello, I have to rerun a 'create function' script on the management console to renew stale references in the user defined function to external objects which had been changed. I am looking for a counterpart of sp_recompile or sp_refreshview for user defined functions (without schemabinding). ...

Date manipulations

ricky - 3 Aug 2006 11:41 AM - 2 messages

Hi I am trying to write : SELECT CAST(CAST(YEAR(GETDATE()) AS CHAR(4)) + RIGHT('0' + CAST((MONTH(GETDATE())-1) AS VARCHAR(2)), 2) + '01' AS DATETIME) but instead of hardcoding the DAY to '1', I wish to use the GETDATE(), as ...

Date manipulations

ricky - 3 Aug 2006 11:41 AM - 3 messages

Hi I am trying to write : SELECT CAST(CAST(YEAR(GETDATE()) AS CHAR(4)) + RIGHT('0' + CAST((MONTH(GETDATE())-1) AS VARCHAR(2)), 2) + '01' AS DATETIME) but instead of hardcoding the DAY to '1', I wish to use the GETDATE(), as ...

using parameter for filename in stored procedure

Netherxx - 3 Aug 2006 11:00 AM - 3 messages

Hi there, I am trying to use a filename from a vb.net application as a parameter in a stored procedure. However, i don't know exactly how to put the parameter into the stored procedure. I know how to configure the stored ...

Inheritance of related objects in a tree

Robert Bravery - 3 Aug 2006 10:48 AM - 3 messages

Hi all, How does one go about creatig the correct inheritence of a tree structure If I have a table containing a tree structure. The parent table could be related to a cild table with some aditional related properties. Under normal ...

Strange bug in linked servers

Panda - 3 Aug 2006 10:33 AM - 4 messages

hi all In my SQLServer 2000, i have a linked server "lnksrv" to another SQLServer 2000. Into lnksrv there is a table "test" with the fields: - I_ID int (prymary key) - I_Integer int - T_Text text When i try the query: SELECT isnull(I_Integer, 0) as I_Integer, T_Text ...

Check permission to run a statement

cold80 - 3 Aug 2006 9:52 AM - 2 messages

Do you think there's a way in SQL Server 2000/2005 to check if you have the permissions to run a specific SQL statement without running it? I'm trying to write a small application that executes SQL scripts, but I ...

SQL Server 2000 (8.0) update stats doesnt work

Steve Cartwright - 3 Aug 2006 9:00 AM - 4 messages

keywords: sp_updatestats auto update stats statistics sql server 2000 8.0 8.0.0.760 Windows 2003 SP1 We experience following problems on our SQL-Server 2000 SP3a (SQL Server 8.0.0.760) running on OS Windows 2003 SP1: ...

Interpreting query execution plan in sql2000

Deva - 3 Aug 2006 8:53 AM - 4 messages

Hi, I could not understand 100% (fully) about the details displayed in query execution plan, server trace and client statistics. I am interested to learn the information covered in query analyzer about the following areas :- Show Execution Plan Show Server Trace ...

General Network Error: Please help

mohanv - 3 Aug 2006 7:11 AM - 1 message

Hello, We are facing the 'General network error. Check your network documentation.' error at random from our ASP application on Windows 2003 connected to the MSSQL 2000 database server through a crossover cable. We receive both recv() and send() errors. The only peculiar ...

Could not find stored procedure 'master.dbo.xp_smtp_sendmail'.

Anderson - 3 Aug 2006 7:10 AM - 2 messages

Hi, all I execute the following statements declare @rc int exec @rc = master.dbo.xp_smtp_sendmail @FROM = N'MyEm***@MyDomain.com', @TO = N'MyFri***@HisDomain.com' ...

READTEXT as parameter for SP

Carl - 3 Aug 2006 3:44 AM - 2 messages

I'm trying to convert a view to a HTML script in one stored procedure, send it to an email stored procedure which will email it using SMTP. I can create the HTML script with out problems but it is too big for ...

Move Database to Another Server

Emily - 3 Aug 2006 2:07 AM - 3 messages

Hi All, I'll need to move a database from one server to another in the Enterprise Manager. How can I move it? If I need to move some stored procedures over as well, what are the specific steps taken to accomplish this? ...

Find missing numbers

How to Fill a Uniqueidentifier Field

TABLE_SCHEMA/OWNER QUESTION

Group by Date in DateTime field

NEWSEQUINTIALID()

SImple Delete Statment Help

Send email from MS SQL using xpsmtp.dll

sp_lock -> Exclusive Vs. Shared Mode

Newb Design Q: when to make table

Slow Stored Procedure Execution

Get system information about a database

Interesting Question

Crosstab

Esoteric problem - join to a view bypasses view conditions in date interpretation

Does for loop read files in a folder alphabetically?

TSQL to read (and write) in the Active Directory

Multiple-step OLE DB operation error in SELECT

Fulltime opportunities in Silicon Valley

Update table field removing all non-numeric characters

Join Question

how to specify a dynamic create string as backup name in job

KeyPress in C#

Add column names of a table as first row of a table for export reasons

Make a copy of live database

How to use "Not Exists" ?

CASE or IF statement?

Calling Stored Procedure from stored procedure

design question: deleting a customer record. archive / delete / flag?

Eliminate duplicates

Full Text Catalogues

log shipping not working

Selecting data from many columns to one

Replace a character

Generating multiple rows with xml data column

export from oracle

Deleting duplicates

NOT IN problem

Help in writing hierarchical query

Help in using index tuning wizard

delete rows timeout

Sign in comp.database.ms-sqlserver

UPDATE and SELECT INTO #temp table difference between SQL2000 and SQL2005

Extract a Unique value from a set of duplicate records

Inserting international characters

Have no idea how to do it!

Table statistics

Grant Execute

How to add return values from stored procedures?

Comments generator

how to create trigger and procedure

GET from URL with CLR

One small question

Internal Query Processor Error: The query processor encountered an unexpected error during execution

Transaction (Process ID 53) was deadlocked.............

Full-text search, user instance, and SQL Server Express

Alias Name...

Simple SELECT issues(?)

Selecting TOP 1 of each group

storing blobs in file system (as opposed to database)

Email Notification option not available on scheduled jobs

Where are the sample database files - 2005

Best way to make this Query

EXEC(@sDynamicStatement)

BULK INSERT

Stored Procedure question

SQL restore still Loading

logging

I am new, trying to create a complex view.

getting latest data within a group by

Need Helps for A Query

Data model: Comments...

Two blanks to be changed to one

Syntax problem with conditional field

Help with case when

Find first digit in numeric

How do i find all available login in sql server through query / sp

DateTime!!!

How to find stored procedures affected by table changes i.e column addition/deletion

Interpreting SQL Server Error Log File

How make OSQL execute ALL .sql files in a folder?

Want your opinion: ID vs Number

Help with having clause

SQL Server 2005 integration with Visual Source Safe

IDENTITY column expects a value

(Problem) DB-Library on SQL Server 2005 with named instance

New Stored procedure template in SQL Server 2005

query help

Update a memo field

SQL Server gets busy, users timed out, what is going on ?

Using Image Data Type

Variables and column titles

Update Query returns error

Query performance issue

Scalar functions and their limitations

How to group rows ?

Object Search

( The cursor is READ ONLY.The statement has been terminated), WHY???

Moitoring Performance

Should I worry that my Access to SQL conversion has gone so well

More than 4000 characters in a variable used for a sqlqct statemen

Selecting more than one row.

#temporary table in EXEC

[SQL Server 2000] Deriving a temp table out of an existing one.

How Can I Update DBF foxpro Table From Sp

Dynamic SQL error processing question

SQL Statement

Towel tossed in on use of BETWEEN

select count in 2 tables

Help with this

show all when parameters are null

How have one script execute several others?

DATEPART alternative in T-SQL that works similarly to VB6/VB.Net DATEPART

History Table Problem

How to show a progress meter of backup process

Unable to SET DATEFIRST to a variable within stored procedure

Stored Procedure problem

columns_updated() gets inconsistent values?!

How to do date formatting on Calendar Control of Asp.net with c# by sql server table for Fiscal year

Date Time Format

What data type should I use, Varchar or Decimal/Numeric

Question: when/how does the filegroup of Tempdb database clear its

updating table without using cursors?

how to make sure the values returned for a particular field returns negative values instead of posit

Checking if row exists

CASE WHEN not working

Index and Size

Problems with Dates and INSERT query

OLE DB data type to SQL Server 2005 conversion

Error when Using : Exec sp_MSForeachDB

Isnull - subquery

How to Merge Multiple Records in a Single Record

Urgent:601 - Could not continue scan with NOLOCK due to data movem

Hierarchical Data Retrieval

Management Studio keeps trying to recover files

SQL query as parameter

Advantages and Disadvantages of running a sotred procedure inside another stored procedue

simple query taking 3 minutes

Updating new column from a

Decimal returning integer?

Can you find the right T-SQL query for this ?

exception occurred in the TSQL subsystem.

Is there a better solution than this SP?

Getting data from sp_trace_getdata SP

cant get this sql right - please help!

Help with query

Select Syntax

SQLCMD

Cannot resolve collation conflict for equal to operation.

Where clause across multiple rows (Pivot??)

t-sql syntax, append 2 tables records into 1

SP to undo transaction

Use query governor to prevent queries exceeding specified cost

Email SP or View

Update + Join Help

Trigger Help for UPDATE

Database locked when a transaction is started?

udf newbie

beginner question - max of a sum of a column

LISTEN TO SEXY FREE NOW

SEX HOT LINE FREE TRIAL!

Buy 2nd handphone for India market

Multiple ALTER TABLEs dont seem to work?

dts-copy database tables

Attach Database?