(SQL 2000 SP4) We are looking to solve a problem we run into somewhat
regularly where we need to get Detail Records into a special format for
reporting.
Traditionally we have used the middle tier business code to traverse the

sql server 2005
I have a join problem in this select:
select id, field1, field2, (select sum(prizes) from product where id =
t.id ) as prices

I have a table with a colum that is a datetime type.
I want to be able to select from this table, and record that is equal to a
data only, such as today or yesterday.
The problem I have is that the time part of the datatime is causing a

I am trying to catch someout put from sqlcmd in CSV format. Its kind
of going will apart from one of the columns is a free text column
(varchar ?) and has line break / carriage return and this is wrecking
the CSV output file .. or more correctly .. Excel is having issues

I am using:
exec sp_configure ‘blocked process threshold’, 2
in conjunction with Profiler "Blocked process report" event
but the reports always look like this:

How do I check a db connection is in use or not ?  I am not using any connection pool mechanism.  I have method in a class which returns the connection whenever a connection requested in Business layer.  Whether to return the existing connection or close the existing connection ...

I'm using SQL Server Express 2008. I was modifying an existing table in
"Design" mode in SQL Server Management Studio. When I tried to move a field
from its location to another one -- just trying to change the order of fields
within the table -- I got "Saving changes not ...

I'm trying to connect to an MSSQL server with an account I created
with "Microsoft SQL Server
Management Studio Express" and am having some difficulty.  The account
uses SQL Server authentication as opposed to Windows authentication

Hi Business Associates,
Greetings!!
I am Subbaraju,  working as a TEst Lead with leading MNC at Hyd. I
have 12+ years of Faculty exp and 6+ years of Software testing. I am

I have table of 75GB and when created the below indexes it actually doublled
the size of the database. The below is the code how I created the indexes,
and also shrinked the database and it got to be to 150GB for now. The log
file is only 1 mb. I did not finish to create all ...

I would like to know if it would be possible to compose a SELECT
statement where the calculation of a column of the current row could
be based on a column from the previous row, without having the need to
loop through each record in a temp table or cursor?

I am new to Linked Server Concept in 2005. I am getting the following
error while try to connect linked Server.
--Error Message
Msg 17, Level 16, State 1, Line 1

Hi!I have a statement as bellow which runs perfectly in SSMS but produces an
error (must declare variable @varname) in VB.NET and also when I try to
create a stored procedure. What could be the reason? Any help would be
greatly appreciated.--THIS RUNS GOOD IN SSMS DECLARE ...

I have a small problem with the insert.
My Table has an Identity-Columne (Seed=1, Step = 1). Now I want to insert a
row with the ID 0. Is that possible without changing the Table Structure?
I have try it with

The table is as follows:
[Item Description] varchar,
Vasche datetime,
Imballo  datetime,