|
|
|
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 |
TOP and OFFSET Posted by Garfinkle at 4/29/2005 4:48:04 AM I'm trying to create a JSP page which access's a database of about 3 million
records. What i am trying to do is display this in a webpage table with 15
results per page. I can get a display of 15 records but the only start from
the first row in the table. I have found out that offset does not ...more >>
Passing in a Parameter Posted by Kunkel at 4/28/2005 8:04:09 AM Hi All,
I have a Stored Proc and would like to pass in a VARCHAR parameter. The
problem is that the query will need to use it in a IN clause...
DECLARE @PARAM AS VARCHAR(20)
SET @PARAM = 'Dan', 'Mike', 'Lisa'
SELECT *
FROM Orders
WHERE Name IN (@PARAM)
is there a away around this?
...more >>
VIEWING A TABLES STRUCTURE AND INDEXES Posted by GW at 4/26/2005 9:17:01 PM Hi,
I would appreciate it if someone could help me on the following:
I have several tables eg, tbl1, tbl2, tbl3.....tbl10. How to view all the
tables structure
and indexes using SQL Query Analyzer or using stored procedures.
tq....more >>
Trigger Posted by Al Newbie at 4/22/2005 10:20:15 PM I want to be able to check if column 27 has been updated either on an insert
or an update.
If this column has been updated with a value I want to insert the following
fields into a different table (InvMov) within the database:
StockCode, Warehouse, TrnYear, TrnMonth, EntryDate, TrnQty and Move...more >>
Pivot Query or Cross Tab queries Posted by MChrist at 4/22/2005 1:46:03 PM I can't seem to figure out how to create a cross tab or pivot query on data.
If I was writing the SQL in Access I would write it like
TRANSFORM SUM(DTL.Amount) AS Amount
SELECT
STC.ClientID
, STC.Client
, STC.SS_ID
, STC.Region
, STC.[Sales Director]
, STC.[Product Consultant]
, STC...more >>
Trigger Posted by Al Newbie at 4/21/2005 9:47:25 PM I want to be able to check if column 27 has been updated either on an insert
or an update.
If this column has been updated with a value I want to insert the following
fields into a different table (InvMov) within the database:
StockCode, Warehouse, TrnYear, TrnMonth, EntryDate, TrnQty and Mo...more >>
Query Performance Posted by MoinJ at 4/20/2005 12:14:02 PM I have 2 tables, Make and Model where Make is the master table and Model has
a reference of make table by Make_Id since there can be multiple models for a
single make. Now, i have 4 SQL's below and i want to know which SQL should
perform better.
select make.make_name, model.model_name
fro...more >>
why the result of the query is in asending order Posted by bhavik at 4/18/2005 4:21:02 AM hi
i am facing one problem
i am having two table location and routesegment
location table having locationid as primary key.
routesegment having startlocation and endlocation and other columns.
routesegment table is
rsid rid distance ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
msde AlaptopND sql server on save Posted by rOBBY at 4/16/2005 1:11:28 PM I have SQL Server Developer edition on my laptop. Want to install MSDE on
same laptop (so VB .NET 2003 will work.
Any issues here with two versions/inmstances of "SQL Server" on same box?...more >>
Manipulate duplicate rows Posted by bamboo at 4/15/2005 9:59:02 AM I have two of the exact same rows, but I want to change one field of one of
the rows. How do I do this?
i.e.
table_a
group name revenue
A jim 20
A jim 20
I want to change one jim to ken.
I tried
update table_a
set name = 'ken'
from (select top 1 * from table...more >>
Missing Format() - Function Posted by nieurig at 4/15/2005 1:33:00 AM Hi folks,
i have to translate SQL-Statements from Access 2000 to SQL
Server 2000. There was a lot of Access-Functions used
(mid, str, iif ...) and i convert them to SQL-Server
Syntax, but i dont found a way to simulate the results of
the Format-Function with was used for numeric data
as "...more >>
Deploying vb.net english query application Posted by Tinium at 4/15/2005 12:00:00 AM Hi,
I'm attempting to distribute a vb.net english query application to a
client, however, when the client runs the application, it crahses when
it tries to create an instance of the "Mseq.Session" object.
As far as I can tell, the interop and the original dll are being
included in the se...more >>
Format Date in GroupBy query Posted by J at 4/14/2005 4:13:02 PM What is the syntax for a query that will give me the Count of [PartID]
shipped each month. I think I need to do a Count on PK_ID and Group By the
DateShipped but how do I format the date. I tried using DateName but I can
only get it to work if I split out the Year and month. Thanks for the hel...more >>
search in arabic Posted by FaYYaZ at 4/14/2005 2:13:31 PM Hi every one
I am having problem with search, I have data in sql server in arabic
language , when I am searching via submitting a form using asp it returns me
nothing and select statment looks like this "Select * From arabic Where
title like '%Ù.%' Order By Title ASC" search text "'Ù.%' " ...more >>
TSQL Date question Posted by tag at 4/12/2005 11:02:03 AM My order dates of service load from a text file and contain "today minus 1,
plus 3". For example, using today's file, this equates to yesterday's date
(4/11) through Friday's date (4/15). What I want to delete using a SQL
command daily that requires no input from me is yesterdays info.
Ho...more >>
problem with sql Posted by bhavik at 4/12/2005 2:36:02 AM hi
I have problem with sql. I dont userstand what should I do.
my problem is
I have table UserLocationHistory
I want those user who have latest date.
I am fired sql like
SELECT DISTINCT userid, datetime
FROM UserLocationHistory
ORDER BY userid, datetime DESC
...more >>
select query assistance Posted by AshleyT at 4/5/2005 12:31:10 PM Querying a table that has the line items for a ticket sold at a retail store.
So I am looking for the tickets that only have CIGARETTE items on it. The
ITEM table has columns:
TICKET NUM (PK)
TICKET_DATE (PK)
LINE # (PK)
ITEMDESC
ITEM UPC
ITEM DEPARTMENT (When equal to 2 then cigarett...more >>
Use Results From a Select as the "From" for Another Select Posted by RitaG at 4/1/2005 10:09:03 AM Hi.
I have to use a long, complicated "Where" clause in a SQL statement and
thought it would be better to break it up into 2 Selects but am not sure of
how to do it.
I'll make my example really simple - I want to select TextData (defined as
an Image in the SQL table) from a table Where ...more >>
Query Help with IF stmt Posted by Andy at 4/1/2005 7:23:11 AM Hi All,
Can someone please help me with below access query to convert to sql ?
UPDATE tblEmp
SET emprank = IIf('[tblemp]![ID] Mod 3', '[tblemp]![ID] Mod 3', 3).
Thanks in advance
Andy
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |