|
|
|
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 variable number of parameters to sql stored procedures Posted by Rajesh at 7/21/2007 7:27:16 PM Can we pass variable number of parameters to sql stored procedures
like we pass to vfp functions. Then process them depending on the
number of parameters passed.
-----------------------------------
Rajesh Halyal
...more >>
Find time gaps in a database Posted by Fred at 7/21/2007 5:11:07 PM What is the best way to write a query that finds time gaps (longer than an
hour) and returns the rows corresponding to the time gap
the db that looks like this
id | time | data
1 2007/1/1 1:00:00 AM somedata
2 2007/1/1 1:01:00 AM somedata
3 2007/1/1 1:01:53 AM somedata
4 2007/1/1 1:0...more >>
Adding/Dropping Databases/SMO/SQL Express Posted by Al Meadows at 7/21/2007 4:44:22 PM Help... this is driving me nuts:
I have c# code which creates a database using SMO, and adds some tables to
it. Everything looks fine from Server Management Studio.
If, in the same execution run of my program, I use my Drop Database code, it
works fine.
However, if I end my application a...more >>
running SQL query in VBA Posted by childofthe1980s at 7/21/2007 1:36:01 PM Hello:
I'm a Microsoft Dynamics GP consultant, and I need help in running a SQL
query that I created inside of some VBA code that I composed.
Below is my query in SQL. The problem is that I do not know enough about
VBA/SQL syntax in order to put this query into VBA Editor.
Any help is ...more >>
TraceServer.InitializeAsReader fails over missing dll Posted by AlexS at 7/21/2007 12:33:05 PM TraceServer.InitializeAsReader gives me this one:
{Microsoft.SqlServer.Management.Trace.SqlTraceException: Failed to
initialize object as reader. ---> System.IO.FileNotFoundException: Could not
load file or assembly 'file:///c:\Program Files\Microsoft SQL
Server\90\Tools\Binn\pfclnt90.dll' ...more >>
delete duplicates Posted by smk23 at 7/21/2007 7:38:04 AM How do I delete duplicates from the AilmentDetail table with the following?
SELECT DISTINCT AilmentID,DataPointID, Count(AilmentID) AS CountOfAilmentID
FROM AilmentDetail
GROUP BY AilmentID ,DataPointID HAVING (Count(AilmentID))>1
ORDER BY AilmentID
Thanks!
--
sam...more >>
database name as stored proc parameter Posted by Jerry J at 7/21/2007 5:56:00 AM
I want to write a stored procedure that accepts the name of a database as a
parameter and then use it in queries.
For instance, instead of saying DBName.dbo.TableName, I want to use
@DBName.dbo.Tablename.
Is there a way to do this?
--
Jerry J...more >>
Query Notification in SQL2K? Posted by Leila at 7/21/2007 12:00:00 AM Hi,
Is it possible to implement Query Notification in SQL2K?
Any help would be greatly appreciated.
Leila
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQl server at each location or centralised SQL server Posted by Steve at 7/21/2007 12:00:00 AM Hi All
I need advice on how to implement a solution for a customer who has an
Outlet in every state in Australia (7)
My application is a POS program for sales of products for a company which
sells newspapers
I am using SQL server 2005 express as the database
Should each location have...more >>
Concatenation headache SQL Server 2005 Express Posted by JP Bless at 7/21/2007 12:00:00 AM ssql = "SELECT tbl_Employees.EmployeeNumber + ' ' + tbl_Employees.FirstName
As WDS FROM tbl_Employees"
I am trying to concatenate two fields in SQL Server Express 2005. Employees
number is int (Number) and Employees Firstname is varchar(String)
I get the error
Msg 245, Level 16, State...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |