|
|
|
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 SQL Magazine Posted by Mike at 8/29/2004 11:49:54 PM
Hi,
I would like to subscribe to a magazine/journal that covers SQL subjects =
(in general, not only SQL Server). Has anyone suggestions?
Thanks
Mike...more >>
Views vs table Variables Posted by Derek at 8/29/2004 11:37:06 PM I've been struggling all day with a stored procedure. I originally wrote it
using views to get it working and it was taking about 30 min to run. I
converted it to table variables to speed it up, and it got slower???? (It's
now down to 1hr 25 min - but that includes some other functionality)...more >>
Problem make me crazy Posted by Devil Garfield at 8/29/2004 11:11:01 PM Dear experts,
First of all, I want to ask that can I write a store procedure / job to
retrieve data from another server, and then insert the data into my current
database ??? I have try many methods but usually failed while execution ....
and it really make me feel crazy ....
So can anyo...more >>
AND operator. Does the order matter? Posted by Star at 8/29/2004 10:44:29 PM Hi,
Are the perfomance of these queries the same?
Select * FROM A where A=10 AND B=20 AND C=30
Select * FROM A where B=20 AND c=30 AND A=10
Select * FROM A where C=30 AND A=10 AND A=20
.....
Does it really matter the order that I use for the conditions with the AND
operator?
I'm not ...more >>
Help with a query Posted by Diego F. at 8/29/2004 10:08:11 PM Hello. I have a table with a column that are integer codes. These codes are
not keys and there are repeated codes.
What I need is to count the number of repetitions of each code and return
with a select query ordered by the frecuency.
An example:
The column has these values:
100
100
10...more >>
All sql server logins and groups Posted by Martin at 8/29/2004 9:45:02 PM Hi,
I am looking to write a query to select * databases in my sql server 2000
installation, the groups assosiated with each database and the users (sql
server logins) assosuiated with the group for the database.
could anybody please point me in the right direction to do this please (may
be ...more >>
persisting a query with 'for xml auto' Posted by Bernie Yaeger at 8/29/2004 8:17:43 PM I'm just playing around with the 'for xml' clause, but I'm missing its
simplest element - how do you save it as a permanent .xml document on the
hard drive? And if you can't, of what value is it?
Thanks for any help.
Bernie Yaeger
...more >>
IN Clause - Stuck on an easy query :-( Posted by Craig at 8/29/2004 7:04:44 PM I've got a table (say tblX) with an int column (say xId). I'm trying to
pass a list of string values into a stored procedure that would accomplish
something similar to the following:
declare @ids varchar(128)
set @ids = '1,2'
select *
from tblX
where xId in (@ids)
T-SQL errors out, ha...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Grouping by the hour Posted by Hassan at 8/29/2004 5:30:35 PM I have data collected every min or so.. and i want to average by the hour..
How can i do so.. As an example
TimeCollected Value
3:01AM 100
3:11AM 200
4:01AM 200
4:05 AM 100
4:10 AM 200
...more >>
where can i find a good tsql tutorial downloable? thanks noBody Posted by alf at 8/29/2004 4:37:52 PM
...more >>
varchar Posted by payyans at 8/29/2004 2:58:25 PM SQL Server 2000
---------------
Is there any disadvantage in defining the data type as
varchar(8000) instead of varchar(200) for the varchar
columns of my table? I know that the storage size of
varchar is the actual length in bytes of the data entered.
So there should not be any difference...more >>
invalid scale value Posted by shank at 8/29/2004 2:50:53 PM I'm using Dreamweaver to generate the script to connect to an update stored
procedure. The SP is OK, but I get the following error when I try to update:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
[Microsoft][ODBC SQL Server Driver]Invalid scale value
I'm sure it's related to...more >>
compare EXISTS with IN using Execution Plan Posted by Victor Feng at 8/29/2004 2:15:01 PM I run following sql as a batch in Query Aanlyzer to compare the Query Cost of
each query.
SELECT au_lname, au_fname
FROM pubsTest.dbo.authors
WHERE exists
(SELECT *
FROM pubsTest.dbo.publishers
WHERE authors.city = publishers.city)
GO
SELECT au_lname, au_fname
FROM pubsTest....more >>
Searching a table for whats NOT there ? Posted by Mike Walker at 8/29/2004 1:07:31 PM I have three tables :-
AccountTable
CustomerTable
BranchNumber
I know how to get any accounts that do not have a Customer Number, as shown
below:-
SELECT * FROM AccountTable INNER JOIN CustomerTable ON
AccountTable.AgreementCustomerNumber = CustomerTable.CustomerNumber
WHER...more >>
set nocount on Posted by Friedi at 8/29/2004 9:21:02 AM Working with Access projects .adp and active connection sql serveur the' set
nocount on' option doesn't work within Access Projects using stored
procedures (truncate, delete, update etc). Msg always appears: 'stored
procedures succesful but didn't return any records'. How could this message
...more >>
commit Posted by grace at 8/29/2004 2:32:17 AM Hi,
I have a stored procedure used in a 3rd party app that
basically and inserts, updates records from a staging
tables into another table. When this stored procedure is
called however, it basically updates ton of records and
never performs any commits and my log file never
truncates an...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |