|
|
|
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 Union Query Help! Posted by Jami at 1/21/2007 11:54:52 PM Dear All!
i have following query
select count(distinct mid) from mytab
union
select count(distinct mid) from mytab_old
union
select count(distinct mid) from mytab_hist
this return me three out puts
100045
11245
334562
but i a single result sum of al these how will it b possibl...more >>
A GOTO statement references the label Posted by Robert Bravery at 1/21/2007 11:49:41 PM HI All,
When trying to run a SP I got this error
A GOTO statement references the label 'QuitWithErrors' but the label has not
been declared.
I have declare the label 'QuitWithErrors' , it is at the end of the SP.
My questiion is, will the statement 'GO' which there are many, interfere
with t...more >>
ajaxulation question Posted by Mr. SweatyFinger at 1/21/2007 11:37:31 PM I want to swap out my images smoothly without getting stuck between pages.
Do I need to add ajaxulate on each picture, or ajaxulate on the whole
website?
...more >>
Databse project group vs2005 missing Posted by Martin at 1/21/2007 9:53:56 PM Hi,
I am just attempting to create my first managed stored procedure.
Started VS2005.
went to File | New | Project
Under C# There is no "Database" project node.
I have visual studio 2005 and sql server 2005 standard edition installed on
my dev machine.
cheers
martin.
...more >>
Self Linked Server Posted by Martin at 1/21/2007 8:05:19 PM Hi,
I am setting up a linked server on my local SQL server 2000 development
machine.
The server is linking to itself and I am setting this up soley for learning
purposes.
I first used the command
Exec sp_addlinkedserver @server='link' , @srvproduct='SQLServer OLEDB
Provider' , @provider...more >>
Why selecting from stored procedure is disallowed? Posted by wizofaus NO[at]SPAM hotmail.com at 1/21/2007 6:27:16 PM I've seen this asked quite a few times...how do I select from (or join
with) the output of a stored procedure?...to which the answer is
usually either to create a temporary table, change your stored
procedure, or use openquery() after setting up a server link back to
the current instance+databas...more >>
Inserting data for two tables at the same time Posted by Roy Goldhammer at 1/21/2007 5:50:09 PM Hello there
I have two tables that i need to enter them data at the same time.
The first table Is Header and the second one is detail.
After inserting the data to header table, its idetity is being use on the
detail table.
I have two store procedure for that who enter the data exacliy a...more >>
Trigger for UPDATE, INSERT Posted by Michael Tissington at 1/21/2007 5:44:13 PM If I have a trigger FOR INSERT, UPDATE how do I know which it is when the
trigger is running?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Get the latest date of a product price Posted by et at 1/21/2007 1:15:16 PM I have 2 tables, a list of products, and a list of product prices. The
price table contains a list of the wholesale and retail price on any given
date, so a product may have had several price changes and hence has several
related records in the price table. How do I do a query to only get th...more >>
Calculated field question Posted by Robert Dufour at 1/21/2007 1:06:36 PM Table contains 2 fields
Channel type integer
Inbound type bit
Sample data
Channel Inbound
1 True
1 False
2 True
3 True
3 False
I need to obtain a third field CHDir which for sampledata above would show
1 True 1 I...more >>
Database structure problem... Posted by RasmusKL at 1/21/2007 12:59:13 PM Hey,
I'm currently building a database and have a small table-related
question. The system I'm building is to be used for web-based surveys.
As it'll run quite a few surveys, lots of new data will enter the
database and lots will need to be "archieved" after a while. In this
sense, it consist...more >>
Script Object Posted by Jake K at 1/21/2007 12:24:35 PM SQL Server 2005. It there an easy way to script all tables, views, stored
procs, and insert statements for 100 rows in each table in each database?
I've been through the generate scripts tasks, however, this only applies to
one db at a time and does not create inserts for x number of rows. A...more >>
display as columns instead of rows? Posted by user at 1/21/2007 12:06:52 PM Hi,
Using SELECT, is it possible to display the results in column format
instead of individual rows?
For eg:
select name from student
.. Instead of showing as
JOHN
PETER
FELICIA
...
...
..
Can it be displayed as
JOHN | PETER | FELICIA | ... | .. |
instead?
...more >>
SQL crl stored procedure output Posted by Chad at 1/21/2007 11:51:09 AM I am having trouble with my stored procedure output; I keep getting the
following error "Object reference not set to an instance of an
object." What am I not doing right?
public void Login(string username, string password)
{
SqlConnection dbConn = null;
...more >>
Help modifying stored procedure sql 2005. Posted by Nomad at 1/21/2007 11:36:35 AM Hi,
I have recently upgraded from SQL 2000 to SQL 2005. I am having trouble
modifying/editing a stored procedure. In SQL 2000 you simply double clicked
the stored procedure, modified it, then clicked apply and then Ok. This
does not seem to be the case in SQL 2005. I have been reading a...more >>
Export Posted by RON at 1/21/2007 11:32:14 AM I am working on WinXP Pro & use SQL Server 2005 as the database server.
I want to export a few tables existing in SQL Server 2005 to MS-Access
2000 but I don't find any tool to export the tables. In SQL Server 7.0,
there was an import/export tool (under the 'File' menu, if my memory
serves me ...more >>
Check for column exists (sql 2005) Posted by Michael Tissington at 1/21/2007 11:27:14 AM How do I check for a column existing before I attempt to Add it to a table ?
...more >>
Fastest way to import Posted by Robert Bravery at 1/21/2007 7:50:00 AM HI al,
Which is the fastest way to import data from a legacy dbase table
Linked server,
select into using openrowset,
DTS
Thanks
Robert
...more >>
Each GROUP BY expression must contain at least one column that is not an outer reference?? Posted by Shocky at 1/21/2007 5:45:34 AM hi guys,
We have just replaced SQL 2000 with SQL 2005.
The following type of statements are creating a problem in 2005 while
they wer running fine in 2000.
Consider the update statement:
update a
set a.col3 = (select count(b.idcol)
from tableB b with...more >>
cursor to insert into a table variable Posted by tom booster at 1/21/2007 4:28:00 AM I would appreciate some help in writing a cursor to populate a table
variable based on a result set
All the cursor does is find all rows with same area ID and areaName and
insert into the table variable the one with the latest modified date,
if all modified dates are equal then insert the one ...more >>
Getdate() & Function Posted by Taha at 1/21/2007 1:34:48 AM Hi All
I want Use This Month An Year (Getdate()) In Function There is Any Way To do
This
Thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |