I'd take a wild guess and say: add up the value of all your machines, servers and printers.

if you assume that a machine should last 5 years before it gets...

[font="Courier New"]

SELECT CONVERT(DATETIME,'20080204') --converts cleanly, and displays as '2008-02-04 00:00:00.000'

SELECT CONVERT(VARCHAR,CONVERT(DATETIME,'20080204'),101) --the desired format '02/04/2008'[/font]

Hi Alex;

Wow if you'd provided that table definition up front, we wouldn't have gone thru two pages of possible solutions and misunderstandings;

Help us help you! when you post in...

I agree with Jeff on the different execution plans...

take this part for example:

CREATE PROC [dbo].[s4sp_IFrames_Search]

@AffiliateId int,

@Zip varchar(12),

@curriculumid int = 0,

@ExcludeClientID int = 0

because you've assigned default values, the execution...

What have you tried so far? what is the real, full CREATE statement for dbo.Alpha? is there a primary key?

how do you know what row either "T" is ? there's...

here is a delete example. hope that helps, without more details it's tough.

SET ROWCOUNT 50000

WHILE 1=1

BEGIN

DELETE FROM dbo.myTable ...

here's a situation where I've expected a trigger to rollback because I raised an error.

http://www.sqlservercentral.com/Forums/Topic622424-338-1.aspx

I've also seen triggers still commit even though a Level 14 error was raised by...

you'll need to explain exactly what you want.

how can you have data BASED on a count if you don't USE a count?

give us the REAL table with sample data, and...

you need to select from the master table, and include the group as a sub select there somewhere, ie

SELECT *

FROM SOMETABLE

INNER...

Here's a detailed explanation i saved from an MS blog a while back:

quote:

--------------------------------------------------------------------------------

The reason for the performance difference stems from a feature called

"parameter sniffing". Consider a stored proc defined...

makjain (2/7/2009)

---

Then too i have 1 question if THEY provide me username and password for sql database then how my web page will work as they have windows authentication.

Will i...

If it's not your own server, for example if it is going to be hosted at GoDaddy or some other host, THEY will give you the user name and password...

you don't need a trigger for this...you could handle it automatically by making status a calculated field instead of a bit you have to update:

[font="Courier New"]CREATE TABLE TEST(

    SID INT IDENTITY...

i've got a stored proc i made that i named sp_getDDL, which trolls thru the table definition and it's columns and builds the script for the table; it's probably...

just change to a temp table, no problem:

CREATE TABLE #LinkedServers (

...