|
|
|
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 CR report - connection can't dispose Posted by Agnes at 4/20/2007 10:45:53 PM My story is..
(1) create report by using CR.10 (connect to MSSQL)
(2) use vb.net application preview the report .
(problem) After preview the report. Connection is create , I can use SQL
servers's current activity to check it.
Even I close the reprot in my VB.net application, the connection ...more >>
One Row into Many? Posted by Don Miller at 4/20/2007 4:54:36 PM There's probably a term for this (shredding?), but I need to take each row
from a source table and transform the columns in each row into as many rows
in another table. For example, the source table has these columns,
SourceTable
-------------
Date (date)
Thing1 (int)
Thing2 (varchar)
Th...more >>
Trigger problem: Posted by manish1.agarwal NO[at]SPAM gmail.com at 4/20/2007 4:07:51 PM 1) This will affect two tables. Account and Treatment.
2) Trigger is on Account for update and insert
3) After insert or update in Account an insert will be there in
Treatment.
4) the PK or newly inserted Treatment row will be updated in Account
table. (Account table has FK for Treatment).
5) ...more >>
Export to Access - Varchar(3) becomes Longtext Posted by DWalker at 4/20/2007 2:32:34 PM I am exporting a SQL 2000 table to an Access 2002 (initially empty)
database, using SQL 2005's Management Studio.
Some of the fields that are of type Varchar(3) Null, Varchar(9) Null,
and Varchar(40) Null are getting set to Longtext in Access.
Any idea why this should be?
Some of the Va...more >>
Apache instances and CAL licensing Posted by xav at 4/20/2007 2:21:38 PM I would like to upgrade an SQL Express installation to a SQL Server
2005 Workgroup or standard edition. My question is about CAL
licensing. Each CAL seams to be linked to a user so what happen in the
case of multiple Apache instances (located on the same web server)
that would access simultaneou...more >>
TimeOut Expired - Tracing historically. Posted by Audrey Ng at 4/20/2007 1:55:26 PM I have an Access application with SQL Server 2005 as the back-end. I
"think" there was a deadlock on the tables which has caused a TimeOut
Expired error for the users.
However, the problem resolved itself because the users re-started the
application but I still would like to know what has happen...more >>
set up scheduler on step basis Posted by Test Test at 4/20/2007 1:55:21 PM Is that possible to schedule a job (lets say it has 4 steps) in such a
way that step1 and 2 runs today and step 3 and step 4 runs tommorrow?
thanks.
*** Sent via Developersdex http://www.developersdex.com ***...more >>
Help with XML EXPLICIT to get output in desired schema Posted by dbuchanan at 4/20/2007 1:22:05 PM I am using "FOR XML EXPLICIT" in a SQL Server 2000 query and am not
getting my results in the schema I desire. (The reason I am getting
the data in the schema I am is relatively obvious, but I do not know
how to structure my query to return the results in the schema that I
want them.
At the e...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ALTER TABLE doc_exa ADD @variable? Posted by Peter at 4/20/2007 1:04:02 PM Sql Svr 2000. Can I add a column to a table that is the contents of a
variable?
create table doc_exa (id INT)
go
declare @emp_cd varchar(10)
declare testCursor CURSOR for
select top 8 emp_cd from emp where termdate is null and home_store_cd='08'
open testCursor
fetch next from testCursor...more >>
possible to limit database listing to those of which you are a user? Posted by christine.rasmussen NO[at]SPAM gmail.com at 4/20/2007 12:48:48 PM Is there a way, when showing all the databases on a server, to have it
show just the ones you either want to see or those that you have
rights to see?
It drives me nuts having to scroll through a hundred plus databases to
get to my one database each day!
Thanks
...more >>
DELETE 1 FROM MyTable WHERE ID=123? Posted by Ronald S. Cook at 4/20/2007 12:14:09 PM Will putting the number 1 in my DELETE script peform better than without
having it?
In other words, I currently have: DELETE FROM MyTable WHERE ID = 123
But does it keep on looking for that ID after finding the first record, even
though there is only one record with that ID?
I'm wonderi...more >>
permissions on SP and view Posted by gv at 4/20/2007 11:23:35 AM Hi,
What would be the best way to add the same permissions that are on one
SP\view to
another SP\view?
thanks
gv
...more >>
Subquery Logic Puzzler Posted by JT at 4/20/2007 11:14:02 AM Hi all,
Given the following table of customer visits....
CREATE TABLE [dbo].[Visits](
[VisitID] [int] IDENTITY(1,1) NOT NULL,
[VisitDate] [smalldatetime] NOT NULL,
[VisitType] [varchar](10) NOT NULL,
[CustID] [int] NOT NULL)
GO
I want to be able to select those customers who did no...more >>
Find whole numbers Posted by David C at 4/20/2007 10:31:03 AM I have an SQL select that I need to add a WHERE clause to bring back all
records where SeqNo is not a whole number. Below is my normal SQL without
the WHERE clause. Thanks.
David
SELECT [ID] ,[SeqNo] ,[FileNumber] ,[Subfile]
FROM [Filedata].[dbo].[Subfiles]
...more >>
Return metadata information about a query Posted by jbyrd at 4/20/2007 10:22:25 AM Is there a way to return metadata about a query, and instead of
returning the actual data recordset, return the table name, column
name, datatype etc.? I have tried Setting FMTOnly - but that just
seems to give the column names - not other information about the
columns.
For Example:
Execut...more >>
Deal with NULLs Posted by Uday at 4/20/2007 9:34:04 AM I have a table: T1
Col1 Col2
NULL 1
son 1
sun 3
NULL 4
su 5
And a stored Procedure with a query that queries that above table.
----- Stored Proc ----
Create procedure (@param1, @param2)
....
query
....
GO
---- End of Stored Proc ----
I need to write a query, a...more >>
openxml - attribute and value Posted by farshad at 4/20/2007 8:02:01 AM Hi,
Using openxml, how is it possible to get get the code values for each
correlation element please?
<Data>
<date>19-Apr-2007</date> <
<correlations>
<correlation code="WTI NYMEX:WTI NYMEX">1</correlation>
<correlation code="WTI NYMEX:BR IPE">12</correlation>
<correlation co...more >>
split Posted by farshad at 4/20/2007 7:24:01 AM How is it possible to separate a varchar(50) value such as 'WTI NYMEX:AL LME'
into 'WTI NYMEX' and 'AL LME'
i.e. separated by :
Thanks...more >>
Interesting SQL problem : How to track movement history Posted by Anthony Paul at 4/20/2007 6:33:49 AM Hello everyone,
There's an interesting SQL problem I've come across that I'm currently
banging my head against. Given the following table that contains item
location information populated every minute :
location_id date_created
=========== ============
5 2000-01-01 01:00 <-- Don'...more >>
openxml Posted by farshad at 4/20/2007 6:02:03 AM Hi,
Using the xml below, could you please correct the sql to retrieve the values?
Thanks
<marketData>
<date>19-Apr-2007 17:08:55</date>
<Rates>
<Rate code="USDCAD">
<values>
<value type="BID">1.1276</value>
<value type="ASK">1.1277</value>
<va...more >>
SQLMail varbinary as mail attachment Posted by webteam at 4/20/2007 3:06:03 AM Does anyone know a solution for sending an email with a file attachment that
is stored as a varbinary. I know that it's possible to send files which are
stored in the file system -- but I don't like to do it in that way.
here's my code:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'cc...more >>
Help with padding! Posted by nomad at 4/20/2007 12:33:01 AM Hi,
I have a table of roughly 35000 records. These records can be
anywhere from 2 to 8 digits in length. I need to be able to check the
length of the record and if it is less than 8 characters, then padd
zero's to the beginning. eg 1001 would be 00001001. I have written
this bit of code b...more >>
I Refuse....... Posted by Bpk. Adi Wira Kusuma at 4/20/2007 12:11:29 AM I ever read a license of SQL SERVER. it 's writed that SQL SERVER limit 5
users.
what does this mean? Can SQL SERVER only be used by 5 users at the time? or
Can SQL SERVER only be used by 5 clients at the time?
thx
...more >>
How to change collate system? Posted by Bpk. Adi Wira Kusuma at 4/20/2007 12:02:18 AM How to change collate system (SQL SERVER)? without must reinstall SQL
SERVER.
If there're 2 tables have the differrent collation, So how to relation them
to be a view?
thx
...more >>
Are there any PhpMyAdmin clone for ASP.net and SQL Server? Posted by Eric Layman at 4/20/2007 12:00:00 AM Hi,
I'm not sure if this is the right place.
I understand there is a tool called MSDE web admin which is supposely a =
web based version of our fav MS SQL GUI tools. But that requires =
installation.
The reason im asking this is because currently we are doing a project in =
which client'...more >>
[newbie] Is it possible to execute SP from a SP?? Posted by Jeff at 4/20/2007 12:00:00 AM Hey
Sql Server 2005
I'm wondering if it is possible execute a stored procedure from within
another stored procedure? The example below shows a @@rowcount below the
call to a SP, will this @@rowcount show the rows effected by the TestOfExec
SP??
CREATE PROCEDURE dbo.SPtest @id int
AS
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |