|
|
|
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 Data aggregation, syhcronization, and search Posted by crbd98 NO[at]SPAM yahoo.com at 4/8/2007 9:49:24 PM Hello All,
I know that this problem is not SQL Server specific but I decided to
post it here because it is a problem that I am certain many of you
expericenced (or at least thought about).
In my system, I have a central SQL Server Database and number of
remote "data providers". Some of thes...more >>
Upsizing Access Queries to SQLExpress Posted by dotNET learner at 4/8/2007 9:10:42 PM I could successfully upsize all TABLES of an Access2002 database to
SQLEXPRESS.
How can I export/upsize Access Queries (which are many and useful)??
Newbie seeks help.
Thanks !
...more >>
Why is nvarchar(MAX) unavailable on a remote SQL Server 2005 serve Posted by Mike at 4/8/2007 8:50:02 PM Hi. I'm using the datatype nvarchar(MAX) locally on my server, but when I
connect remotely to a SQL 2005 server on another network, only regular
nvarchar() is available. Why wouldn't nvarchar(MAX) be available on the
remote server?
Thanks!...more >>
Combining Multiple Records/Rows into Single Row Posted by Damien at 4/8/2007 7:08:13 PM I have a problem that I would like some ideas on.
Given the following SQL rows:
Insert Order, Year, Value1, Value2, Value3, Value4
3, 2007, 5, 6, NULL, NULL
2, 2007, 7, NULL, 1, NULL
1, 2007, NULL, 5, NULL, 2
I need to combine the rows into a single row for Year 2007 that would
be:
200...more >>
looking for the Access equivalent of the CASE WHEN SQL Server operator in query Posted by Oscar at 4/8/2007 6:18:24 PM I know this may be not the right newsgroup for my question but I can't find
a better newsgroup to ask for :
I am trying to convert some SQL Server queries to have them working with a
MS Access database and use ADO.
I am not able to find an Access equivalent for the SQL Server Construct :
...more >>
varbinary (float) to numeric (SQL Server 2000) Posted by JackReyn at 4/8/2007 1:04:01 AM I want to convert a [float] held within a varbinary() variable to a numeric.
The 2nd select below fails (& I populate @v directly but want (eventually!)
to read from db image field).
declare @f float
declare @v varbinary(8)
set @f = 100
select @v = (select cast (@f as varbinary(8)))
sele...more >>
After insertion data from XML into a table, the table has NULL rows, what is happening? HELP ME!!! Posted by Orgil at 4/8/2007 12:13:15 AM Hi all,
I need to insert datas from XML into Temp_User table. But after
insertion (no error message occurs), Temp_User table has 3 rows which
have cells valued as NULL. What can I do, tell me please!!!
---------------------------- Code is here
---------------------------------------
delete f...more >>
what is the solutions Posted by Bpk. Adi Wira Kusuma at 4/8/2007 12:00:00 AM I have a table transaction. it has a lot of records which contains data for
5 years. How to make the best performance access?
1. Do I need to devide the data per year into new table?
2. Or Do I just make a view or function to get the data per year?
3. Or ...... what?
oh yeach.......... I s...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL SELECT Posted by DE at 4/8/2007 12:00:00 AM Hello all
i made a script to select user firstname and lastname like "John Does"
but i would like to view only the first 3 letters from the firstname and
the last name like "Joh Doe"
how can i do this ?
Thanks for your help
...more >>
optimize question for ORDER BY query Posted by Oscar at 4/8/2007 12:00:00 AM This is the actual query :
recordset rstA:
"SELECT cancelled FROM tblOrders WHERE ID_company=" & ID_comp & " ORDER BY
ID DESC"
IF NOT rstA.eof THEN
IF rstA!cancelled=FALSE then
(process something)
ENDIF
ENDIF
This works fine, however I want to optimize the query by ad...more >>
Help on best way to design sql server express 2005 connections for a WAN Posted by Steve at 4/8/2007 12:00:00 AM Hi All
I have a client who wants to use my POS windows forms application to control
his business, which consists of 1 outlet in each capital city in Australia
He wants to have the data from all the outlets available in 1 copy of SQl
server express running at his head office for reporting, ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |