|
|
|
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 join help on single table Posted by Hassan at 5/14/2005 8:33:47 PM I have a table A with col1 and col2
Col1 Col2
2 A
3 A
4 A
4 C
2 B
2 C
For every distinct value in Col2, I would like to represent 'NA' and the
missing distinct value for values in Col1 that...more >>
permission for entrance of null data Posted by Frank Dulk at 5/14/2005 7:24:44 PM I have a table field with type of data varchar, without permission for
entrance of null data
Doubt:
If I don't type anything in the field, the validation of null values at
table level usually happens, however if I type some text and later to
exclude the text, the validation doesn't happen plu...more >>
How would that code be in SQL Server? Posted by Frank Dulk at 5/14/2005 6:50:31 PM How would that code be in SQL Server?
UPDATE BASE SET BASE.cpf = "0"+[cpf]
WHERE ((Len([cpf])="10"));
...more >>
problem with "subquery returned more than 1 value" Posted by The Gekkster via SQLMonster.com at 5/14/2005 5:37:28 PM Hi guys,
I'm getting an error of 'subquery returned more than 1 value' when I try to
run this, which I guess is because the @remoteID is being set to a SELECT
that returns multiple rows. How do I go about this so that I can accomplish
checking for all existing IDs on the local server (against ...more >>
Check all SPs from a script Posted by Just D. at 5/14/2005 1:50:42 PM It's known that the SQL Server doesn't check the SPs and views when we
modify the tables and if we try to use these old SPs after we applied any
modifications like column names to the tables we'll get very serious
problems.
Is it possible to check all SPs and View from one script, like open...more >>
backup Posted by js at 5/14/2005 11:02:07 AM Hi, I backup db log in every 2 hours during day, and a full backup at
midnight, when is the best time to shrink database log file? before full
backup or after?
...more >>
Retrieving data from multiple tables Posted by Gus Gustafson at 5/14/2005 10:29:15 AM In the database are two tables. One contains data that is pending some sort
of resolution; the other contains data that has been approved for further
use. Both tables contain the same attributes. When pending data is approved,
that tuple is moved to the approved table and removed from the pend...more >>
quick SELECT statement question Posted by Rudy at 5/14/2005 9:59:16 AM Hello all!
I have a date/time column on my table. How can I write a select statement
to pick only items from todays date? I looked, but can't find an answer.
SELECT * User FROM TABLE WHERE datecolumn = "todays date"
Thanks!
Rudy...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Counting result Posted by Kutlan at 5/14/2005 7:10:01 AM Hi Champs!
I have a tricky sql problem, and I would apreciate some help from you.
In my SELECT statement my result looks like this:
ID----name----city----number
1 ---- lfkjdfl---djdjjd---1212
2----- mdsf-- safta----1212
3-----jsert----agjyt----1212
4-----wqfh---jfgyiu----3434
5-----aghj-...more >>
update database I don't know its name till runtime Posted by Ahmed at 5/14/2005 2:31:09 AM Hi all,
I want to insert a row in a table that resides in DB on another server.
I don't know the database, server, username and password till runtime.
The stored procedure will take 4 arguments represent the connectivity
settings:
@Server,@DB,@UserName,@PWD
1. HOw can I connect to t...more >>
Copy data from one MS SQL database to another Posted by Kjell Arne Johansen at 5/14/2005 12:00:00 AM Hi
The old database layout is very slow on queries so I have created a new
layout and want to copy the data from the old database into the new layout.
How can this best be done?
Do I need an application do this or can it be done by the SQL Server running
a stored procedure located in one of...more >>
where to find sql server query material Posted by Nishanth at 5/14/2005 12:00:00 AM Hi,
Can any body guide me as to where I can find /download good queries. I
am trying to increase my expertise on queries in sql server.
Thanks in advance for your help
...more >>
How do I find the oldest record in a table Posted by Kjell Arne Johansen at 5/14/2005 12:00:00 AM Hi
In one of my tables in the MS SQL database all records are time stamped.
I want to know what is the oldest record.
I have used SELECT TOP 1 * FROM <table> WHERE Time > May 12 1990...
-and it works because I know the data in the table is newer than 1990 but is
there a more intelligent wa...more >>
master + movement records Posted by Kriste L at 5/14/2005 12:00:00 AM Hi Everyone,
In the table 'Account', it store when customer inject amount into his =
account.=20
In the table 'Investment', it store the transaction when the agent =
buy/sell bonds for the customer. The amount is always of 100 flat value. =
Now, the customer request a monthly statement of acc...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |