|
|
|
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 |
Select Expression Operators Posted by Gary K at 8/30/2004 10:49:06 PM Sorry for what must seem like a dumb question, but I was wondering why I keep
getting "<operator> not recognized" errors when I try to use the following
sql clause:
SELECT personid, IIF(LEN(ISNULL(middlename, '')) = 0, firstname + ' ' +
lastname, firstname + ' ' + middlename + ' ' + lastnam...more >>
Only get dates Posted by Gary K at 8/26/2004 10:19:04 PM Can anyone help me create an expression for a column in a query that holds
only the date portion of a smalldatetime column? I've tried DatePart and had
a look around for other functions but I couldn't find anything. Thanks in
advance,...more >>
IIS Logs Max Per Hour Posted by Simon Jelinek at 8/26/2004 8:13:51 AM Hi
Being very new to SQL so iam hoping that this will be
easy.
Using a dts package to transfer IIS logs into a SQL
database i would now like to knpw of there is any
resource that gives some idea on the best stats to take
from IIS Logs.
i have create a query that is a count of [c-ip]...more >>
Sql Server Reporting Services Download Posted by Connie Ulehla at 8/25/2004 2:56:10 PM We have a legal copy of Sql Server and want to use Sql
Reporting Services. Where can we download a real copy
not a test or time-limited one?
Thanks....more >>
SQL Question Posted by anonymous NO[at]SPAM discussions.microsoft.com at 8/23/2004 8:09:47 AM Hi, everyone:
I was trying to create a tempory table and then join it
with other existing tables to do some query.
I know in DB2 SQL you can do the following:
WITH temp (var1 var2) as
(
select field1, field2
from table1
)
select
tb1.field2,
tb2.var2
from
temp as tb1,
table...more >>
anyone can give solution for this problem Posted by Nilesh Barbhaya at 8/21/2004 2:01:18 AM 2004-08-21 11:52:38.64 spid52 Error: 0, Severity: 19,
State: 0
2004-08-21 11:52:38.64 spid52 language_exec: Process 52
generated an access violation. SQL Server is terminating
this process..
2004-08-21 11:56:12.93 spid52 Using 'sqlimage.dll'
version '4.0.5'
Stack Dump being sent ...more >>
Null values Posted by Loretta at 8/17/2004 3:24:44 PM How can I replace null value of a column in a query
with something like 'TEST'
for eg. if I run the query
select contract_num, prodid from product
if the contract_num is null, it should return 'TEST'
instead of NULL. how can I do so?
Thank you,
-Loretta...more >>
Sequence Posted by Mike at 8/17/2004 2:38:27 PM I need to create sequence numbers for a column in a table,
I wanted to find out how can I create it?
I have a column, depending if the file type ='A'
the fileNumber should be 'A001'
The next record could have the file type='B', in this
case the filenumber should be 'B001',
if the next file ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help on SQL Syantax Posted by Annette at 8/16/2004 11:30:17 PM Dear Anyone,
I am no expert with SQL server but I am trying obtain
some data from this server using SQL syntax, I would like
to average out the data by correction_col_date below, can
anyone help please!
SELECT SAMPLE.PRODUCT_VERSION, PRODUCT.DESCRIPTION,
SAMPLE.PRODUCT, SAMPLE.PRODUCT_...more >>
finding records using a Date expresion Posted by Bob at 8/16/2004 10:59:24 AM how do I find all records that were created before
today minus 150 days. I could easily do this in MsAccess
by doing the following
by filtering off of the Date created field using the
expresion of <Now ()-150...more >>
Order By - Conditional Posted by Wes at 8/13/2004 5:04:53 AM I wish to include a condition in my order by statement.
i.e. If the value of Field X > Y then Order by Field X,
else Order by Field Z.
I have tried inserting a select case but i cannot get it
to work
Here is an extract from the table
Order_ID Status Name
50 10 Michael
5...more >>
Query Posted by Kim at 8/12/2004 11:56:32 AM I have duplicate records in a table based on say
OrderNum, I would like to copy 1st record for each
OrderNum from this table into a new table and then update
the OrderNum record in the 2nd table with values from
rest of the records in the 1st table, can someone help me
in doing this?
Ex.
...more >>
Date Format Posted by Ibrahim Awwad at 8/12/2004 3:03:02 AM Dear All,,
Date is entered on the table on the format of dd/mm/yyyy. When I see the
table I can see it in correct order ddmmyyyy. In the Query Analyzer, I see it
yyyymmdd. In addition the more seriouse proble is that when I right a
statement to choose an exact date or date interval, I have ...more >>
filtering groups Posted by novice at 8/11/2004 9:19:55 AM I need to write a query that will return the most recent
incident within a related group, but I want a value
returned for each instance of that group even if there's
only one event recorded for them.
Ex: The last transaction made by each buyer regardless of
how many transactions they hav...more >>
Update query analyzer grid results? Posted by Bruce H at 8/10/2004 10:40:21 AM Is it possible to do updates to a grid result from the
query analyzer?
i.e. select * from ABCD gives a grid result (w/ PK cols),
can I edit one or more fields in the gride and update ?
The help files seem to indicate that it is possible
("Rules for Updating Results"), but I seem to be m...more >>
Sorting information using query analyser Posted by Chris Scott at 8/10/2004 8:43:02 AM Hi all,
I am trying to sort a really large file of information
and I need some help as I cant work out how to get some
of it.
the fields I have are:
csbytes
cscookie
csuriquery
I need to program to get:
A list of the distinct values in cs bytes ( got have done
this one using: SELECT D...more >>
Restore runs longer in batch mode Posted by cbriscoejr at 8/6/2004 7:27:03 AM I have created a Job that uses "cmcexec" to execute a SQL script. This Job
brings SQL to single_user mode then restores from a directory that is local
to the server.
1) When I run this restore in the GUI it takes 15 minutes but is still
executing
(1 + hours).
2) How can I tell that it ...more >>
Date calculation Posted by Bob at 8/3/2004 10:37:13 AM Im relatively new with sql and im having a problem
creating a criteria based on todays date less 150 days.
I tried to use the following...
< GetDate () -150 however it will not let me use this.
I know that there must be away to do this, but I need
help.. Thank you in advance...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |