|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Import / Ordering / Script File Posted by Rob Meade at 12/30/2004 9:41:35 PM Hi all,
I've been having problems with an over night job since the 20/21st December,
basically the import had been failing because of a problem with a view.
Turns out that SQL Server wasn't able to determine which views should be
created first, ie, which are dependant on other views - as a r...more >>
Saving Attachments using XP_Readmail Posted by Brent C at 12/30/2004 9:33:03 PM Hello,
I am trying to run the XP_READMAIL Procedure with the intention of saving
the attachments of the emails to the Temp Directory, the process runs ok,
however I cannot find the attachments it has saved. I have looked in the
Temp folder, but they are not there, I have even searched the ...more >>
BULK INSERT Posted by Mike Labosh at 12/30/2004 8:20:50 PM I need to import a delimited txt file.
All values have double-quotes around them and are delimited with tabs as in:
"value"[Tab]"value"[Tab]"value"[etc][CRLF]
Here's what I have so far in my stored procedure, and I'm having trouble
phrasing the BULK INSERT to handle the quotes:
SET @sql...more >>
SQL Server Instance Posted by Leila at 12/30/2004 6:22:23 PM Hi,
How can I determine that if user has installed SQL Server or MSDE on his
machine before starting the installation of my app.
Thanks in advance,
Leila
...more >>
ITS FASTER, I JUST DONT UNDERSTAND WHY Posted by Rex at 12/30/2004 5:48:16 PM I have a clean up project to delete a hundred million rows (from a table of
300 million) that are stale.
These rows are children of about 500 parent rows in another table.
If I do this:
/**BEGIN EXAMPLE 1 SLOW**/
set ROWCOUNT 50000 -- So I don't blow up the log
declare @int int
select @...more >>
Operation is not allowed when the object is closed Posted by Conax at 12/30/2004 4:46:22 PM Hello!
Error Message: "Operation is not allowed when the object is closed."
What I have is a stored procedure on SQL server that goes and checks data on
a table and populates a temporary table (declared within the stored
procedure) with record ID and description of invalid records. At the en...more >>
Can this actually be done? Posted by Rob Meade at 12/30/2004 4:15:18 PM Hi all,
I've spent all day now looking into these Linked Servers, and I'm completely
bu**ered if I can see anyway of creating a view in one of my databases on
one server to get data from a table in the other server...
I've tried all sorts of combinations, I've tried it on different servers...more >>
select from a storeprocedure Posted by Carlo at 12/30/2004 4:09:27 PM hi i need to
SELECT id
FROM my_store_procedure
how can i do??
carlo
thanks...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
to bit or not to bit thread -- where located ? Posted by John A Grandy at 12/30/2004 3:04:01 PM did someone move the thread "to bit or not to bit" to another newsgroup ?
...more >>
Self-referencing query? Posted by Willie Bodger at 12/30/2004 3:01:18 PM If I have a table of customer products (let's say product A is a trial and
Product B is a full version), how would I write a query that would pull
perhaps everybody that has Product A and not Product B or both A & B etc.?
I'm sure this is a simple logic that I'm just having trouble getting a g...more >>
need help on error msg Posted by TJS at 12/30/2004 2:53:34 PM need help resolving this concatenation error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the
varchar value '41670 test' to a column of data type int.
for
strSQL = "SELECT categorycode AS Category , PostC...more >>
condensing a range of numbers Posted by sg at 12/30/2004 2:50:50 PM Could somebody point me towards some example cursor code that takes a list
of numbers:
1, 2, 3, 5, 7, 8, 9
and formats it into a range of numbers:
1-3, 5, 7-9
Thanks. My initial attempt is below. It's close, but not quite.
declare @seat_str varchar(4000)
select @seat_str = ''
...more >>
Cursor Fails After First Successful Run Posted by Garibaldi at 12/30/2004 2:04:21 PM The first time the following script runs, it successfully
updates permissions.
Even if I change the database, the script fails the
second and each time thereafter. I need to close the
scipt and reload it into query analyzer for it to run.
What am I doing wrong here? Or, am I missing some...more >>
Novice: retrieving message headers Posted by Malcolm Miles at 12/30/2004 1:49:47 PM
A question from a SQL novice. I have a database that contains 10,000 or so
message headers. Database fields are:
msg_id
msg_date
msg_subject
msg_body
I want to retrieve a message using its msg_id and then display a link to
the next and previous messages in date order.
Obviously I ca...more >>
Sub Query Posted by DaveF at 12/30/2004 1:42:06 PM Don't blame me for this table. I am just trying to code on it.
The Table has 5 fields in it. I have an resultid, questionID,
OptionTextboxValue, SurveyResultID, OptionID
The table hold 3 question results from a form. FirstName, email and the
third question has an optionID of 1566 or 1577. 15...more >>
Query Analyzer / Default Database Posted by Mike Labosh at 12/30/2004 12:45:02 PM Every time I startup Query Analyzer and connect a session to the database
server, it always by default connects to a certain database. I would like
it to, by default, connect to a different database, but I can't find
anything in the options dialog for this.
Where else should I be looking?
...more >>
Query in Infinite loop? Posted by tarheels4025 at 12/30/2004 12:25:04 PM Here is my query and it is taking forver to run. Is it in an infinate loop
or no? Thanks for an answers.
Use WinPayment
GO
SELECT
pos_condition_code,
convert(char(11), retrieval_reference_number) RR,
message_type,
authorization_identification,
convert(char(8), card...more >>
Array Question Posted by Jm at 12/30/2004 12:15:41 PM Hi all
Im sure there is an easy way to do this but im not quite sure what to do. I
have a stored procedure that up until now would recieve a no fixed length
string that contained id numbers of 3 characters and a # symbol to signify
the end of the number. Now these id's are always 3 numbers lon...more >>
Data from two different databases Posted by John Baima at 12/30/2004 12:11:50 PM I'd like to do a select like:
select emp_email from company1.tblEmp e
where not (e.emp_email in (select emp_email from company2.tblEmp))
company1 and company2 are different databases in the same SQL Server.
Can this be done? Thanks.
-John
...more >>
Sql Server Performance Question Posted by Jm at 12/30/2004 12:00:59 PM Hi all
Im just wondering which approach is quicker for sql server to process from a
stored procedure with this data. Say i have a two column table, first column
is machinename, second column is appid. Is it quicker for sql to proccess a
select statement if i have a seperate row for each machin...more >>
BCP question - any way to have a comma delimited, quoted columns? Posted by Eric at 12/30/2004 11:34:22 AM I need a CSV output file with the columns themselves surrounded by quotes.
I've tried -c -t"," which gives me the commas, but have not yet found a
combo that gives me quoted values as well.
I also tried -c -t""" which gives me quotes but not commas except at the
beginning, and -c -t"","" didnt w...more >>
create database in VBScript Posted by merre at 12/30/2004 11:21:02 AM Hi!
Is it possible to create an database in SQL Server generated in VBScript??
Kind Regards
Mehran...more >>
Converting NULLS to Zeros Posted by Chris at 12/30/2004 11:19:10 AM Hello,
Is there a function to convert NULL values to zeros so that they can be used
in arithmetic calculations?
Any help is appreciated for this newbie.
Thank you!
Chris...more >>
Problem with DMO.Index Type Property Posted by Martin Schmeller at 12/30/2004 11:10:16 AM Hi everybody!
I get the error "Invalid Index Type" when I try to set the Type Property of
the DMO Index-Object:
When I copy a table, I also want to copy over all the indexes.
I iterate over original table's Index collection, grab each index and try to
re-create it in the new table. I skip ind...more >>
Need some assistant with tough query please. Posted by Lam Nguyen at 12/30/2004 11:03:05 AM
How can I get the result show below. The rules also showing below. Any
help would
greatly appreciate. Thank you in advance.
IF OBJECT_ID('Tempdb.dbo.#Prospect', 'u') IS NOT NULL
DROP TABLE #Prospect
GO
CREATE TABLE #Prospect
(
Person_id INT NULL,
MFPolicy_nb INT NU...more >>
order by problem Posted by zapov at 12/30/2004 10:57:02 AM Hi
I want to read data from table sorted by int data type
But, value can also be null, so when I try to
read it sorted ASC, a get nulls first, and I want them
to be last
I searched on the net a little, but came out emptyhanded.
How should I write these query properly
SELECT * FROM Tabla O...more >>
Partioned views /update/insert issue Posted by Abraham at 12/30/2004 10:43:04 AM I have a partioned view called members.
Partined based on status of the members.
Tables : members_11 ( check status=1)
members_22 (check status>1)
primary key ( memberid , status)
View: members -- create view members as select * from members_11 union all
select * from members_22
Th...more >>
adDate parameter to stored proc. Posted by Agoston Bejo at 12/30/2004 10:01:39 AM Hi!
I am trying to pass a VBScript Date variable as value to an ADO adDate
parameter of a stored procedure (which runs in an SQL Server).
If I add the parameter like this:
oCmd.Parameters.Append oCmd.CreateParameter( "@p_Date", adDate,
adParamInput, , dParam)
where oCmd is of type ADODB.Co...more >>
Trigger -> Create Database Posted by Preston at 12/30/2004 9:33:09 AM Is there any way to get around the prohibition of 'create database'
statements in triggers? What I'd like to do, ideally, is have an insert
trigger that fires and creates a database and then populates it with tables
from a template db, i.e.
create trigger blah after insert as
create datab...more >>
Linked Servers? Posted by Rob Meade at 12/30/2004 9:18:22 AM Hi there,
Hope everyone had a good Christmas :o)
So, linked servers....here's the problem...
We have 2 SQL Server 2000 (running Enterprise Edition) in a SQL cluster -
this is known as AvonSQL.
Recently this has become over loaded, so we bought another server to run as
a seperate SQL ...more >>
DTS import duplicate records staging table Posted by AshleyT at 12/30/2004 8:25:06 AM I currently have a process where I get zip files with dbase tables. I then
take the dbase tables and import them into a staging table. The issue is
that the process to create the zip files can easily create duplicate dbase
tables. Which then the dts process stops because it violates the pri...more >>
Error 213 Posted by Robert at 12/30/2004 8:05:04 AM Hi,
I am in a terrable mess! I would really appreciate a hand. I am in the
process of developing a program which has a number of stored procedures.
There is a main input date which i then 'hope' to pass through to the various
stored procedures. If i run it once it seems to work fine. If i t...more >>
Intermittent SQL Dump Exception... Posted by Robert Taylor at 12/30/2004 7:22:06 AM I have a batch job that runs daily but is intermitently failing. The
job seems to complete okay, but SQL catches an Exception during the
execution and marks the batch job as failed.
I've looked in the logs and found the following entry each time the
failure occurs. I have a SQL transaction l...more >>
REAL/DOUBLE PRECISION Posted by Justus at 12/30/2004 2:03:03 AM Hi
We had some problems with the precision of large incomes in a swiss social
security application
using SQL Server 2000.
So I did some tests:
SQL SERVER 2000 Float Precision
MS-Help says:
REAL: FLOAT(1) .. FLOAT(24)
4 - Byte Float with 7 - dig...more >>
Date conversion from Oracle to SQL Server Posted by zambetti NO[at]SPAM inwind.it at 12/30/2004 1:35:05 AM Hi all,
I have a problem with a conversion from some functions in Oracle to
SQL Server (T-SQL). The functions are:
to_char(time, 'dd-mm-yyyy hh:mi:ss'),
to_char(time, 'dd-mm-yyyy')
to_date(times, 'dd-mm-yyyy');
to_char(sysdate, 'dd/mm/yyyy hh24:mi:ss'));
where "time" and "times" are...more >>
Sql To Active Directory Quickie Posted by Jm at 12/30/2004 1:06:21 AM Hi all
Im not sure if this is possible, but im sure ill get the answer here. In SQL
Server is it possible to create a stored procedure that will take a username
supplied by you and check the active directory account for that user and
find what active directory groups the user is a member of, a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |