vinay.varaala (9/5/2012)

---

hi everyone,

when i runing below stored procedure it not returning any value

alter procedure sp_date

@dyti datetime

as

begin

select Simmons_PanelID,Reading_Date,Fuel_Level ,Fuel_Temp,Fuel_Volume from dbo.Levels

where Reading_Date=@dyti

group by...

I am trying to be good, but sometimes I would really like to shoot that high horse.

jrichards54 (9/4/2012)

---

I have mentioned that I cannot start the SQL Server as I have no SSMO in my Start Menu. It was there on the second install but has dissappeared...

P Jones (8/31/2012)

---

This was done by the base exchange and other stores when I stationed in England many years ago. We were in fact told NOT to bring US pennies...

Not really an issue as my phone stays in my bag until the game is over.

GuruGPrasad (9/4/2012)

---

Thanks Lynn Pettis

Max column length may vary.

And your code

select

country + replicate(' ', 56 - len(country)) + currency_code from dbo.currency order by country;

does not...

FYI, I posted the output I generated into Notepad and it looks good, the currency codes are all lined up nicely.

Two things. One, your code would simply look like this:

select

country + replicate(' ', 56 - len(country)) + currency_code from dbo.currency order by country;

Two, be sure...

GuruGPrasad (9/4/2012)

---

I need to display country and currency_code in a single column.

select country + space(46-Len(country)) + CONVERT(varchar(max), currency_code ) from currency order by country...

roryp 96873 (9/4/2012)

---

Lynn Pettis (9/4/2012)

---

Okay, some time tonight I will definately have to check out my team. Let's see, soccer game at 6:00 PM, hmmm, looks like some time...

GuruGPrasad (9/4/2012)

---

Table Script

CREATE TABLE [dbo].[currency](

[currency_code] [varchar](3) NOT NULL,

[country] [varchar](256) NOT NULL,

[currency_name] [varchar](256) NULL,

[active] [int] NULL,

CONSTRAINT [PK_currency] PRIMARY KEY CLUSTERED

(

[currency_code] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

Here is my problem. As good as your description of the process, I can't see what you are trying to accomplish. You should post the DDL for the...

Okay, some time tonight I will definately have to check out my team. Let's see, soccer game at 6:00 PM, hmmm, looks like some time around 9:00 PM MT...

The problem we have, at least from my point of view, is that we still don't know what you mean by things aren't working. It appears that you have...

Just...