|
|
|
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 Comma-separated field Posted by Bils at 10/23/2005 10:45:53 PM Hi,
table (contact) has a field categories with values like
row 1:
bil;jack;john;don
row 2:
bil;zub;sam;tom;jack
Ideally I would like to create a new table (split_table) with the
following values in each row without any duplicate. The
item NoOfOccurence
---- ----
bil 2
jack 2...more >>
Best Practise For Updates between Access 2000 and SQL Server Posted by PeteP at 10/23/2005 9:06:09 PM Hi,
Let me paint a picture...Access 2000 frontend, linking to a SQL Server
backend, inherited database, me - fairly new at this! :o)
The developer has, for better or for worse, (I'm not sure), designed a
frontend that grabs a set of order records from SQL and pulls them into
a form. ...more >>
Join TOP n Rows Posted by mail NO[at]SPAM brianrice.com at 10/23/2005 8:40:13 PM Is there a way to join tables using a TOP n attribute... or a technique
to accomplish this... I have ran into a need for this several times.
Example 1:
Use the most recent available exchange rate to calculate a dollar
amount (where we don't always have an exchange rate on a given day like
w...more >>
how to implement a recursive algorithm as iterative? Posted by amota at 10/23/2005 6:27:02 PM Hi,
I have to go through some tables, like a network. I have a recursive
algorithm, but I need to do it iteratively.
Basically, there are 2 tables through which I have to go: Items table and
Relationship table.
The tables I have defined are like this:
- Item table, 2 fields: ItemID, It...more >>
More help with count and group by Posted by Sonny Sablan at 10/23/2005 4:25:27 PM Using these tables
tbFamily
FamilyID | FamilyName
tbChild
ChildID | FamilyID | ChildName | Birthday | etc...
tbVisitLog
VisitID | ChildID | DateTimeIn | etc...=20
I am trying to get how many children visited once, twice, three times, =
four times and five times.
Example return rec...more >>
Sp_addlogin from vb.net (security) Posted by fasttrack at 10/23/2005 2:17:04 PM From a vb.net form I created the chance to add an SQL Server user with role
as administrator.
To create it, username and password are retrieved from two text box and then
the login is created with:
cmdSQL = "EXEC sp_addlogin '" & txtUser.text & "', '" txtPwd.text & "'"
then the cmdSQL is exec...more >>
Count(*) with two criterias Posted by tran.loan NO[at]SPAM gmail.com at 10/23/2005 1:21:59 PM Hi,
I'd like to do a query like this:
SELECT TABLE_ID, TABLE_NAME, COUNT_OUTPUT = (COUNT(*) FROM #TABLE WHERE
NUM_ID IN(27), (COUNT_EDIT = COUNT(*) FROM #TABLE WHERE NUM_ID NOT IN
(27))
FROM #TABLE
GROUP BY TABLE_ID, TABLE_NAME
Of course, that doesn't actually work. I just want a count...more >>
Maximum Performace with Concurrency and without Deadlocks or Dirty Posted by Andy Furnival at 10/23/2005 10:24:01 AM Hi guys + gals,
I've come to a point in redesigning a database that is basically the reason
we chose to redesign it is for International support and to rid the db and
application code of permitting dirty reads against the database. However,
I'm at the point where I just cannot find a suita...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to use IIF function (or similar syntax) in SELECT clause Posted by Bill nguyen at 10/23/2005 7:44:04 AM I need to create a simple view containing a driverID that must be converted
to numeric.
IF isnumeric(driverID) = 0 then 0
I tried to use IIF(isnumeric(driverID), driver, 0) but it's not accepted in
regular query.
Please help!
Thanks
Bill
...more >>
triggers calling stored procedures with parameters using variables - efficient coding or not? Posted by Gerard at 10/23/2005 2:42:56 AM Hi,
I'm currently working on some triggers that are being called from
within our ERP package (running on SQL Server 2000).
The logic that is within these triggers is rather complex. Now I'm
thinking about moving large parts of this logic, especially the
recurring logic such as updates/inser...more >>
Default value for Datetime column Posted by Mark_S at 10/23/2005 12:00:00 AM Hi
I am using 01/01/1753 to define the "Empty Date" for my datetime fields.
My tables have several columns that are defined as datetime fields which
need to default to the empty date that I have chosen.
I type in 01/01/1753 as the default value of the table designer, however
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |