|
|
|
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 Selecting missing sequence numbers Posted by Jami at 11/26/2006 11:52:33 PM
Hi!
i am maintaining a distributed database. data comes in shape of batches.
i want to determine which no is missing.
sample data and table steucture are like this
Main_table
s-no batch_no region_id
1 1 AA1
2 1 AA1
3 1 AA1
4 1 AA1...more >>
retrive images as files on the disk Posted by sam at 11/26/2006 11:16:32 PM how can i retrive programicly images stored in an table and put them
as files on the disk?
tanks
...more >>
to EXCEL Posted by Agnes at 11/26/2006 10:21:06 PM I use stored procedure to query some data and put the result in the Result
Table. When I use ado.net (fill over 10,000 records into the dataset), it
got "internal connection error"
Can I export the data from SQL database into excel pragmatically since I
need to pass to filename (by using s...more >>
How best to use FOREIGN KEY(s) on a lookup table? Posted by Mark S. at 11/26/2006 9:16:47 PM /*
I'm not sure if this problem IS best solved with a technique I'm unaware of,
or with better design.
In either case, your thoughts are appreciated.
The current design has primary tables (tbVendors, tbCustomers, tbContractors
and so on).
All the contact/address information for the aforeme...more >>
Convert Date Problem Posted by hon123456 at 11/26/2006 6:23:16 PM Dear all,
I have convert a date by using
convert(varchar(10),date,111) as DeliveryDate to yyyy/mm/dd. Now if I
compare DeliveryDate as follows:
Select * from table1 where DeliveryDate >= '2006/5/1'
It returns error result with DeliveryDate bigger than
2...more >>
Synchronizing Production and Archive Databases Posted by Don Miller at 11/26/2006 5:46:32 PM In a scenario where items are periodically archived to an archive database
from a production database, is there a way to synchronize reference/lookup
tables in the archive database when rows are inserted/updated in the
production database lookup tables?
Sounds like this would be a good plac...more >>
Striping Numbers from a String Posted by scott at 11/26/2006 4:18:30 PM I have a varChar field that was meant to use as a notes field.
Unfortunately, previous users used the field to enter text notes and an
important number code that relates to another table. The
only part of the Notes field (f1 in my example) that is important is the
first 2 digits or spaces. I ...more >>
SELECT Question: Get each date when I have start und end date Posted by Andreas Klemt at 11/26/2006 3:36:25 PM Hello,
I have this table:
startdate enddate price
11/01/06 11/21/06 45
11/24/06 11/31/06 40
How can I make a SELECT from this table to get each date with a price like
this:
date price
11/01/06 45
11/02/06 45
11/03/06 45
11/04/06 45
11/05/06 ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Inconsistent Behaviour with TRY - CATCH and MS DTC Posted by SimonDev at 11/26/2006 2:12:02 PM Hi
I've got a stored procedure with a try - catch block that appears to exhibit
inconsistent behaviour under identical conditions. At the moment it appears
a little like black magic - could anyone explain what might be going on?
SET UP
-------
Here's a snippet of code from the stored...more >>
Cross Tab query in SqlServer Posted by Darsin at 11/26/2006 9:55:50 AM Hi,
I have three tables with there fields given in brackets:
User: [userId as int] (PK), [userName as navarchar]
Divisions: [divisionId as int] (PK), [divisionName as nvarchar]
DivisionsOfUsers: [userId as int],[divisionId as int]
the "DivisionsOfUsers" tables has many-to-many relationships b...more >>
C++ SQL SDK Tutorials Posted by Justin Marshall at 11/26/2006 9:04:22 AM Hello, I'm currentlly using SQL 2005 server, and my application is a C++
based app. Does anyone know of any
good tutorials on using C++ and SQL 2005? I looked on the internet and I
couldn't find any, atleast specific to
SQL 2005. Just that would have basic stuff connecting to the database
...more >>
Converting MS access queries to SQL Server Posted by robboll at 11/26/2006 7:07:19 AM I can do this problem using MS Access (see below) but need a way to do
it using SQL Server exclusively. Thanks for any help.
raw Rainfall data:
DDate Acc Amount
10/10/2006 8:03:00 AM 40.2 0.04
10/10/2006 8:14:00 AM 40.24 0.04
10/10/2006 8:21:00 AM ...more >>
TempDB is growing rapidly Posted by sriram at 11/26/2006 6:03:58 AM Hi All,
I am having a problem with the size of TempDB. I am using SQL Server
2000 sp4. I have 10 Databases on my server.
I am hitting a select statement which mainly hits a view with many
joins(Some where around 15 table are queried). My query used to return
my values till thursady, but fro...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |