|
|
|
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 Average in each row Posted by Pradeep at 5/28/2007 11:11:11 PM I have two tables
Table1 (Date,Val) and Table2(Date,Val1,Val2) --val, val1 and val2 are
integers
I want to write a query wherein i take the date interval and for each
date in the date interval i display
Date,Val1,Val2, Avg(Val) --Avg(val) is for the whole interval i.e the
Avg is same and...more >>
Accessing Scalar data Returned from a Stored Procedure inside anot Posted by Alex Maghen at 5/28/2007 8:35:01 PM I have a Stored Procedure, "GetMailStats" which takes a parameter @UID and
returns a single row of data. One of the columns in that row is "NewCount"
Now, I want to use my GetMailStats stored procedure from within *another*
stored procedure and basically, all I want to do is call "GetMailStat...more >>
Please help with this (simple?) query Posted by Alan Silver at 5/28/2007 5:04:42 PM Hello,
I have what is probably a very simple query to write, but I can't seem
to get my head around it.
I have a table that hold information about possible delivery methods
used by a company. In its simplest form, this table looks like...
create table DeliveryMethods (
DeliveryID int n...more >>
How to connect via ADO .NET to a sql server db in SINGLE_USER mode? Posted by mjheitland at 5/28/2007 1:48:42 PM Hi,
is it possible to connect via ADO .NET to a db that was set to
SINGLE_USER mode?
I always get an exception when I try to connect.
I hoped to reduce runtime for sql bulk copy insertions when I set db
into single user mode.
Who can help me?
Greetings,
Michael
...more >>
SqlBulkCopy and SQL Server Compact Edition Posted by mjheitland at 5/28/2007 1:27:55 PM Hi,
is it possible to use SqlBulkCopy with SQL Server Compact Edition?
Or what is the fastest method to insert many records from a csv file
into a SQL Server Compact Edition database (*.sdf)?
Greetings,
Michael
...more >>
T-SQL statements/syntax changed from 7.0 to 2000 Posted by myrights99 NO[at]SPAM gmail.com at 5/28/2007 1:03:13 PM I am not able to get detail information from what as changed from SQL
Server 7.0 to 2000 from T-SQL commands, statements, syntax etc
standpoint. any help, whitepaper, URL will be highly appreciated.
Thanks
...more >>
Finding records that don't match in a join Posted by John Scott at 5/28/2007 11:51:00 AM Here is my situation...I have two tables:
TableA, TableB
In TableA there is no ID used as a primary key, instead there is a
combination of 4 fields that make up a unique record.
During a process, I will be inserting all of the row information from TableA
into TableB along with some addi...more >>
select result as comma-separated output Posted by bbinto at 5/28/2007 11:14:26 AM Hello,
I am wondering if/how I can easily do the following:
I have a select statement in a stored procedure which gives me let's
say 3-4 result rows of one column of a table.
Example:
"SELECT mykeywords FROM mytable"
result rows (array):
mykeyword1
mykeyword2
mykeyword3
Is it possi...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Tracking user activites n 2005 Posted by FARRUKH at 5/28/2007 8:24:01 AM is there any way in SQL Server 2005 to find out who cancelled/disabled the
maintenance job(i.e backup jobs)?
Someone at work diabled the jobs and i am trying to find out who did tht
thanks
...more >>
Computed column in a table with formula referencing a UDF Posted by MAGICIAN1967 at 5/28/2007 6:22:01 AM I want to change a UDF that is referenced by a "Computed Column" in a table,
but get an error that prevents me from doing that.
To bypass the problem I do the following time-consuming steps:
1.: delete the formula from the column definition
2. update the UDF
3. retype the calling to the UD...more >>
OR & IF which is the better for performance in SP? Posted by 2ooo at 5/28/2007 4:01:05 AM Hi,
For example, in any SP, I have a parameter that name is
@departmentID, if ID value -1 then return all records else
corresponding record..
which is the better 1 or 2 ?
1 :
select ...
from table1,table2
where ...
and (table1.departmentID=@departmentID or @departmentID=-1)
2 :
if @d...more >>
String comparison in SP Posted by riyaz.mansoor NO[at]SPAM gmail.com at 5/28/2007 2:31:28 AM
In the following SP, the @value from settingsCursor never gets set.
The default values are always returned. I have checked the values in
the table and it is indeed as in the SP.
My string comparison is not working. Am I missing something really
simple?
Riyaz
create procedure Get_Gran...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |