|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
Sorting Text Dates
Scott -
10 Dec 2005 10:18 PM - 3 messages
I'm trying to figure out how to sort the below results in Northwind by the month and year. Because my Date is text type, SQL is ordering it incorrect. Anyone know a workaround? I need a solution that will sort the m-yyyy format, but I may even need to ...
SQL Server 2000: How to inject a COLUMN VALUE into an EMAIL???
Alan Mailer -
10 Dec 2005 10:17 PM - 9 messages
Using SQL Server 2000, I want to trigger an email anytime a particular table is appended. I already know the SQL language which will trigger an email, but I need to know something more: Is there a way to add a value from one of the appended row's columns ...
Aggregate Transpose Problem
Scott -
10 Dec 2005 7:12 PM - 3 messages
My example code (CODE 1) returns quarter counts for several fields in Northwind (I'm using Northwind to simulate my actual data). It returns code that looks like FIGURE 1. Can my sql be modified so the Field names are the GROUPED BY and run down ...
Sales Average Query
kevin_james1970 -
10 Dec 2005 4:53 PM - 2 messages
Hi Reader, I'm fairly new to SQL and am struggling with this query. Can someone help me out? I have three tables, Employee, Sale and EmployeeSale. performance by calculating the value of sales each of my staff has made in a qtr and the average no of sales made ...
smo disbale job
B. Mark McKinney -
10 Dec 2005 4:25 PM - 2 messages
In the following function a JobId is passed in that the user wants to disable. The function then retrieves the job collection, finds the correct job, sets the IsEnabled to false and then tries to update the job. This results in this error: ...
Dynamic Criteria for a Stored Procedure
Ryan.Chowdhury -
10 Dec 2005 3:05 PM - 4 messages
Our database utilizes some custom functions and .dll's to perform IRR calcuations. The IRR calculation takes two steps. 1. The first step is to create a view which preps the cash flows and pulls out what you want to analyze. ("Ad Hoc Query") ...
bulk insert question? Another way?
kevin -
10 Dec 2005 1:41 PM - 3 messages
hi guys, I have a text file contains about 1 million rows, I tried to import to a table but I received data conversion errors for some rows, however, the row number is like 504500 for example, I want to troubleshoot this row but the ...
Torn Page Error
SharkSpeed -
10 Dec 2005 1:05 PM - 1 message
Hi, When i attach database occure Torn Page Error. How can i repair my database or get table field structure ? Thanks ...
Need help optimizing a stored procedure - SQL2k
M. Simioni -
10 Dec 2005 12:44 PM - 6 messages
Hi, i was thinking about a way to rewrite the procedure i'm going to explain, to improve performance and take down the whole duration. I have a table with about 5.000.000 rows: TABLE1: ID bigint, ID_PM bigint, DATE datetime, ...other ...
SQL Bug??
marcmc -
10 Dec 2005 11:33 AM - 3 messages
select 717306 * 3000 Server: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. What's the story with this? ...
Left Outer Join and Where Clause
Kiran -
10 Dec 2005 10:29 AM - 10 messages
Hi, I have two tables Table1 and Table2. I need to join Table2 on Table1_SID to get name for SID Column of Table1. But I need all rows of Table1. I can use a Left Outer Join to achieve this. ...
finding missing dates in a sequence
jay -
10 Dec 2005 8:13 AM - 11 messages
I have 200 tables that have data entered into the daily. I need to identify all dates that are missing from the tables. for example: date column1 column2 ...
2 variables 2 sql server connections?
Test Test -
10 Dec 2005 5:51 AM - 2 messages
Hello! DTS pacakge (2 connecttions): Source: Sql server name (abcd) Target: Sql server name (abcd) I have a DTS package that has two sql server connections (source and target). The server is same (abcd) for both source and target sql ...
DTS - SQL Database to Access Database
mcchu -
10 Dec 2005 5:49 AM - 1 message
Hi, I need some help on where I am stucked trying to export the whole SQL Server database into Access database used for analysis. I am trying to do this programmatically for a web app that a user will be able to download the ...
Update Query question.
Trinidad -
10 Dec 2005 12:45 AM - 9 messages
Hi I do have a question about a query on update. I appreciate if anyone could help me. Here is the table I have: Emp ID Lname Fname OfficeID ...
trigger and INSERTED
shank -
10 Dec 2005 12:44 AM - 3 messages
I'm trying to setup a trigger. When a customer buys a package deal of goods, I want the trigger to populate OrderDetails with all the extra product. I realize that I have to use the INSERTED table to analyze one specific order, ...
Customer specific price matrix design (Long)
Annon -
9 Dec 2005 11:52 PM - 7 messages
Hi All, Not sure if this is the right group so feel free to point me in a better direction. Most of our customers have a personal price for every product but Im having a nightmare trying to produce a price matrix on the fly. I currently have a ...
Comparing Queries via Graphical Query Execution Plan
Jeff -
9 Dec 2005 11:37 PM - 5 messages
Using SQL Server 2000 / QA: Using BOL and a couple of other sources I have been learning about the graphical query execution plans available in QA. I understand in general what the graphical plans show, what some of the common icons represetn, and ...
is recordset open?
Les Stockton -
9 Dec 2005 11:37 PM - 2 messages
Someone told me how to do this before, but I can't seem to find it. I've got an ADO recordset. What attribute do I check to see if the recordset is open or not? ...
Using SubString With a Select Statement
RitaG -
9 Dec 2005 11:26 PM - 7 messages
Hello, I've been battling with an issue for some time now and can't come up with a solution. I have a table (FSStacks) with just 1 column (FSStack VarChar(25)). The values of FSStack could be e.g. "ABCD", "EFGH:IJKL" ...
New version of Books Online and new/updated samples available for download
Gail Erickson [MS] -
9 Dec 2005 11:11 PM - 1 message
Hi, An updated version of SQL Server 2005 Books Online is available for download from the following location: [link] The download contains over 200 new topics and more than 600 updated topics ...
select from mulitple databases and join
Paola -
9 Dec 2005 10:47 PM - 6 messages
Hello, Im a beginner and need assistance to select from two databases with a join. db 1 is docs db 2 is cd the below query works if i drop the 2nd select value but i want this 2nd value and join the databases by docname. ...
How Do I connect to a Mobile SQL DB from VB2005 - Windows App
Dave_C -
9 Dec 2005 10:30 PM - 1 message
I have both used the Data Connection Wizard and tried programatically to connect to a Mobile SQL Database from within a Windows Application and keep on getting the same Error at the connection point "Unspecified error [ sqlcese30.sys.dll ]" The Debug message is ...
Finding out if a table has changed?
Simon Harris -
9 Dec 2005 9:53 PM - 5 messages
Hi All, Is there any way to check if a tables data has changed, without checking the number of records and there values? I'm thinking perhaps some sort of server assigned serial number that changes when the data changes, or perhaps simpler a 'last updated' date for the ...
Removing "special characters" from VarChar
Mike Austin -
9 Dec 2005 9:51 PM - 2 messages
My tables are being sent data from SPSS via SAS. It appears that one of these products is adding character(s) to my varchar columns. The character looks like a square. If I query the table in DB Artisan, the column looks like line ...
Limiting the amount of data used between two tables
seamlyne -
9 Dec 2005 9:18 PM - 3 messages
Two tables: People and TestValues People ------------------------------ Name varchar(50) TestValues ------------------------------ TestString varchar(10) Insert into People (Name) values ('William') Insert into People (Name) values ('Blake') Insert into People (Name) values ('Kevin') Insert into People (Name) values ('Merry') ...
How to configure the server notification in SQL 2005.
=== Steve L === -
9 Dec 2005 9:17 PM - 8 messages
I couldn't find anything in the book online or tutorial addressing this question. Does anyone know how and what version of Outlook should be used? Thank you! ...
Converting table date
Jim Abel -
9 Dec 2005 7:52 PM - 2 messages
I am trying to to take data from a table where the Row data contains 24 columns representing hors 12 midnight to 11 PM see (sample below) into a table that puts 1 hour per row? Initial table Name Date 12Min 1Min 2Min 3Min … 11Min ...
IF Statement Syntax
Sherwood -
9 Dec 2005 7:41 PM - 5 messages
Greetings, I am having problems with the IF statement below and was wondering what I am doing wrong? Can you not assign the results of an IF statement to a variable? I am getting a syntax error when I try and run this code. ...
Windows Authentication vs SA Password
BCS -
9 Dec 2005 7:08 PM - 2 messages
I'm using SQL Server 2005 Express Edition for the first time for a Timeclock application I've written in VB6. SQL and the application itself will be installed on a standalone at a remote retail location for use by about a ...
Query Analyzer usage
=== Steve L === -
9 Dec 2005 6:58 PM - 3 messages
In SQL 2000, one can quickly generate the code for a table or stored procedure script by high lighting a table or a stored procedure (ctrl + c), then switch to a blank page in Query Analyzer (or any text ...
Error number table?
mikeb -
9 Dec 2005 6:56 PM - 4 messages
Where can I find a list of the error numbers, and their descriptions, that might be received through @@Error? ...
Pass a "Begin...End" Block from ASP
creed1 -
9 Dec 2005 6:48 PM - 2 messages
Is it okay to pass a Begin...End block to Sql Server from an ASP web page? I have a situation where one of my tables contains the column names that I need to select from another table. I have always used two separate select ...
appending a temporary table to another temporary table
Mitch -
9 Dec 2005 5:31 PM - 3 messages
I need to append one table to another. The fields/columns headings are identical in both tables. How do I append one to the other using SQL (in Query Analyzer)? ...
COUNT (DISTINCT (myfield)) PROBLEM
Savas Ates -
9 Dec 2005 5:08 PM - 10 messages
it works well SELECT DISTINCT ([cinsiyet]) FROM URUNLER WHERE cinsiyet<>'Bileklik' AND cinsiyet<>'Yuzuk' AND cinsiyet<>'Set' AND cinsiyet<> 'Kupe' AND cinsiyet<>'Bilezik' AND cinsiyet<> 'Kolye'; ...
Restore database error
ninel g via SQLMonster.com -
9 Dec 2005 4:48 PM - 2 messages
I'm trying to restore a database and am getting the following error: "MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file. Could not adjust the space allocation for file 'MyFile_Log'. RESTORE database is terminating ...
Replace List
Eric D. -
9 Dec 2005 4:48 PM - 2 messages
Hi, I was wondering if SQL Server had a function similar to the ReplaceList() function in ColdFusion. If you don't know anything about ColdFusion, I'll explain what I need. I have a field that I need to verify for "bad" characters from a list and ...
TRANSFORME_R$6,00_EMR$6.000.000_EM_POUQUISS=CDMO_TEMPO!!!!!
taca -
9 Dec 2005 4:42 PM - 1 message
Método aprovado pela revista EXAME TRANFORME R$6,00 EM R$6.000,00 EM POUQUÍSSIMO TEMPO Método aprovado pela revista exame!! Leia o texto com atenção; funciona mesmo! É só seguir as instruções abaixo Eu não ...
SQL Server & MySQL from VB6
Les Stockton -
9 Dec 2005 4:39 PM - 4 messages
Are there any VB6 code out there that show how to access SQLServer and MySQL? I'm told to use SQL commands rather than SQLDMO so that it'll be generic and not tied to one database. Does anyone have code for this? ...
Realtive query cost in the execution plan
mEmENT0m0RI -
9 Dec 2005 4:21 PM - 4 messages
Hello everyone! I have a general question about measuring query cost while tuning queries. If I put both queries (the old one and the modified one) into the same batch, can I then use the query cost (relative to the batch) ...
Multi-language support question
Eric Margheim -
9 Dec 2005 4:19 PM - 2 messages
We have an MFC application that uses ADO, ATL components to communicate with a SQL Server 2000 database. Our application is currently English only and we are making the conversion to support multiple languages. The text in the application is read in from ...
Decimal data type
fniles -
9 Dec 2005 3:58 PM - 5 messages
If I create a column with data type Decimal(10,4), when a data is being stored in that column, will it format the data to be Decimal(10,4) ? For example: if I enter 1.5, will it be 1.5000, or it will stay as 1.5 ? ...
smalldatetime,varchar and CASE
James Carters -
9 Dec 2005 3:43 PM - 3 messages
Have a table with an end_date column (smalldatetime) where a NULL shows that the row is still active. I need to be able to show the status (when it closed, or present) so tried this and variations end_date = CASE WHEN CAST(jv.[end_date] AS varchar)IS NULL THEN ' present ' ...
Database Naming
Nancy Lytle -
9 Dec 2005 2:56 PM - 4 messages
am doing some testing on a database created by the programming dept of the company, they named the database '123v10'. When I run some queries (mostly admin stuff, checking the fragmentation, space used by the data and log files, etc) in the Query Analyzer, I often ...
Parsing spaces
Ryan D -
9 Dec 2005 2:50 PM - 8 messages
How do I parse out words from a field? Specifically I have a field which contains the full name of someone: first, middle, and initial. These words are all separated by spaces like so: John Abraham Adams How do I get just the first name "John" in a separate field and then get ...
Verfy file path from SQL 2k
Ben -
9 Dec 2005 2:37 PM - 2 messages
Hi We have a number of documents references in our SQL Database and i would like to occasionally run a script directly from Query Analyser to identify missing documents. The database holds the UNC Path \\servername\sharename\document.doc Is this possible? ...
Finding and updating all rows with the same value in a column
Olav -
9 Dec 2005 2:35 PM - 2 messages
This integer column should be unique, så prior to altering it to unique i need to traverse all rows and update the rows with the same value. This table has another colun which is the primary key and when 2 rows has the same value ...
Another Way to Write this Query
Mike Collins -
9 Dec 2005 2:06 PM - 5 messages
In the following query, I will be making 6 joins for each ID in the Problems table to get a person's full name from our personnel table. Is there another way to do this than with the query I have below? ...
Naming a database
Nancy Lytle -
9 Dec 2005 1:55 PM - 3 messages
I am doing some testing on a database created by the programming dept of the company, they named the database '123v10'. When I run some queries (mostly admin stuff, checking the fragmentation, space used by the data and log files, etc) in the Query Analyzer, I often ...
The command(s) completed successfully. - Can i turn this output off?
Immy -
9 Dec 2005 1:51 PM - 12 messages
Hi all, can i turn off the "The command(s) completed successfully." message that is returned after a proc is executed that returns no data? Thanks mmy ...
preparing monthly report
Renjith Chembakarayil -
9 Dec 2005 12:08 PM - 7 messages
hi ... i need a bit of help here .... ive the foll.. tables FIN_Transactions - TransactGID - TransactTime - PayModeFID - Amt FIN_PayMode - PayModeGID - PayMode ...
"Simple" query help
Magnus Blomberg -
9 Dec 2005 11:16 AM - 2 messages
Hello! I would like some help to figure out how to write a specific update query. What I'm trying to do: I have one table with these columns: no (primary key or clustered?) object (primary key or clustered?) cid ...
A floating point exception occurred in the user process.
Niall -
9 Dec 2005 10:07 AM - 1 message
I have a sql 200 database with sp 4 on two machines. I continuosly get this error: A floating point exception occurred in the user process. Current transaction is canceled. when comparing fields of type real in a where clause. I only get this issue ...
Delete duplicate entry
Manish Sukhija -
9 Dec 2005 9:39 AM - 2 messages
Hi guys, How can we delete duplicate entries in a table. please send me a query which delete duplicate entry from table. ...
Reposted - Troubles setting variables
Daren Hawes -
9 Dec 2005 9:31 AM - 1 message
Yes. I need to set some variables from other queries in my SP that will be used in the final Select statement. This is the only one I need returned. I have modified the script as per other posts, but it still brings back 3 ...
Reposted - Troubles setting variables
Daren Hawes -
9 Dec 2005 9:31 AM - 2 messages
Yes. I need to set some variables from other queries in my SP that will be used in the final Select statement. This is the only one I need returned. I have modified the script as per other posts, but it still brings back 3 ...
Parameter=FCbergabe
Tom Klapettek -
9 Dec 2005 9:31 AM - 1 message
Hallo zusammen, habe eine Frage zu Parameterübergabe an eine StoredProcedure. Habe nachfolgendes gefunden, welches auch sehr gut funzt. CREATE PROCEDURE SP_FlatFileEinlesen @Tabellenname varchar(20), @Filename varchar(20) @Zeile varchar(20) ...
How to increase no of level of Direct Recursive Triggers?
Direct Recursive Trigger -
9 Dec 2005 9:26 AM - 2 messages
Table "ParentChild" saves data in following way ItemId ItemName ParentId RelationId ------- ------------- ---------- -------------- 1 Universe Null ...
Multilingual database design
carolus -
9 Dec 2005 8:53 AM - 4 messages
Does someone know anything about best practices designing multilingual databases? Please comment on each of the following design practices for multilingual database design. Which solution do you recommend? 1. One column per string in a certain language in each table. "Create ...
Deutsches Zahlenformat
tklapettek -
9 Dec 2005 8:33 AM - 1 message
Hallo zusammen, bin bez. SQL Server 2000 ein Newbie *grins*. Habe aber folgendes Problem: Die Settings des SQL-Servers sind auf Englisch gestellt. Die Windows Server 2003 Version ist auch Englisch. Meine Arbeitsstation ist auf Deutsche Sprache eingestellt. Nun erhalte ich ein Flatfile mit deutschem Datumsformat und Beträgen ...
SELECT (left join)
Petar Popara -
9 Dec 2005 8:23 AM - 5 messages
Is there any difference between this: SELECT a.Something FROM table1 a LEFT JOIN table2 b ON a.ID_Account = b.ID_Account AND a.ID_Contract = b.ID_Contract WHERE a.ID_Contract = b.ID_Contract and SELECT a.Something FROM table1 a LEFT JOIN table2 b ON a.ID_Account = b.ID_Account ...
Passing entire SELECT and WHERE clause to a stored procedure
Ray -
9 Dec 2005 5:38 AM - 7 messages
I have an application that allows the user to select various fields to display and/or use as the search criteria to locate a record and I then build the entire SQL clause in code and execute the SQL clause from code. The ...
need help - SP to move data
MackS -
9 Dec 2005 5:12 AM - 2 messages
Hello I am trying to create a stored procedure to move a ROW from Table1 to Table based on a coditon. Eg. I want to transfer an item with ITEMNO = '001202' FROM currentstock TO old_stock table. I want to be able to pass the value for ITEMNO from my code which calls the ...
Primary key without clustered index
Reshma -
9 Dec 2005 3:43 AM - 5 messages
Hi Experts, Is it possible to create a primary key without Clustered index? If yes, where exactly would you use it? Regards Reshma ...
ERROR: "activex component can't create object: 'excel.application'"
Swim -
9 Dec 2005 1:54 AM - 2 messages
When I run a DTS, I get the following error. Error I get: "activex component can't create object: 'excel.application'" I was told not to load excel into sql server. Well, in any case, there should not be any need to load excel, it recognizes the excel component ...
Same query much slow in function, any idea?
davidw -
9 Dec 2005 12:35 AM - 6 messages
if I run this declare @c int,@y int select @c=10005143,@y=2005 insert @hit select id=startmm,hit=count(id) from memlog where (LoginXCentralMemID=@c or MemID=@c) and startyy=@y ...
Confusing question or should I address it some where else?
sqlster -
9 Dec 2005 12:29 AM - 4 messages
I posted a question here on 12/6/05 about importing data from .csv file and no one addressed it. Here is the link [link] ...
Iterate through a list of files with bcp
Terri -
8 Dec 2005 11:21 PM - 2 messages
I have a folder full of date-stamped files: 010101.txt, 010201.txt, 010301.txt, etc. I have a working bcp command that points to a specific file. declare @bcpCommand varchar(1000) select @bcpCommand = 'BCP "Import.dbo.NAV" in "d:\folder\010101.txt" -c -T -t, -S "SERVER1\SERVER1"' ...
time stamp magicaly updated when ever update event occures on a row
Daniel -
8 Dec 2005 11:12 PM - 5 messages
time stamp magicaly updated when ever update event occures on a row in sql server 2000 i have a table. when i do any update on the table, a field of the effected rows gets a new time stamp, there are no triggers on ...
convert flat file to native file format for bcp
mar -
8 Dec 2005 11:03 PM - 11 messages
Hello, We bulk insert terabytes of data in delimited flat files every day. I recently heard from our DBA that using bcp especially in native format would result in reduction in file size and much faster inserts. Since we transfer these files across the network, I think we would save a lot ...
cast inside check constraint???
sqlster -
8 Dec 2005 9:59 PM - 6 messages
I get an error when I try to do cast inside check constraint like the following: CREATE TABLE [dbo].[mytbl] ( [mytblid] [int] IDENTITY (1, 1) NOT NULL , [month] [int] NOT NULL , [year] [int] NULL ...
Return Status question....
tom d -
8 Dec 2005 9:41 PM - 2 messages
I have an EXEC like this and is part of the whole script: EXEC ('RESTORE LOG NETOX FROM DISK = ' + '''' + '\\10.81.60.2\D$\Des_LogShip\' + @logfiles + '''' + ' WITH DBO_ONLY, STANDBY = ' + '''' + 'D:\LogShip_Undo\undo_LOGNETOX.ldf' + '''') I want to know what the return status whether or not it execute ...
CONVERT Error Message
Sherwood -
8 Dec 2005 9:15 PM - 4 messages
Greetings, I have a "newbie" question in relation to dates. I am trying to append the year, month, and day to one another in order to create a new date. The SQL I am using is below. The error message I am receiving is "The conversion of a ...
Re: problem deleting large no. of records
dzapp -
8 Dec 2005 8:54 PM - 1 message
Any chance you could share your code for your dbo.WF_GetSyncStamp(@Date)
function. I am looking for a way to convert the syncstamp to a real
date format. Thanks!
--
dzapp
------------------------------------------------------------------------
Posted via [link]
------------------------------------------------------------------------ ...
Create View in a Select statement ?
Christian K -
8 Dec 2005 8:51 PM - 6 messages
Greetings all. I'm a complete SQL novice, and well, I'm not even using SQL, but I have a dBase control which utilizes SQL SELECT statements to pull a rowset from a .DBF table. I have a small table with a few fields, but for this query I only need ...
Passing back more than 1 output parameter to VBA code
Paddy -
8 Dec 2005 8:41 PM - 6 messages
I have a stored procedure which has 2 output parameters, namely @RecCnt and @RetCode. In the stored procedure, I am using the SET statements to pass the data back. I am calling the stored procedure from my VBA code. I use ...
condensing log files
Schoo -
8 Dec 2005 7:51 PM - 3 messages
I need to set up an automated way to condense log files in a database. I successfully got a "dbcc shrinkdatabase" command to run in TranSQL, but I was thinking that if I can create a stored proc that runs through all the ...
UNPIVOT two fields
cliffeh -
8 Dec 2005 7:51 PM - 5 messages
I have a table that looks like this: Customer | PartNumber | Jan | Jan$ | Feb | Feb$ | Mar | Mar$ ... The data in Jan, Feb, Mar... are the sales quantities for the month, and the data in Jan$, Feb$ and Mar$ are the sales dollars for the month. ...
Query Help: Counts & Sums
JDP@Work -
8 Dec 2005 7:50 PM - 6 messages
How do I get the individual awrv sums for each region_group, I'm real close but no cigar.... I've used coalesce as each record will only have one install_date based on the sale stage of 50, 75 or 90 ...
Why can't i use "AS" results in the WHERE clause?
R Reyes -
8 Dec 2005 7:33 PM - 6 messages
SELECT TBL_Invoice.InvoiceID, DATEDIFF(d, TBL_Invoice.InvoiceDateCreated, GETDATE()) AS DaysOld, FROM TBL_Invoice WHERE(TBL_Invoice.DaysOld>=50) If you look at this SQL statement I created a new "field" called DaysOld with the AS keyword. Why does this not allow me to put parameters in the ...
Using replimerg.exe from commandline
RSH -
8 Dec 2005 7:05 PM - 3 messages
Hi, I have been passing commandline information to replimerg.exe to initiate a pull merge synchronization from SQL express to a SQL Server. This works great over a network connection, but now we are trying to move to a HTTPS ...
Varchar limitation on 8000 problem in SQL Server 2000
Henrik Skak Pedersen -
8 Dec 2005 7:03 PM - 5 messages
Hi, I have a problem with varchar(8000) in my trigger. It is a big problem for me that the X and Y variables below are limited by 8000 characters, how can I make them larger? I can illustrate it like this: ...
Instances list on remote IP
christof -
8 Dec 2005 6:11 PM - 2 messages
Is there a way to get all the SQL Server instances with SQL SMO from a remote computer? I got few instances on some remote IP and how to list them, how to pass to the function this address - could it be ...
Changing the Sender in XP_Sendmail
anthonysjo -
8 Dec 2005 6:10 PM - 4 messages
Is is possible to change the sender when using XP_Sendmail? I am sending a notification that reports are available in reporting services in a single email and want to change the sender from SQLSERVICEADMIN to something users will recgonize easily. ...
Remote Connection Fails with Web Service
alaytin -
8 Dec 2005 5:35 PM - 2 messages
Hello- I am having a problem with a Web Service written in Visual Studio 2005. I have a typed dataset that I created using the Visual Studio 2005 Data Source tool. This retrieves its data from a SQL Server 2000 ...
Disappearing data (happens rarely)
Darren Mart via SQLMonster.com -
8 Dec 2005 5:22 PM - 13 messages
Hello all. I know most of you won't believe this problem, but I've seen it with my own eyes: For our year-end processes we establish four tables in our SQL database and populate them. Two of the tables have millions of records, the other two only ...
Order by Clause
Manny Chohan -
8 Dec 2005 5:16 PM - 9 messages
Hi, I have column with values January, February and so on. I need to perform sort based on months instead the system sorts it by Alphabetical Order. Any Hint? Thanks Manny ...
clustered vs non-clustered performance
Panos Stavroulis. -
8 Dec 2005 5:10 PM - 3 messages
Hi, In a previous post I've asked a question which in the end boiled down to the differences between clustered & non-clustered indexes. I am not using clustered indexes in general but people here suggested that I ...
Searching For text in a self join
Ben -
8 Dec 2005 5:06 PM - 3 messages
Hi I have these tables: Document Table DocumentID PK ....... List Table ID PK DocumentID FK Customer Notes For each Document Table record there can be up to 6 List Table records. Return List Records where for each instance of a Document one List.Notes ...
Insert or Update Row if Primary key isn't pre-existing in table SQL 2000
Colin -
8 Dec 2005 4:49 PM - 4 messages
I'm trying to extract data from our Accounting Database and use it in another database that's used for our web site. Last month I created a SQL Select Query to give me the product information I need to put into our web ...
Year To Date?
Dan -
8 Dec 2005 4:46 PM - 20 messages
Hi, I am using a query tool that only allows me to define "custom sql" in the WHERE clause. I want to specify that sales_date be between the first of the year and last day of the most recent full month. The query ...
SQL Server - Lock timeouts performance problem
Steve -
8 Dec 2005 4:36 PM - 2 messages
Hi, We occasionaly have performance problems on our SQL 2000 SP4 db, during these times we see CPU use shoot up, along with lock timeouts (upto 1000's) in perfmon. We suspect that the lock timeouts are the main problem, which then causes ...
Need a way to automate Grant permission
rvgrahamsevatenein -
8 Dec 2005 4:26 PM - 4 messages
I have a front-end app in a small, closed domain where the users create tables owned by dbo through a stored procedure that calls sp_executesql aginst a second stored procedure. I had hoped that I could put a Grant ...
trying to do some weird math in an update statement
jason -
8 Dec 2005 3:32 PM - 9 messages
hello everyone, this was so oddball, i didn't even try looking for it in the groups, because i wouldn't know what to search for. here's what i'm trying to do (abstractly - this is not a real table, what i'm curiosu about is ...
sql server bug?
Panos Stavroulis. -
8 Dec 2005 3:16 PM - 7 messages
Hi, Check out the following statement... select * from master_client where gid not in (select gid from review_allocation) This statement doesn't return any rows back and I was surprised! However, the problem is that the column Gid does not exist in table ...
XOR and foreign key constraints
alexis rzewski -
8 Dec 2005 3:10 PM - 13 messages
I have a situation where attending a meeting could be either staff or coalition members. But don't know how to enforce a foreign key constraint. any ideas ? Table Meeting MeetingID int NOT NULL, AttendeeID int NOT NULL ...
Like operator returns unexpected records
John Tootle -
8 Dec 2005 2:59 PM - 7 messages
The select statement references the field CdeDiag1 which is an nvarchar(255) datatype. Simplified it looks like this: Select Distinct RecipBaseID, CdeDiag1 from Table Where CdeDiag1 Like '368%' Or CdeDiag1 Like '378%' What I'm trying to get is all diagnostic codes that begin with '368' or ...
Why Can't I Paste in Access Frontend
John Lane -
8 Dec 2005 1:43 PM - 4 messages
Anyone got any idea why i can't copy and paste a record either in a form or datasheet when the table is in SQL Server? The Paste commands are also greyed out on the Edit menu drop down. They get greyed out after I do the the Menu ...
To get information about table
Manish Sukhija -
8 Dec 2005 1:06 PM - 10 messages
Hi Guys, Is there any way by which we can find out very recent deleted or inserted entry, but it should work for whole database not for a specific ...
|
|||||||||||||||||||||||