|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
SQLDMO: Registry->AutostartMail property - where in registry?
Mark Findlay -
20 May 2006 8:38 PM - 3 messages
The SQLDMO Registry object exposes a boolean property called AutostartMail. It is always returning FALSE, even though we have database mail configured and enabled in SQL 2005. I assume that since the SQLDMO Registry object exposes this property, that it must be a registry entry somewhere we can examing for verification. But I ...
substring search in each row with a different wildcard
Axel -
20 May 2006 5:11 PM - 15 messages
Hi, I am looking for a solution for the following problem: I have 3 columns in my table of my Customers records; "Firstname", "Familyname" and the "Emailaddress".. Here i want to match the -Firstname and Familyname- with the emailadress, ...
SQL local server db connection
ddevans888 -
20 May 2006 3:22 PM - 3 messages
I have found lots of information on my SQL connection but none of it is helping. I am just learning and I am using Dreamweaver MX. I can see my tables in DW but when I try to run my page I keep getting these ...
to read backup file
Zenek -
20 May 2006 2:38 PM - 9 messages
Hello, I have: - server MS SQL MSDE (2000) - database 'COLLBASE' - table 'MAIN' - row: column 'NAME' value 'version' and column 'VALUE' value '003' I make backup files by SQL query. I have more backups for different versions of this database (different ...
Between clause...
Nando_uy -
20 May 2006 11:10 AM - 18 messages
Hi all, I need write a stored proc with a clause like "between like xxx AND like xxx" so, I can't. Thats is, a stored proc that returns values between two parameters that use wildcards (for instance "LIKE @date"). ...
xp_SendMail subject blank problem
Sayem -
20 May 2006 10:10 AM - 6 messages
Hi, while sending mail through xp_sendmail the mail is sending properly. but subject getting lost while viewing the mail from outlook. can anyone help me. code: EXEC xp_sendmail @recipients = 'con***@maersk.com', @message = 'The master database is full.', ...
**Update**
R-M -
20 May 2006 9:15 AM - 2 messages
Hi I'm working with SQL2000, and I defined the below structure: MasterTable(No numeric(3),desc char(40)) No is PK DetailTable(No numeric(3),code numeric(4),other char(40)) No&Code are PK and I defined an Update Cascade for their relation.and I have an update ...
HW Requirement for SQL Server 2005
perhiyar -
20 May 2006 7:11 AM - 2 messages
We are running four servers at different sites say A,B,C and D and want it to connect main Server at head office what would be the configuration of main server for running SQL Server 2005.There are two ...
"Not enough Storage"
Swami -
20 May 2006 5:38 AM - 7 messages
When I tried to save a stored proedure (in SQL Server 2005 Express), I got an error saying "The operation could not be completed. Not enough storage is available to complete this operation." Any idea what is causing this error to pop up? I still have about 4GB disk ...
SP - drop table problem
Agnes -
20 May 2006 3:41 AM - 5 messages
In my store procedure, i will select some data into a temp table and then drop it . I am wonder if there are several people run the SP , will they create the same table at the same table ?? Please help ~ ...
performance questions
Howard -
20 May 2006 1:51 AM - 2 messages
In a case where I'm not sure how many columns Im going to use should I just use select * from table1 or select col1, col2, col3, col4... from table1 Is there any disadvantage for using select * in terms of performance or ...
Slow Insert On Linked Server
Derek Hart -
20 May 2006 1:43 AM - 2 messages
It seems that if I am pulling data from a linked server down to my local server, all works fine. But pushing data up to the linked server takes 100 times longer. How can I efficiently write this statement to insert records ...
Block to drop any object with ddl triger
retf -
20 May 2006 1:19 AM - 4 messages
Hi all, I want block attempt to drop any objects(tables, sp, views...) of my data base. Have way to do this? I did see same thing about DDL trigers, any one can sed-me one sample? Thanks to all ...
Referential Integrity - Countries & States/Provinces
Dan Manes -
20 May 2006 12:12 AM - 14 messages
I have a Country table with (surprise!) countries, and a Locale table with states, territories, provinces, etc. I also have another table, Port, that usually contains Country information but only occasionally contains Locale information. My question is, how do I set up the foreign keys maintain referential ...
Hidden Master, Model, MSDB, and Tempdb Databases.
Mark -
19 May 2006 11:26 PM - 4 messages
Thanks in advance. I have an instance of Enterprise Manager for SQL Server 2000 on my desktop that does not list the above databases. When I attempt to add any of them, I receive: "Error 5123: CREATE FILE encountered operating ...
Production Server Down - help!!
abd08 -
19 May 2006 11:03 PM - 6 messages
Hi All, Newbie here, and in typical newbie fashion, has managed to down our "live" server. People are back on Monday, so I have this weekend to fix the problem. Was running an operation on the DB via my ERP s/w (deleting a user ...
how to supress instance name while logging to sql server 2005?
cooltech77 -
19 May 2006 11:00 PM - 2 messages
Hi, I am using SQL server 2005 express edition on win XP installed on my machine. when I use the SQL server Management studio, I have to enter machinename\SQLExpress .How can I connect using just machinenname and omit the SQLExpress instancename?what settings do i need to do? ...
Slow Join On Linked Server
Derek Hart -
19 May 2006 9:29 PM - 2 messages
It seems that if I am pulling data from a linked server down to my local server, all works fine. But pushing data up to the linked server takes 100 times longer. How can I efficiently write this statement to insert records ...
SMO not installed for SQL Server 2005
Jon Limmer -
19 May 2006 8:39 PM - 2 messages
I installed SQL Server 2005 with all the server tools selected (other than the sample databases) on my server and then installed all the connectivity and tools on my own machine (ie, no database, BI, Reporting Services, etc). I want to program against the Server Management Object (SMO) model using VS ...
HELP! "could not complete cursor operation because the set options have changed since the cursor was
Stewart McGuire -
19 May 2006 8:32 PM - 3 messages
I am declaring a dynamic generated cursor in a nvarchar string and passing it to sp_executesql. I then want to open it and loop over the results using FETCH INTO. This worked fine in SQL 2000. In SQL 2005 I get the error ...
Help With the CASe syntax
Jim Abel -
19 May 2006 8:19 PM - 4 messages
I', trying to get the following case staement to work and am not sure if what I'm trying to do is valid. Based on one fields valur I want to perform an operation on another fied of the sam record, see query below. ...
How know when one Table was droped? HELP-ME
Retf -
19 May 2006 8:18 PM - 4 messages
Hi all, I have one Data Base, Today one strange thing occur, one table of my data base disappear , I didnt drop it, then i would like know if have way to determine when this occur; The last week same thing occur whit one store procedure. ...
Problem selecting duplicate values.
rhaazy -
19 May 2006 8:02 PM - 3 messages
I am using ms sql 2000. THIS IS THE PART OF THE TABLE I HAVE 18 2 Bytes Per Cluster 19 2 Drive Type 20 2 File System Type ...
need help with a query
Hassan -
19 May 2006 7:29 PM - 9 messages
Create table test (col1 varchar(50),col2 int) insert test values ('ABC',1) insert test values ('ABC',2) insert test values ('XYZ',1) insert test values ('XYZ',1) I would like the output to report those unique values in Col1 that have ...
FOR clause in mssql2k5.
ChrisR -
19 May 2006 6:56 PM - 4 messages
Here is the BOL example for the PIVOT function: SELECT VendorID, [164] AS Emp1, [198] AS Emp2, [223] AS Emp3, [231] AS Emp4, [233] AS Emp5 FROM (SELECT PurchaseOrderID, EmployeeID, VendorID FROM Purchasing.PurchaseOrderHeader) p PIVOT ( COUNT (PurchaseOrderID) FOR EmployeeID IN ...
temporary view
Anatoli Dontsov -
19 May 2006 6:45 PM - 10 messages
Hi, All! I have many tables with name convention tYYYYMMDD and set of SPs to perform some calculations. Ideally I would need "temporary view' functionality. CREATE PROC MyProc (@tablename) AS CREATE TABLE #mytable (dt DATETIME) EXEC ('CREATE VIEW #myview AS SELECT * FROM ' + tablebame) ...
Select strategy
nathan001 -
19 May 2006 6:27 PM - 6 messages
Strategy should I use the following to select the last posting in my forum group in order to get the last poster I use the function that follows or should I use the select at end that subqueries everything?. view= ...
use static tables or create tables at runtime?
Mark Duncan -
19 May 2006 6:14 PM - 5 messages
i'm developing an application that currently creates tables in the database after a user has completed the design for a workflow. having never created an application like this i keep having second thoughts about whether this is a good idea or not. i keep debating with myself whether i should force all ...
Triggers and bach insert
bill -
19 May 2006 6:12 PM - 3 messages
I'm using an INSERT INTO...SELECT * FROM bulk statement to insert records into a table. If I write a trigger on the target table that executes on INSERT, will the trigger fire for each row inserted? If not, how can I get ...
Use DISTINCT and still retrieve all columns
Bank -
19 May 2006 6:10 PM - 4 messages
I'm sure this is an old question. I want to exclude duplicates in one column while still pulling all columns as if I used SELECT *. Can this be done? Thanks, Bank ...
understanding what trigger is doing
Dan D. -
19 May 2006 6:10 PM - 12 messages
Using SS2000 SP4. I ran this update statement "Update tblCompanyContacts SET varCompContactPhone
=REPLACE(varCompContactPhone,'abcdefghijklmnopqrstuvwxyz()-_+=!@#$%^&*,.?/:;','') " and it fires off this trigger CREATE TRIGGER [SetPrimaryContact_Company] ON [dbo].[tblCompanyContacts] FOR INSERT, UPDATE AS IF (Select bitCompPrimaryContact From Inserted) = 1 ...
Help - Can Execute return a value?
tvamsidhar -
19 May 2006 5:48 PM - 5 messages
Hello I'm relatively new to SQL Server/T-SQL and find myself stuck with this problem: I need to do something like this: Declare @someValue NVarchar(100) Declare @someFunction Varchar(100) -- -- Assign value to @someValue from a Cursor ...
Could not create an instance of OLE DB provider 'Microsoft.Jet.OLE
cooltech77 -
19 May 2006 5:39 PM - 10 messages
hi, I am running the following query and getting this error. Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. OLE DB error trace [Non-interface error: CoCreate of DSO for Microsoft.Jet.OLEDB.4.0 returned 0x80040e73]. ...
Is it possible to update two tables with a single statement?
Matthew Speed -
19 May 2006 5:06 PM - 3 messages
I have a feeling this isn't allowed, but is there any way to update columns in two different tables through a join in the update syntax? TIA ...
Optimize the query performance
Pushkar -
19 May 2006 4:51 PM - 4 messages
Hi, I am saving the data of profiler into trace table every day and then export this data into table called RepositoryTable. RepositoryTable has exactly same structure as profiler trace table. Every day I am inserting 10 lakhs rows of trace events in the Repository ...
Delete 'Non-Unique' Rows Question (with DDL)
Brian J. Ackermann -
19 May 2006 4:50 PM - 12 messages
Hi all, I'm working on a query which will ultimately be used in a stored proc for a report. This report will quite simply list the components that are unique to a particular customers goods. I've created a mechanism ...
Nested IF statement and Declare problem
Daniel Regalia -
19 May 2006 4:47 PM - 8 messages
This is prolly more of a gut check, but needed to know if this looks right. I am making another Scalar function.. CREATE FUNCTION [dbo].[EvalTradeCode] ( @tradeSymbol char(15) ) RETURNS int(1) AS BEGIN Declare @intOffset int ...
Is this index redundant?
pshroads -
19 May 2006 4:37 PM - 12 messages
Let's say I have a table: create table example ( id int, createtime datetime, name varchar(20)) go create index ix_createtime on example(createtime) go create index ix_createtime_name on example(createtime, name) ...
Splitting name column into seperate columns
M Stuart -
19 May 2006 3:57 PM - 6 messages
I would like to split a Name column which holds the full name with spaces into 3 seperate columns. ie Title, Firstname, Surname. Regards Mike ...
Quick Dumb Question
Matthew -
19 May 2006 3:37 PM - 2 messages
Quick Dumb Question I was wondering if there was a way to revel what format a query returns per column. I am running into the situation where I am pulling data from a huge list, and occasionally I get the error "Implicit conversion from data ...
Using a CASE to Determine if a Column is included in the SELECT clause
col1blb -
19 May 2006 3:27 PM - 8 messages
I have a query that returns 7 columns, the first is a date and the other 6 are money columns. Now if the total for any of the money columns is 0, i dont want to have that column selected. I have my ...
Moving Data Question
David Olsen -
19 May 2006 3:25 PM - 3 messages
I tried posting this once but I had no luck as I don't think it appeared. How does one do the following considering that an identical table in Database2 also exists in Database1? INSERT INTO Database1.Table1 SELECT * FROM Database2.Table2 ...
Is there a correct syntax for writing a query?
VMI -
19 May 2006 3:21 PM - 6 messages
Is there a best syntax for writing a query (specifically in sql server with t-sql)? I've written a few with the JOIN keywords but I mostly write them using '=', '*=', etc.... Is there a more 'sql-compliant' way or is it just a ...
Backup-only ID
Stephanie -
19 May 2006 3:06 PM - 1 message
I have a stored procedure that I use to execute database backups. It deletes old backup files and then creates the full backups of all the databases. I want to create an ID that can only execute this procedure. I tried ...
Newbie question - Need count to return multiple values
Nancy R -
19 May 2006 3:02 PM - 3 messages
Hi all, This is probably a simple question but I still new enough that I can't figure it out (this is only my second real query i'm so REALLY new). I have a table that looks like this: ...
Get active directory users from SQL Query Analyser
Rui Oliveira -
19 May 2006 2:57 PM - 2 messages
Get active directory users from SQL Query Analyser ...
Problem with query
meendar -
19 May 2006 2:31 PM - 5 messages
I have the table persons with fields lastname - varchar id - numeric i want to update last name to null if id and lastname are equal. i tried the following query, but it not works update persons set lastname=null where lastname like id; ...
SQL Query Help
schoultzy -
19 May 2006 2:26 PM - 6 messages
Hello Everyone, This is probably a simple fix so be kind when/if you reply. The query below retrieves information for individuals based on a column named ATTRIB_DEF, and assorted other columns; however, the ATTRIB_DEF column is important one. Currently the query gets all individuals that have ...
Different between ##table and #table regarding performance
haenselmic -
19 May 2006 2:16 PM - 25 messages
hi also i want to know what have more performance : a table variable or a temporary table in a stored procedure the rows in the tables are approx. 1000 thanks michel ...
Generating Nested XML Tree nodes in SQL Server 2000
Rajesh -
19 May 2006 2:11 PM - 3 messages
Dear all, I have table called CATEGORY, which is defined as follows: CREATE TABLE CATEGORY ( CATEGORY_ID INTEGER IDENTITY(1,1) NOT NULL, CATEGORY_NAME VARCHAR(40) NOT NULL CONSTRAINT UC__CATEGORY__CATEGORY_NAME UNIQUE, PARENT_CATEGORY_ID INTEGER, ...
Dynamic SQL Query
pisquem -
19 May 2006 2:08 PM - 6 messages
I am having trouble getting this dynamic query in a sp working and the code is below so can someone please help me? It would be very much appreciated. I want to build this query with only values that have values that ...
Problems while migrating from MSSQL 2000 to 2005 - select... into fails in a trigger - please help.
master -
19 May 2006 1:58 PM - 11 messages
Hi, We have just migrated from MSSQL 2000 to MSSQL 2005. Everything seemed to be working for about a week, when we realised that... no actual data in the DB is updated. The problem is quite difficult to find, because the failure ...
Applying aggregate function to whole table
youretoast -
19 May 2006 1:50 PM - 2 messages
Here is my problem and I suspect this is a simple question for the experts. My query attempts to get the names of players that played in a game during the past x minutes and then the average scores of that player ...
Automatically reformat SQL Keywords to UPPER CASE
SOG1 -
19 May 2006 1:40 PM - 3 messages
Is there a way to get SQL 2000 Query Analyzer or Visual Studio 2003 to automatically re-format SQL keywords to upper case as you type? I can do this in Ultra-Edit by editing an external file that contains all of ...
sp question re: dynamic sql
Dan D. -
19 May 2006 1:06 PM - 20 messages
Using SS2000 SP4. I have a question about the following code. CREATE PROCEDURE dbo.usp_GetSelectTempTasksUser @intUserId int AS BEGIN Declare @SQL VarChar(1000) SELECT @SQL = 'SELECT TOP 100 * FROM (SELECT ...
Select Count(*) Speed Help
Mattbooty -
19 May 2006 12:57 PM - 5 messages
Hello, I have a piece of 3rd party software that we recently upgraded to a new version, the new version takes a long time to load up each order because every time it loads the order entry module it runs a Select ...
Stored Proc SQL 2000 and Dates
steven scaife -
19 May 2006 12:57 PM - 8 messages
I have written a stored procedure but i cant get it to function with dates and i get the following error: Error converting data type nvarchar to datetime. If the stored proc had a sql string like SELECT T.Summary, T.Priority, T.DateRequested, T.AssignedTo, ...
Crazy Row Numbering Poblem
rhaazy -
19 May 2006 12:27 PM - 9 messages
I'm using ms sql 2000. First here is a sample of my XML input: - <scan ID="18.0" Section="System Restore"> - <scanattributes> <scanattribute ID="18.0.0.0" ParentID="" Name="Description">Removed ...
website auditing
Ganeshen -
19 May 2006 12:16 PM - 4 messages
Hi, My web server has MsSql at the back-end and asp at the front-end. A UserID, Password, and a dynamically generated code field are present on the website for the user to logon. UserID field takes an EMAIL address as input. There ...
Manage huge amount of data
Rakesh -
19 May 2006 11:07 AM - 3 messages
Requirement: 1 billion records to be inserted every day 180 days data to be maintained 180 * 1 billion records = approx no of records = defines the size of the database Need to design the database/process to maintain so huge data? ...
Local settings
Ana_T -
19 May 2006 10:45 AM - 1 message
Hi, My Server Win2k's regional settings are set to Spanish (Spain-Traditional) and the currency to Euros. When setting a field in a table to money, the amount is displayed as pta with two decimals (ptas = pesetas old monetary system). ...
Chinese characters
mrajanikrishna -
19 May 2006 10:23 AM - 2 messages
After a long search, I found this article i thought to solve my problem. I am using Win 2000 Advanced Server, SQL Server 2000 standard edn. dotNET F/W 1.1 My table structure is empid integer ...
MDF - Basic Question
S Chapman -
19 May 2006 10:09 AM - 2 messages
Is it possible to 'query' an mdf file using MS Jet Provider or somethnig like jet provider without having to 'attach' the mdf as a database on SqlServer. Thanks. ...
SQL 2005 ORDER BY problem
lightHammer -
19 May 2006 9:24 AM - 3 messages
Hey guys I see google returns multiple links for a bug that is not corrected in SP1 for SQL2005? If you use a predifined View / FUNC and USE a combination of TOP ?? AND Order by ?? on the view or func ...
Calling Stored Procedure from COM+
aaron -
19 May 2006 9:18 AM - 4 messages
Dear All, We're trying to resolve a rather odd performance issue on one of our servers. We have a COM+ component calling a stored sprocedure in a SQL Server database. The COM+ component is on a different machine, so the call is ...
xp_loginconfig 'Default domain' returns unexpected result
Brian Nielsen -
19 May 2006 9:10 AM - 2 messages
Hi When running the command xp_loginconfig 'Default domain' on SQL Server 2000 and Windows 2003 Domain controller, the expected result is <Domain name>. This works on 2 out 3 of our setups, but on the last setup the command ...
urgent please
amjad -
19 May 2006 9:01 AM - 6 messages
Hi i have a varchar variable called @sql @val1 varchar @val2 varchar set @sql=val1 + val2 the problem is when either of one has null value suppos val1 has null value then @sql not accept val2 and put null value i dont know why its doing like ...
Changing a SQL login from DBO to SA ( and back )
Guus Kramer -
19 May 2006 8:54 AM - 2 messages
Hi, Looking for a proper way to change a SQL login ( not a domain user ) from DBO to SA ( and back if a curtain action has finished ) using TSQL. This user is NOT connected to any role therefor sp_droprolemember/ sp_addrolemember is not appropriate. ...
Self-referencing UPDATE Statement on a single field
ricky -
19 May 2006 8:53 AM - 5 messages
Good Morning I have the following table format, whereby I need to stamp all records for that policy with the most current transaction's Master_Flag. Audit_Number Policy_Number Master_Flag Trans_Date ...
All about the PIVOT - HELP!!!!!
Ian -
19 May 2006 7:37 AM - 5 messages
Hi all, I have a problem whereby i need to convert multiple row data into a single row for instance if i have a table CliID Code V D T ...
Unique Index Creation - Warning
Mothi -
19 May 2006 7:23 AM - 3 messages
I have table of structure as create table (AccountID int, CompanyID tinyint, Account_No char(20), Status char(1)) and having primary key with AccountId Sampla date 12001, 1, 1000-010, a 12002, 1, 0710-207, a 13012, 2, 123-9410-034, a ...
user definde global variable
checcouno -
19 May 2006 6:21 AM - 4 messages
Is it possible to difine a new global variable like @@MYVARIABLE accesible from all my stored procedure in my catalog? Thanks ...
export resultsets in ms access
Vikram -
19 May 2006 6:19 AM - 2 messages
I have a sp which return mutiple result set. Is there any way by which i can export the multiple resultset data in ms access using some tool, DTS etc. ...
Communication Link Failure
Hassan -
19 May 2006 5:23 AM - 1 message
What are some reasons why you see a Communication Link Failure I have also seen General Network Errors. So is CLF tied to network problems ? Do let me know ...
exclude names that have numbers
Hassan -
19 May 2006 4:53 AM - 2 messages
Eg: Create table test (col1 char(20)) insert test values ('test') insert test values ('test1') insert test values ('te1st') insert test values ('tes') Basically I want the output to return those values that do not contain a number in the entire value.. ...
More On Identity_Insert on Linked Server
Derek Hart -
19 May 2006 4:27 AM - 1 message
The problem is that I want to insert data from my local server to a linked server into a table that I have to turn Identity_Insert ON temporarily. I cannot do the 4 part naming in a joined query (server.database.dbo.table), ...
Problem with convert
Rudy -
19 May 2006 2:23 AM - 7 messages
Hi! I'm trying to figure out this convert, never did one before. The SP I have I have I would like to add to a value. If 50 is in the credits column, and the new value is 25, then it should update to 25. Here is the SP. ...
Set Identity_Insert On Linked Server
Derek Hart -
19 May 2006 1:17 AM - 2 messages
SQL 2000: OK, many problems with setting Identity_Insert on and off on a linked server. One problem is using the set command and getting the error "contains more than the maximum number of prefixes" when I do linkedserver.database.dbo.tablename - dynamic sql does not seem to work well ...
Returning all records that DO NOT contain a 4-character string...
whatageek@gmail.com -
19 May 2006 12:22 AM - 3 messages
Hello, I am trying to query a NTEXT field for a 4-character string and return only those records that DO NOT contain this string. I have converted the NTEXT field to VARCHAR for this purpose, but the query still ...
Copy SPROCs to different database
scott -
19 May 2006 12:06 AM - 4 messages
Is there a manual or code way to copy stored procedures from 1one sql db to another without opening each one, copying, creating a new SPROC in target db and pasting? Can DTS accomplish this? ...
binary checksum like functionality in SQL Server 2005
cooltech77 -
18 May 2006 11:44 PM - 3 messages
Hi, I need to do the following. 1)Query a locally stored MS-Access table based on date. 2)Create 2 temp tables in SQL Server 2005 express edition(installed on local machine) called #yesterday and #today(which contain data for yesterday and ...
Linked Server - Turn Off Constraints
Derek Hart -
18 May 2006 11:04 PM - 2 messages
I want to turn off constraints on all tables on a linked server using: "SP_MSFOREACHTABLE 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'" Should I make a connection to the linked server, and/or use OpenQuery to pull this off? ...
how to access MS Access table from SQL Server 2000?
cooltech77 -
18 May 2006 9:49 PM - 6 messages
Hi, I need to access a MS Access table from SQL Server 2000. Basically this is what I am trying to do. I do not have rights to create anything on the server except temp tables. So I read from the server's SQL table and copy data to MS-Access table on my ...
checking for range
rodchar -
18 May 2006 9:35 PM - 6 messages
hey all, what's the best way to express this in a query? for each employee take the salary and determine which range the particular salary falls in. for instance: 40k falls between 35-40k so the category is 1 ...
BULK Insert
Sudhesh -
18 May 2006 9:13 PM - 3 messages
Hi, I have a stored prod that's doing a bunch of BULK INSERTs. The problem I'm having is if one the BULK INSERTs fails, then the rest of the stored proc isn't executed. I'd like it to proceed to the end and ...
Help with a Query
Matthew -
18 May 2006 9:07 PM - 3 messages
I am trying to get the following all into a single line, so i can run a larger Query and have a nice simple table listing all the SQL servies going on and when it was started. -TIA- CREATE TABLE #System_Monitor_Information_SQL_Information ...
Problem with numbering rows and repeating values.
rhaazy -
18 May 2006 9:04 PM - 2 messages
I AM USING MS SQL 2000 INSERT INTO #temp SELECT * FROM openxml(@iTree, 'ComputerScan/scans/scan/scanattributes/scanattribute', 1) WITH( ID nvarchar(50) './@ID', ...
Problem with numbering rows and repeating values.
rhaazy -
18 May 2006 9:03 PM - 1 message
INSERT INTO #temp SELECT * FROM openxml(@iTree, 'ComputerScan/scans/scan/scanattributes/scanattribute', 1) WITH( ID nvarchar(50) './@ID', ...
Case null
Justin -
18 May 2006 8:46 PM - 3 messages
CASE(@CustomText) WHEN NULL THEN 'Status changed to ' + @StatusDescription ELSE @CustomText + ' ' + ...
case null
Justin -
18 May 2006 8:43 PM - 5 messages
how do you deal with case null? CASE @test WHEN NULL THEN ........... ...
IF-ESLE TO Detemine WHERE Clause
Opa -
18 May 2006 8:30 PM - 8 messages
Hi, I have a SELECT statement whose WHERE clause depends on a condition. I want the following to work: DECLARE @condition bit .... (some code setting condition here SELECT FullName FROM Customers IF (@condition = 0) WHERE Deleted = 0 ELSE WHERE Deleted = 1 ...
Duplicate rows
bic -
18 May 2006 8:05 PM - 4 messages
I am trying to clean up a set of a table where there are some duplicate data with different ids. What's the easiest way to eliminate the duplicate rows, for there are several hundred rows and only about 400 rows are unique. Thanks ...
Problems with my database creation script
javier.ignacio.villegas -
18 May 2006 8:02 PM - 8 messages
Hi, I have a strange situation. I must run the same script in SQL 2000 and SQL 2005. Basically the script does it: IF THE SQL SERVER IS SQL 2005, IT CREATES A NEW DATABASE AND USE IT, ...
Linked Server
Derek Hart -
18 May 2006 7:57 PM - 4 messages
Is there a SQL statement that can detect if a linked server exists? ...
Dynamic SQL Invalid Column name error
Shenoy.D -
18 May 2006 7:41 PM - 1 message
Any idea why this is telling me that the field value I want to pass in is an invalid column name? This is for a "Search By" query. I have a drop down of choices and a text box for the value. I need to search for the value entered in the ...
Dynamic SQL Invalid Column name error
Shenoy.D -
18 May 2006 7:41 PM - 1 message
Any idea why this is telling me that the field value I want to pass in is an invalid column name? This is for a "Search By" query. I have a drop down of choices and a text box for the value. I need to search for the value entered in the ...
Dynamic SQL Invalid Column name error
Shenoy.D -
18 May 2006 7:41 PM - 2 messages
Any idea why this is telling me that the field value I want to pass in is an invalid column name? This is for a "Search By" query. I have a drop down of choices and a text box for the value. I need to search for the value entered in the ...
TSQL Cross-Tab query
Terri -
18 May 2006 7:37 PM - 4 messages
SQL Server 2000 I have a set of data and I want to build a SELECT statement that will return a single row in cross-tab format. Below is my sample data and desired results. Thanks to anyone who could help ...
can't delete a row from primary table - is there an SP for this?
Rich -
18 May 2006 7:01 PM - 14 messages
Hello, I copied a database from our live server to a test server where I could study the database, experiment and so on. I cannot delete/remove a row from the primary table. The table had several relationships, dozens of triggers, ...
Problem with column prefix
rhaazy -
18 May 2006 6:58 PM - 6 messages
I have a rather complex looking sql statement and I've been debugging it for about a day now... So if the answer to my question is obvious forgive me. SELECT t.ScanAttributeID, t.ScanSectionId, t2.scanattribute, (select COUNT(*) FROM #dup, tblScanAttribute s1, #temp t1 ...
Syntax for passing the single-field result of a SELECT statement as an input parameter to a stored p
Next »
|
|||||||||||||||||||||||