Though you could certainly accomplish the desired end-result through T-SQL. Either import...

This page and others like it are...

Flo: Yep. That's why I use that one. Easy to modify for other uses besides just removing time.

I just ran tests on this:

set nocount on;

if object_id(N'tempdb..#T') is not null

drop table #T;

create table #T (

ID int identity primary key,

Date datetime,

CleanedDate datetime);

insert into #T (Date)

select top 1000000 dateadd(second, checksum(newid()),...

The speed tests I've done have found that "dateadd(day, datediff(day, 0, @Date), 0)" has been the fastest.

The way to test it is to create a table with a million or...

donato1026 (4/7/2009)

---

Like I said... Being new at this, I am not sure what the best way is to do this. I just know it runs VERY slow. A...

Try this:

ALTER PROCEDURE [dbo].[GetDiscount1]

@Username VARCHAR(255)

@ret int output

AS

SET @ret = (

SELECT Discount.DiscountAmount

FROM Discount

WHERE DiscountCode = dbo.GetUserIdFromUsername(@Username)

)

You don't use "declare" in parameters. You need to include "output" after the parameter you want...

Please don't double-post in multiple forums.

Not only is it possible, it's recommended.

create table #T (

ID int identity primary key,

XMLCol XML);

insert into #T (XMLCol)

select ' ';

insert into #T (XMLCol)

select '';

insert into #T

default values;

select *

from #T

where XMLCol is not null and cast(XMLCol as...

Either one should be pretty darn fast.

Yes. This is what's called an "Inline Table Value Function". The prior version was a "Multi-Select Table Value Function". Both are types of "User Defined Functions".

The difference...

This will give you a list of the databases that have that table:

declare @sql nvarchar(max);

select @sql = coalesce(

@sql + ' union all select ''' + name + ''' as db...

I don't believe it's possible to do Select Into across servers.

Why would you do a cross join between those two? So far as I can tell, all the joins in the original query had the same two columns in...