dphillips (8/25/2008)

---

Aye, but there is another way. The set of data you are providing to the pivot, can be forced to populate zeros or empty strings as the case...

I'm off to bed just now... but I have a suggestion for you... start your own thread for this problem. It'll get more...

Ummmm.... never trust the "cost" of a batch in the...

DECLARE @Table TABLE(TimeNumber INT)

INSERT INTO @Table

SELECT '131000'

UNION

SELECT '220000'

UNION

SELECT '230000'

...

... and, if that's not the right answer, then tell us exactly what you want by giving us an example of the inputs provided and a printout of what you'd...

Mukti (8/22/2008)

---

If you are trying to do this in T-Sql then create a function that will return the desired string. Here is the code.

CREATE Function DaysBetweenDates

(

@FromDate smalldatetime,

@ToDate smalldatetime

)

RETURNS varchar(4000)

AS

BEGIN

DECLARE

@DaysInBetween varchar(4000)

SET...

You bet, Mishaluba! Thanks for the compliment! 🙂

LMAO! You must love them almost as much as me! 😉

Nuts (8/24/2008)

---

Hi

I had to import a txt file into sql server . I have attached the sample file for your reference.

It would be really good to know how to...

By the way... could you post a copy of the code that fixed your parameter sniffing problem? Thanks...

Oh Yeah! I forgot about that, Carl! Parameter sniffing can indeed cause these kinds of problems.

Sai,

Once you get the intial archive done, how many rows would need to be archived on a daily basis? Also, please post the CREATE TABLE statement for the table...

Based on the title of this thread,...

I agree... indexes won't fix the problems associated with accidental cross joins, triangular joins, or the RBAR associated with Cursors and/or While loops especially those in a UDF. Some...

By the way... DBCC IndexDefrag will allow the indexes to still be used while the index is in the process of defragging where DBCC DBReIndex will not. The big...