In SQL Server 2000, I have a curious situation where a stored
procedure containing only a single Select statement is encountering a
deadlock error ("Transaction (Process ID 616) was deadlocked on lock
resources with another process and has been chosen as the deadlock

I have a table I am using as shown below
Account    Period    PeriodBal
60001    0    365.88
60001    1    348.82

I am using sql server and am very stuck on combining results from
multiple tables in one row.
I have multiple tables containing different information on dogs and I
want one row per breed holding all of the information I need.  I have

Good Afternoon,
--SUMMARY--
There was an interesting article posted at
http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx. This

is it possible to automate SQL Server 2005,
I'd like to open query builder from the c++ code.
thanks

hello ,
actually these are 2 questions
system = SQL 2005
1. how can i write a mechanism that writes a value to a database when a

In my real code I use a varchar(max) variable to append problem
messages for an error report. Without
this error tracking my stored proc runs in 10 sec. With varchar(max)
handling the proc returns after 14 min !!

I have been getting error when I tried to input data using a stored procedure.
Currently, I have a table that set up that allows null for this column
called "nBidAmt" but it has no default value.
I do have a SQL statement in ASP as follows:

xp_cmdshell rows are returned as nvarchar(255).
Is there any way to overcome this 255 limitation?
Regards,

I have worked on various systems where there are multiple customers and the
system is configured such that for each customer there is a separate
database. I have also worked on systems where there are multiple customers
and only one database.

Thanks if you can help. I want to determine if a date is the day after the
last business day of a month. Given my sample data '9/1/2007' and
'9/29/2007' would qualify
IF Exists

I have a question regarding update and truncate. In my company, we have
multithread application. In stored procedure, we have a couple of statement,
first truncate a table, then insert and update. we didn't put begin tran and
commit statement there. Let's say two thread access ...

Not sure if this is the proper newsgroup, but here it goes...
We have a view (large, accessing lots of tables) which for some reason is running fine
when called from the Query Analyzer - returning within a couple of seconds - but times out
when executed from our application. It is ...

I have a Sales cube and I want to be able to display Products and the
Price at which they were purchased in a given period. I have a
Product
dimension while Price is a measure in my Sales Fact Table. Is there a

Given the following tables:
Refuel
CarId OdometerReading LitersGas
1    1245    55.25