|
|
|
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 Pivot table Posted by Viji at 11/19/2006 11:13:22 PM We want to create view which will pivot rows into columns. The number of =
columns in the pivoted table is dynamic. In the below example we want to =
create a view MY_VIEW which will have columns where RULE_FILTER is set =
to Y in E_CRIT table. Then using the view we should be able to select =
v...more >>
About split functions Posted by Sirisha at 11/19/2006 10:07:43 PM I want a SqlQuery Split the Content into parts
In my Table:Employeemails
MailId Name Content
Subject
1
Sirisha info@test.com;something@test.com;testing@test.com
Spliting
2 Chaya info1@test.com;something@test.com;testing@test.com
Spl...more >>
Data types Posted by Arjen at 11/19/2006 9:11:24 PM Hi,
I was just wondering what are the best data types to use.
Now I have used for an internet database the nvarchar datatype. Is this wise
to do for internet databases? I'm onlyse using the English, Dutch and German
language.
Other question. Now I need to change the data type of a colum...more >>
Error 22029 Posted by Roy Goldhammer at 11/19/2006 8:08:31 PM Hello there
I've got this error when i try to run job of save transaction log file.
For other issues i've understand that it is an error of trying to save log
file while users are using the db.
there is no lock or any active on this database. when i use the detach
window there is no act...more >>
table is locked? Posted by Roy Goldhammer at 11/19/2006 7:29:52 PM Hello there
I have table that it takes two mutch time to do simple select * from
<tablename>
how can i know if this table is lock or in process?
...more >>
not USING SYSTEM ACCOUNT Posted by Roy Goldhammer at 11/19/2006 7:27:35 PM Hello there
I need to install the sql mail on my server.
For all the guidence i gave, the problem is that: sql server and sql server
agent are using system account, which can't be use when i want to use mail
service.
In order to fix it i need to work not on system account. If i was the ...more >>
temp tables in stored procedures Posted by Jeff Reese at 11/19/2006 5:27:01 PM I'm trying to use temp tables in a stored procedure but am getting an error.
Is it possible to use temp tables in a stored procedure?
Below is a simple example and the error I receive:
--*****************************
create proc dbo.usp_test
as
select top 10 *
into #temp
from some_ta...more >>
Inserting into table on linked server preserving IDENTITY values Posted by agodfried at 11/19/2006 5:14:01 PM I need to insert rows into a linked server table while preserving the
IDENTITY values. I have read threads on this, but have not seen a solution
that works. How can I Set Identity_Insert to ON on the linked server?
--
A. Godfried...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
bulk insert and log file size Posted by paul at 11/19/2006 3:46:02 PM high level description:
bulk insert 500MB in one batch into a table w/ 3 nonclustered indexes and
then look at the size of the db1.mdf and db1.ldf files - in this test the mdf
is reasonable but the ldf is 5GB or 10x the amount of data - why is this?
steps for the test:
1. create a table...more >>
Workdays and shifts that cross midnight Posted by Larry Killen at 11/19/2006 3:40:20 PM MS/SQL 2000
Delphi 2006 Ent
This should not be hard but it is kicking my butt right now. And I swear I
have done this before.
I am righting a middle-ware app that retrieves data from a PLC controller
and writes it to the database.
The data has :
Line
Group
Weight
DateTime
and other...more >>
SQL HELP Posted by Alejandro at 11/19/2006 2:44:23 PM Hi, I have this select
SELECT CEDULA, COUNT(CEDULA) AS CONT FROM MATRIX_ODONTOGRAMA GROUP BY
CEDULA HAVING CONT = 3
this return
111111, 3
222222, 3
333333, 3
444444, 3
555555, 5
AND THIS:
SELECT matrix_odontograma.cedula as Cedula, primer_nombre as Nombre,
primer_apellido as Ape...more >>
date time function third friday of the month Posted by jaylou at 11/19/2006 8:30:02 AM Hi all,
I have an event table that has a reoccurrence column. Some of the events
have a reoccurrence of every third Friday of the month. I need to create a
function or a Stored Proc to look at the reoccurrence flag and if the last
date has past, I need to update the event date to the next t...more >>
Slow Query Posted by Sammy at 11/19/2006 7:18:01 AM Hi
I have a query that runs slowly and at other times it is fine on a Sql
Server. I think its a network problem or network card. I was looking at some
network counters to monior from perfmon and looked at a few, but the Current
Bandwidth counter on my local machine shows as 10000000, I t...more >>
connection problem Posted by Roy Goldhammer at 11/19/2006 12:00:00 AM hello there
I have problem that some of my tables doesn't work
when i try to do simple select * from <tablename> i get the error: ODBC: Msg
0, Level 19, State 1
SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating thi...more >>
using sql mail Posted by Roy Goldhammer at 11/19/2006 12:00:00 AM Hello there
I have two server on my work: mailserver and db server where sql is in.
i would like to use sql mail for sending data and i can't get sql profile.
i've installed outlook on the DB server and connect it to exchange server on
mailServer.
what i need now to do in order to use ...more >>
suspect databases Posted by gordon at 11/19/2006 12:00:00 AM Hi
I am using sql server 2005 and i have noticed that two databases are
'suspect'.
They are reportServer and AdventureWorksDW.
I dont do much with either of these at the moment as I am still learning SQL
server 2005, but I tried to fix the problems - unsuccessfull.
What I did was I t...more >>
switching off ability to run multiple queries in SQL Posted by Captain Flack at 11/19/2006 12:00:00 AM Hi
In MS SQL, you run multiple queries with the same database call,
separating them with a semicolon, e.g.
DELETE * FROM Table1; DELETE FROM Table2
In Access and MySQL (as far as I can tell) this is not supported.
Now I know that we should all be using sprocs rather than sending SQL
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |