Did you get an error about ANSI padding? Not sure why but when I did

SET ANSI_PADDING ON

SELECT *

FROM students

WHERE experimentchemical.exist('/ATOM/Source/Identity/Location="SYD"') = 1 it seems to work. Location is...

I am not sure but I think the answer is no.

I read this in the 70-433 exam prep book

In SQL Server Enterprise Edition, query substitution goes one step further...

Jumping on the bandwagon: I've read "Microsoft SQL Server 2008 T-SQL Fundamentals" by Itzik. It is one of the best SQL books I've ever read. Even though the title says...

You are very welcome.

For your question see this website, which has some of the best info on SQL date functions.

http://www.sql-server-helper.com/functions/index.aspx

More specifically, what you would like to do is related to...

Not sure I understand the problem. Are you looking for savings between Day-14 and Day-7?

select datepart(yyyy,startup_Time) as 'year',

subpolicy_name as 'subpolicy',

max(datename(wk,startup_Time)) as 'week',

sum(savings) as 'weekly_savings'

from #savingstemp

WHERE startup_Time between dateadd(day,datediff(day,0,GetDate())-...

You are welcome. Let me know how it turns out.

You can BCP that to a CSV file and add it to your email as an attachment.

Or, rewrite it with SSIS and it will do everything you wanted.

Couldn't you just use a join?select

O.EmpNo as Eno

ISNULL(O.FirstName, 'N/A'),

ISNULL(O.LastName, 'N/A'), --what if they have different last name?

ISNULL(O.processdate, 'N/A'),

ISNULL(O.deadlinedate, 'N/A'),

ISNULL(T.addresss1 , 'N/A')

...

FROM TableOne O INNER JOIN TableTwo...

Thanks Paul and Gsquared.

I am not sure I am communicating the problem clearly. It is a Insert..Select...Order By and not a Select Into.

I am running the sameselect statment with...

Thanks for the reply. That makes sense. I am not so much want to "force" a certian order as want to figure out why the same exact query seems to...

I think the issue is your inner N table. Since it only goes from 0 to 6, you end the series with @ste+6, which is 3/24/2010 (which happens to be...

Well, they say only death and taxes are certain, I think we need to add "bad table design will cause problems!" Jeff pointed out earlier that "Also the way the...

3rd time a charm? I've CAST the float to decimal first before casting to Varchar.

Create FUNCTION [dbo].[NewFormatFloat3](@dIn float(53),@p int)

RETURNS varchar(100)

AS

begin

declare @ReturnString Varchar(100)

declare @LeftString varchar(50)

select @LeftString=convert(varchar, convert(money, (cast(@dIn...

You are welcome.

Note the parameter of the function is Decimal (38,13), so when you pass a float to it, it go through an implicit coversion and the accuracy is lost...

You are welcome! Glad it wasn't too hard.