Sean Lange (8/24/2012)

---

tyson.price (8/24/2012)

---

Eugene Elutin (8/24/2012)

---

Steven Willis (8/24/2012)

---

Try this:

CREATE FUNCTION dbo.svfRemoveLeftMostCharacters

(

@Source VARCHAR(1000)

,@Char CHAR(1)

)

RETURNS VARCHAR(1000)

AS

BEGIN

/* This function requires a Tally or Numbers table...

Actually, I think the following provides a better picture:

select

cast(0xD7DF6FC50A6807D31E27505A46DA7EA0 as bigint),

cast(0xD7DF6FC50A6807D31E27505A46DA7EA0 as int),

cast(0x1E27505A46DA7EA0 as bigint),

...

YSLGuru (8/24/2012)

---

I've told my IT Admin many times that we don't/can't do SQL DB backups to network shares or anything but a local drive (tape drive or hadr drive). ...

Simple, BIGINT is 8 bytes while INT is 4 bytes. Run the following code:

select

cast(0xD7DF6FC50A6807D31E27505A46DA7EA0 as bigint),

cast(0xD7DF6FC50A6807D31E27505A46DA7EA0 as int),

...

Using the server-side trace, you should also be able to capture the session connection information. See if there is any difference between the sessions, what options are on and...

tyson.price (8/24/2012)

---

Eugene Elutin (8/24/2012)

---

Steven Willis (8/24/2012)

---

Try this:

CREATE FUNCTION dbo.svfRemoveLeftMostCharacters

(

@Source VARCHAR(1000)

,@Char CHAR(1)

)

RETURNS VARCHAR(1000)

AS

BEGIN

/* This function requires a Tally or Numbers table */

/* http://www.sqlservercentral.com/articles/T-SQL/62867/...

You will notice a double standard here. The potential employer will ask for salary history from prospective employees but many refuse to tell these same people what they may...

Just a couple of questions:

Recovery model of database while index rebuild was running.

Size of database (not t-log).

Unfortunately, we can't see what you see. You haven't given us enough information to be able to help you. Based on what has been posted, I can't even...

Something like the following be helpful?

declare @TestDate datetime = getdate();

select @TestDate, dateadd(hh, 20, dateadd(dd, datediff(dd, 0, dateadd(hh, -20, @TestDate)), 0));

set @TestDate = '2012-08-24 20:00:00.000';

select @TestDate, dateadd(hh, 20, dateadd(dd, datediff(dd, 0,...

Nullified (8/23/2012)

---

A TVF is used If you want a table as an output of a function. The results can be used in a stored procedure.

Syntax:

CREATE FUNCTION [dbo].[functionname]

(

@inputvraiables Datatype

)

RETURNS...

viksch (8/23/2012)

---

Thanks Lynn! I do have a date table which serves as a calendar table and I've tried may join combinations and I still only get the two results...

Using a calendar table would work, you would use a left join from the date to your data.

I have to leave now, but if no one provides you a more...

It depends. You use them when they are appropriate. One use for them is as a parameterized view.

Arjen Krap (8/23/2012)

---

In my opinion an expression like "x years y months" isn't a date but more like the .Net type TimeSpan. So I wouldn't advice you to convert it...