| Groups | Blog | Home |
|
March 2003 April 2003 May 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 |
Filter by week: 1 2 3 4 5 SQL 2005 stored procedure Posted by Andy at 11/25/2005 9:54:55 AM Hi everyone,
it seems to be something really simple, but I'm hitting the wall here.
Where does sql 2005 actually keep stored procedures code?
The issue is:
When I change the code of SP from SQL Management Studio it works fine.
I can modify code without any problems. But when I connect to sql se...more >>
Looking at previous records Posted by stevebuy NO[at]SPAM eircom.net at 11/23/2005 7:23:28 AM Hi, I was hoping someone would point me in the right direction.
I have table with a few million records. Each record has a timestamp
field.
I want to be able to calculate what is the average time between all the
timestamps in the table.
It is further complicated by needing to remove from the ...more >>
Composing a date from date parts Posted by aroraamit81 NO[at]SPAM gmail.com at 11/23/2005 3:44:37 AM I have three date parts namely,
Year
Month
Date/Day
as integer values stored in one column each in a table in a SQL Server
2000 database. I need a function to serialize/compose/create a datetime
type out of them so I could use that in a query (pseudosyntax) as
below:
SELECT CreateDat...more >>
Difficulty outputting in right format. -Tricky one Posted by philipbennett25 at 11/22/2005 1:53:45 PM Hi can anyone help me with this?
I have would like to be able to output some data in a very specific way
and unfortunately my SQL isn't quite up to it. The database is not
SQL Server so in this case only SQL can be used.
I have 2 Practically Identical tables that record test results from ...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |