|
|
|
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 August 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 Linked server error--Pls help Posted by Mukut at 12/10/2006 9:23:10 PM Hi all,
This is a very urgent requirement in our project. We are trying to
import data from excel file to a table. we are getting the following
error msg:
Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0"
for linked server "(null)".
The query we have is as follows:
...more >>
Unhelpful error messages from IE7 Posted by C17 at 12/10/2006 9:22:49 PM Hi,
I am using reporting services within a VB .NET program; that is, the reports
are hosted within a browser window within the program.
With IE6, when my program incorrectly passed the report parameters to the
report server, or some other error occurred, I would get a useful error
messag...more >>
xp_readmail Posted by landers at 12/10/2006 9:21:05 PM Hi All,
I need to read emails and parse the body to search for specific text. I
have got SQL Server setup to read emails, but I am unsure of the TSQL
required.
Has anyone got an example of how to read unopened emails and find specific
text in the body?
Cheers,
L
...more >>
User defined function hanging but continues to work after a reindex Posted by jharalam NO[at]SPAM colesmyer.com.au at 12/10/2006 7:58:02 PM I have a User Defined Function (fn_LoadSellIdStdPrcTbl)
Which as part of its code executes the following:
INSERT INTO @tblSellIdStdPrc (sell_itm_id,
bus_rgn_zn_cd,
sell_prc_amt)
SELECT si.sell...more >>
MS SQL Query Question Posted by sty129 NO[at]SPAM gmail.com at 12/10/2006 6:39:43 PM I have a question to do, but I have no idea how can I solve it. Can
anyone help me? Thanks!
John is RND department. He want to view his surordinates having taken
leave between 1 Jan 2006 and 31 March 2006. The list should has the
following information:
Section, Staff no., Leave Type, No. ...more >>
Help Selecting Min Value Posted by Ron at 12/10/2006 3:02:00 PM I have a table AllMin:
SKU HPC Sysco BJ Sweet
515110 $13.82 $26.25
515115 $2.31 $3.28 $2.65 $2.99
516110 $0.50
516120 $1.89 $2.35
516140 $1.99 $2.09 $2.19
And I want ...more >>
Query for current SQL 2000 server date Posted by Mike Chung at 12/10/2006 11:19:00 AM Need help on a query within DTS job.
Trying to retrieve data from database based on the current server date. Any
suggestions on how I can query/retrieve using the server's date as a
condition?
Ex.
Select * from table1
where dateopen = ?
dateopen = field column
field entry = 10/01...more >>
import list to tempdb table and run and update using TSQL? Posted by hmchkus at 12/10/2006 6:39:32 AM
Hi,
I have a single column list of item that I want to import into tempdb
table. Which way is the simplest? don't want to use SISS(DTS).
Then I like to run a loop to compare each one of these items with a
table and delete some rows in an original table using TSQL
Is there an example tha...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Lock record for reading! Posted by SqlBeginner at 12/10/2006 5:26:00 AM Hi,
Is it possible to lock the record(s) to read by another user, while i am
reading the same record?
Regards
Pradeep
...more >>
Variables as Object names Posted by Mike DeYoung at 12/10/2006 4:35:00 AM Hi All,
My hair is growing thin on this...
Why do I get...
"Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ')'."
On this script...
**********************************************
declare @begin_date INT, @end_date INT, @dbasetable VARCHAR (30)
SET @begin_date...more >>
Internally convert 0 to No, 1 to Yes, then display the result Posted by User at 12/10/2006 2:10:17 AM Hi
Let's say there is a field which stores 0 and 1. It represents No and Yes.
Is it possible to convert them to "No" and "Yes" then display to user
instead of displaying "0" and "1"?
Although it can be done on the client program/client scriptings, I'm
thinking of putting more of the log...more >>
help with delete Posted by Chris at 12/10/2006 1:41:00 AM Hi,
I have 2 tables with some common columns. What's the fastest way to delete
data from table a if data from table a exists in table b where table b.status
='Y'
TABLE A
ID, PROD,QTY
TABLE B
ID, PROD,STATUS
Thanks...more >>
Conditional statement Posted by Niclas at 12/10/2006 1:20:28 AM
Hi,
Being new to SQL, I need to execute a select statement with a different
WHERE condition depending on a certain condition of a variable. Is it
possible to have conditions within a SELECT staments or do I need to
execute differet statements using IF BEGIN END ?
Niclas
*** Sent via ...more >>
allowing user interaction within transactions? Posted by xamman at 12/10/2006 12:35:31 AM in this scenario i would like to guarentee that at *the moment at of
purchase* i can offer the lowest price for precious metals to my
customers.
a table lowest_competitor_prices which is populated by a robot program
..
after leisurely browsing my goods, customer decides to buy & clicks on
ch...more >>
concatening strings in sql server Posted by Roy Goldhammer at 12/10/2006 12:00:00 AM Hello there
I have table of ID, ClientID, BusinessDescription
for example:
ID, ClientID, BusinessDescription
1 310648811 Computer Programmer
2 310648811 Computer Designer
3 310648874 Soldier.
I need to show it like this in fast way:
310648811 Computer Progr...more >>
Get result from a SP -> Combine with another select statement. Posted by User at 12/10/2006 12:00:00 AM Hi,
I have a SP which returns an Int.
I also have a Select statement.
Eg:
"Execute mystoredproc 123" returns an int. It will return
(xyz)
----
888
Next,
I have a Select Statement,
"select name, address, status from table1 where status=123"
The select statement will ret...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |