|
|
|
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 |
Blank field in column Posted by Bill at 6/30/2004 4:05:36 PM I am using the following query:
DELETE FROM ORDER_HEADER
WHERE (INVOICE_NUMBER IS NULL) OR (INVOICE_NUMBER = '0')
This works fine but doesn't remove the records where the
INVOICE_NUMBER field is blank.
Is there a way to identify a blank or empty field? ...more >>
DateTime Posted by Crazy Pete at 6/30/2004 2:03:56 PM PLZ help me!!!
i got to make a access frontend for a MSSQL server.
i need to select some stuff per week how can i make thet?? PLZZ HELP I GOT
TO KNOW IT TOMAROW
TNX
Peter
...more >>
Need some help A.S.A.P. Posted by Will at 6/30/2004 9:21:43 AM Hi Folks,
I'm having a bit of trouble updating my script. I have a
script used for MS Access and I need to transfer it to be
compatible with MS SQL Server. When I run the script it
gives the error
''ODBC driver does not support the requested
properties.''
This is the line of the scri...more >>
Error using QA Posted by Stefaan Dewulf at 6/30/2004 5:26:32 AM I keep getting the following error, but the sql is OK.
I found something about the problem on the support site
but did not find the hot fix.
Server: Msg 8624, Level 16, State 13, Line 1
Internal SQL Server error.
Please help,
Stefaan...more >>
BLOB Posted by John A. Curry at 6/29/2004 3:51:44 PM Hello,
I am looking into storing images into SQL and want to use BLOB which I
understand to be the best method. Can someone supply me with a simple
example of how to import a file into the database?
Thanks in advance,
John
...more >>
IIF in where clause to exclude selection criteri when null Posted by baz at 6/22/2004 5:47:31 PM Hi all,
I've got a huge Reprot in Crystal 8.5.
I've discovered that I can't work with the report if I
change the Stored Proc the report is based on. (this is
a kown and popular issue )
SO what I want to do in save the report under a different
name as attempt a more latteral approach ...more >>
Dealing with Nulls, - use previous record Posted by Kole at 6/22/2004 12:09:08 PM Do u know of a function that will return a field from the
previous record if the current record's field is null? I
know this is available in Monarch, but do not know how to
do it in SQL Server.
...more >>
Defining a concatenated column size Posted by Kirk at 6/18/2004 7:49:01 AM I have a column within a view that is a concatenation of several different columns of another table. It goes something like: tblA.columnA + '-' tblA.columnB + '-' tblA.columnC + '-' tblA.columnD As 'NewColumn'
Is it possible to define the size of the 'NewColumn' within the view? I have a store...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Using Stored Procedure returned fields in another Stored Proc or Query Posted by BGS at 6/17/2004 7:21:19 PM Hi all,
I've got a Join All stored proc which returns about
120,000 records.
It simpley returns Account number field and Balance field
for each acustomer ccount for each table.
I want to use the returned data as if it were just
another table or view. As in:
Select * from spGetAl...more >>
Conditional computing Posted by Eric Caron at 6/17/2004 3:19:54 PM Hi everyone,
I'm working on a report that gives a summary of data in a sql server
database. The structure of the database is the following:
A company has one to many investments. These investments are for a certain
sector, are of a certain nature and are in a certain state. This gives us ...more >>
using a variable for a @TO parameter in xp_stmp_sendmail Posted by schmidtk at 6/17/2004 10:40:01 AM I am using the following to send mail, but instead of
@TO = N'yyy@abc.ab.ca'
I want to specify a variable from my procedure:
@TO = N@emailaddress
where @emailaddress is populated during the procedure
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'xxx@a...more >>
Access Format Equivalent Posted by Bryan at 6/13/2004 1:40:11 PM Hello:
What would the equivalent syntax be to format the
following in SQL as can be done in Access.
Format("000000",employee) to return 012345 from 12345
...more >>
Finding tables referenced in a Stored Procedure Posted by Maria at 6/11/2004 6:23:13 AM Hello!
I'm in desperate need of some help. I am trying to
identify db objects that are no longer in use. i have a
list of sp's that are not being used, and i'm trying to
look in the body text of the sp (by querying the text
field in syscomments) to find references to tables and
views. t...more >>
Prevent insert duplicate record TRIGGER Posted by Andre Ranieri at 6/10/2004 3:16:02 PM
I'm hoping someone can help me refine a trigger which will prevent writing records to a table (dbo.JOB) if the field value of Inserted.InvoiceNo already exists in dbo.JOB.InvoiceNo.
The syntax checks out on the trigger but I'm still able to write duplicate records into the table. I've been wor...more >>
Changing 100 table object owner names at once Posted by Smith at 6/10/2004 3:06:19 PM Is there any way I can change the object owner for over
100 tables in a single data base at once in SQL 7 without
using the sp on each table?...more >>
Dynamic SQL and IN list - Thanks! Posted by Amelia at 6/9/2004 5:34:41 PM I am trying to get dynamic SQL working with an IN list and
can't find any answers in the SQL Server Help.
1)I can get a simple parameter working as below
declare @sSql nvarchar(500)
declare @sParameters nvarchar(500)
declare @sPremises varchar(10)
set @sSql = 'Select * from PREMISE wher...more >>
Query Help Posted by Joe Horton at 6/9/2004 8:57:54 AM Having a brain fart and I know this is simple but I've already wasted a
couple hours - so I was wondering if someone could help.
Example Source Table:
Id: Company: StatesCovered:
1 ABC WA
2 Car Toys IL
3 Car Toys ...more >>
SQL Replace Function for Strings Posted by Michael at 6/6/2004 2:16:02 AM Hi all
I have a colum with values likes this 2345:Text. The number behind the colon is always different. I want to remove the colon and the numbers behind the colon. Actually I would use the following statment: select *, replace (Colum1, '2345:','').
There seem to be no wildcards possible for the ...more >>
how do i create a view within a procedure that uses a variable defined in the procedure Posted by Nikhil at 6/5/2004 3:26:02 AM how do i create a view within a procedure that uses a variable defined in the procedur
regard
nikhil...more >>
How to query non mutiple rows in one cuolumn? Posted by new at 6/4/2004 11:24:53 AM I have one column name "pbulishID", I need retrun the row
only one publishID, not mutiple publishID.
Thanks all reply....more >>
Getting relationship data Posted by Anthony at 6/3/2004 3:01:10 AM H
I am trying to create a query or set of querys, which will allow me to retrieve the relationship data of a database. In sql Server 2000 the user can create diagrams which show these relationships, what i want to be able to do is get this data, but i am having trouble finding a starting place. ...more >>
Currency Format with Comma Delimination Posted by Dan at 6/1/2004 5:32:04 PM Is there a way to convert a field to Currency format with
a comma as a seperator.
ie
50000 would be $50,000
1234567 would be $1,234,567
etc.
I am just looking to do this via the SELECT statement.
Any suggestions would be helpful.
...more >>
linked server problems Posted by Matt Tapia at 6/1/2004 1:59:25 PM I do the following to link a server:
EXEC sp_addlinkedserver 'MainLinkedServer', 'SQLServer OLEDB Provider',
'SQLOLEDB', 'MATT', NULL, NULL, 'WEEK'
It says it links fine (no errors), but when I do a select on a table I know
exists
select distinct T1."Institution" c1 from 'MainLinkedServer...more >>
Purge old ROWS Posted by Rick at 6/1/2004 11:05:01 AM looking for a script that will purge rows that are 2
months old. I would like to run this as a Scheduled job..
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |