polkadot (5/11/2012)

---

OK, thank you Koen.

Lynn, Koen reiterated exactly what I need. I like the use of the word form. I didn't use it but it is...

Thomas Stringer (5/11/2012)

---

Try this:

CREATE PROC usp_splitoutputfile

@tablename VARCHAR(200), @volume int,@Splits INT

AS

BEGIN

IF @Splits = 1

BEGIN

...

Two things. I can't read the image that is supposed to be your expected results. Second, how about putting that into a separate table that we could actually...

kirkm 55368 (5/11/2012)

---

It was that link Lynn, and fair enough too if that's what's needed. Its just the rigid structure for questions, and request to format data as per examples...

Charmer (5/11/2012)

---

ChrisM@Work (5/11/2012)

---

Charmer (5/11/2012)

---

Hi Friends,

I am here to discuss the general topics of index....

One of my colleague says if we add filtering(where statement) , it will affect index. Is that...

Unless you plan on posting code, not sure...

Personally, I'd concentrate on making the stored procedure more efficient so that it got the job done faster rather than trying to figure out how to send back status messages...

By the way, never used MARS, so can't answer any questions about it.

Only suggestion I can give you:

http://msdn.microsoft.com/en-us/library/ms131686(v=sql.100).aspx

bommaka.nagarjun (5/11/2012)

---

I mean to say all the dates that are there in the date filed should be shifted by some number of days but should not be greater than current...

bommaka.nagarjun (5/11/2012)

---

I mean to say all the dates that are there in the date filed should be shifted by some number of days but should not be greater than current...

Unfortunately, can't give you much more as no one here can see what you see. Unless you show us what you are working with and how you have been...

If the xp your are executing is a litespeed xp, you may get better answers on a Quest forum than here. I have very limited exposure to litespeed so...

First of all you should store your dates as dates. SQL Server 2008 even has a date data type, use it.

bommaka.nagarjun (5/11/2012)

---

CREATE TABLE [dbo].[faxes] (

[ID] int NOT NULL,

[Fax_Date] datetime NULL,

[Audit_ID] int NULL)

ON [PRIMARY];

GO

Insert into faxes values (1,'6/5/2012',1000)

Insert into faxes values (2,'6/25/2011',1000)

Insert into faxes values (3,'8/15/2010',1000)

Insert into faxes values (4,'9/25/2009',1000)

Insert...