|
|
|
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 Execution plan...another set of eyes please Posted by chad.mccune NO[at]SPAM gmail.com at 6/17/2007 11:47:20 PM I've been up all night writing some new codesmith templates and was
just looking over the execution plans on some of my queries and I
noticed this one was doing 3 index seeks and 1 indes scan. Does
anyone see what would be causing the index scan?
Select
[dbo].[LinkCategory].[LinkCategor...more >>
multiple fields that make up a key Posted by cris at 6/17/2007 10:06:00 PM hello,
i inserted data from a table called OLDTABLE into a brand new table called
NEWTABLE which contains 5 fields. these 5 fields concatinated together make
up a unique value. how can i ensure that once i run my insert query tomorrow
i won't get any duplicate values within the table NEWTAB...more >>
sql server programming Posted by Wendy Elizabeth at 6/17/2007 8:59:00 PM I would like to know how to automate the following two processes with excel:
1. I would like to take data that is obtained from sql server 2000 queries
results and load the detail data onto excel spreadsheets.
2. I would also like to take data that is obtained from sql server 2000
query re...more >>
Insert statement across servers (instances) Posted by Rob at 6/17/2007 3:47:32 PM I would like to create a SQL statement that inserts all columns from Table A
into Table B where the row does not already exist.
I know how to do this when the tables are on the same server, but how do you
accomplish this when the tables reside on 2 different servers ?
CREATE TABLE [dbo].[A...more >>
select into Posted by js NO[at]SPAM someone.com at 6/17/2007 2:24:07 PM Hi, I try to run the query in a store procedure below and got error
if @type = 0
select * INTO #Temp1 from tb1 Where 1= 0
else if @type = 1
select * INTO #Temp1 from tb1 Where 1 = 1
error:
There is already an object named '#Temp1' in the database.
how to fix that?
...more >>
SQL 2005 Local System Account Posted by scott at 6/17/2007 12:30:19 PM I'm running sql 2005 dev. ed. on a win xp client connected to a win 2003
server and domain. When I install sql 2005 on any of my client xp pc's, I
have always entered my domain user/password for sql services to run under.
If you go to services and open the properties and the the "Log On" tab, ...more >>
PIVOT Usage Posted by RJDev at 6/17/2007 10:51:00 AM Hi,
I am trying to create a dynamic pivot based on monthly values in a date.
The table is for invoicelines. Now i want to make a pivot for each month
from now 12 months back per item sumarising the amount sold.
Is there any one that can help me because is tried a lot of things buit it
look th...more >>
Restoring Databases with Encrypted Data to Another server Posted by yodakt at 6/17/2007 8:15:01 AM Why when restoring a databasa that contains encrypted passwords in a table
using the varbinary data type, you can't use the value.
My login table contains a password field that is a varbinary type. I
encrypted the value by using the encrypt('password') when inserting users
into this tabl...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
FakeWorkTable error Posted by andrew at 6/17/2007 6:45:00 AM Hi
When running a stored procedure (which has run successfully many times) we
are getting the error below. I can find no documentation refering to
'FakeWorkTable'. A Goole search reveals that other people have had this
error but there are no helpful replies. Does anyone know what it is or...more >>
How to update a bitwise column Posted by Sammy at 6/17/2007 6:06:01 AM Hi if I have a bit column for a PhoneNumberType using binary to represent the
values as below and need to do some updates
home = 2
Fax = 4
mobile = 8
office = 16
Not sure the logic involved. If some one just had a home number and that = 2
and now also had Fax. Would I just...more >>
Multi access in SQL Server Posted by ByB at 6/17/2007 5:38:55 AM Hello,
I am working on an Access VBA application, working in client/server
mode, with a shared SQL Server base.
I have to INSERT some data in the base, and the know what is the ID
that SQL Server associated with my data in the table. So I need to do
the following
INSERT data INTO TABL...more >>
accessing data in sql server from oracle Posted by harp at 6/17/2007 2:37:59 AM Hi
I'm using oralce toad and would like to access data in a table of sql
server from oracle
I used
select * from servername.databasename.dbo.tablename
but could not succeed.
Does any one know how I can do this?
Thanks in anticipation
...more >>
How to make a view as input??? Posted by Bpk. Adi Wira Kusuma at 6/17/2007 12:10:58 AM I have 2 table with its structure like it:
Create table T1 (
[RecID] [int] IDENTITY (1, 1) Primary Key,
Nm_P varchar(15) null
)
Create table T2 (
FID int Primary Key,
NO_PIN varchar(15) null
)
Then I make a view like it
Create view VTray1 as
Select a.RecID,...more >>
using bitwise on where condition Posted by Roy Goldhammer at 6/17/2007 12:00:00 AM Hello there
I have if statement and where condition statement with two conditions
The if and the where condition should return true if: both Condition A and
Condition B are true or false. if one of them is true and the other is false
the result is false.
it is good idea of using bitwiz...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |