| Groups | Blog | Home |
|
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 August 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 Help With Where Clause Posted by Rene at 6/5/2005 11:29:30 PM I am creating a food database application where I allow the user to search
for food names. For this example, lets supposed that my database has the
following food names on the table.
Salt with water
Chips and salsa
Fried Chicken
Guacamole
If the user types 'sa' on the search textbox I w...more >>
Dynamic Query!! Posted by AJ at 6/5/2005 10:24:01 PM I am trying to create a stored procedure containing a dynamic query.
I am still new to using conditionals in sql, so any help to
get this query running would be appreciated!!!
CREATE PROCEDURE [dbo].[get_emp_list]
@name VARCHAR(60) = NULL,
@from_dt SMALLDATETIME = NULL,
@to_dt SMALLDAT...more >>
String or binary data would be truncated Posted by Alex Potter at 6/5/2005 8:01:34 PM Hi there,
I have an SP that on one machine runs fine but on the other fails with the
message
String or binary data would be truncated
I know why this is happening(there is a temporary table where 2 of the
column are smaller than the underlying
columns), but I'm trying to figure out what serv...more >>
Query with 5 tables, grouping by year Posted by et at 6/5/2005 6:56:53 PM How would I group results from 4 tables, each with a year field, so the
results are one row for each year, all based on one clientid from the client
table
For instance, my tables:
Client table: fields ID, ClientName
Tables 1 through 4 all have the same fields, in addition to others: F...more >>
Returning Text String. Posted by AJ at 6/5/2005 3:05:01 PM I am returning a rather large result set using a basic select query.
One of the columns being returned is a char(1) column.
I am wondering if their is a way in sql to return an associated text string
to a char(1) column.
Eg:
If char(1) = 'c' Then text string returned in place place of ...more >>
Getting records for latest 4 dates Posted by Daren at 6/5/2005 10:42:14 AM Hi,
I would like to retrieve all the records in a table that are in the
latest 4 dates.
Each record has a date field. The latest date in the table may be today,
yesterday or last week - it varies.
I would like to be able to retrieve all records that belong to the
latest 4 dates in the...more >>
Compare 2 addresses Posted by YN at 6/5/2005 8:12:01 AM Hi,
I hae a DB with a table holding companies, each company has the fields :
name, address, city, state, country and zip.
I have several clients connected to my server application (ASP.Net), and
they sometimes add new companies to the companies table. When they add the
company they don't alw...more >>
Time intervals Posted by Brian Selzer at 6/5/2005 7:58:01 AM I am calculating charged hours for labor activities.
Each Labor record has Employee, Activity, StartTime, StopTime, ElapsedHours,
and ChargedHours.
There are two business rules:
(1) An Employee cannot be on the same Activity more than one time at the
same instant.
(2) Unless expl...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
select statement with tablename as parameter Posted by nospam NO[at]SPAM tgylnospam.no at 6/5/2005 2:10:01 AM I have a stored procedure that is called with a number of parameters. From
the set of parameters I can compute which tablename out of 30 that I am going
to include in my select statement. I would like to include a parameter
@tablename in my select statement, like this:
Declare @tablename as...more >>
SQL Server 2005 vs 2000 Posted by Brian Henry at 6/5/2005 1:10:45 AM Anyone know of any major problems that might occur when 2005 is released
when upgrading a 2000 database server to it? thanks!
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |