I have used the below sql to get the previous month last friday. How ever when am trying to check for next month its giving 24th dec as last friday...

Through stored procedure i am selecting some values. I want to add couple of line in the end of sp to copy those values into one text file and plce...

Actually i am selecting the data in stored procedure. from stored procedure it self i need to upload the data into text file with | delimeter

Thanks

Thanks for the logic...I have got what i need, but when there is not data on particluar day i need to diplay the '0' rather than blank.

Here is the code

SELECT...

I have a table in the table datefiled is the column my data base. That column has daily date. using that i have to slect the transaction count day...

The requirement is something like this.

(Should include 2 weeks, where week ends with the most recent Friday, and Starts with Saturday. Spans 2 weeks from the last Friday down.

Also...

What is 'p' and 'Number' here in this code

I am using the below sql to get the transaction counts for last two weeks(Week ends with most recent friday)

SELECT * FROM ( SELECT ProgramName =

CASE WHEN...

I have got the expected result, but i need to display the header like Dec 18 2009, dec 17 2009.....dec 12 2009..Can you please help me to get in this...

If you run on saturday(12/19) it should like first week is 12/12 to 12/18 and second week should be 12/05-12/11.

Please let me know if this is not clear

yes..60 days of data on day wise and i am using SQL server 2005

SQL server 2005

Today is 16th Dec so i need to get the txs count day wise(i.e Oct'15 to Dec'15)

like For program1 from oct15 to Dec'15 day wise i need to display the...

I need to select the txs by Day wise

like

d1 d2 ------d60

p1 ...