http://www.apexsql.com

have a free refactor add in for SSMS......you will need to download all the tools (130Mb)

but just install the refactor

has many options

ps...I have no involvement with Apexsql.

sivag (7/5/2012)

---

J Livingston SQL your proc was working fine and i am not finding exact member level of...

sivag (7/3/2012)

---

hi

J Livingston

sorry for the twodays i was admitted in a hospital due to an injury on my right leg now only i...

Hi Sivag

would be interested to know if and how you manged to resolve your problem?

regards

a colloquial meaning, maybe?

no offence where where I come from...though...

is this any help?

SELECT s.ACCOUNT,

s.ORGANIZATION,

...

is this anywhere near what you want?

CREATE TABLE [dbo].[tblMembersRelation](

[MembersRelationID] [int] NOT NULL,

[MemberID] [int] NULL,

[ParentID] [int] NULL,

[Level] [int] NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[tblProductInfo](

[ProductId] [int] NOT NULL,

[ProjectId] [int] NOT NULL,

[SaleMemberId] [int] NULL,

[SaleClosedPrice]...

ok...

GROUP BY StudentName

HAVING (MAX(CASE WHEN Question = 5 THEN Answer ELSE '' END) = 'help')

HAVING (StudentName like 'Stu%')

try this approach

SELECT @str1 = CASE

WHEN ( Substring(@cString, @x, 1) ) BETWEEN 97...

maybe worth a look..??

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/4b7fe6f4-abf9-46ce-be5c-d655f1f87fbb

ReginaR1975 (6/24/2012)

---

I thought COALESCE had 2 parameters. http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=zfj3ym55ovoqokutkrrawu55

COALESCE ( expression [ ,...n ] )

I don't understand this example. It has 3 parameters.

SELECT CAST(COALESCE(hourly_wage * 40 * 52,

...

not really sure...

WebTechie38 (6/18/2012)

---

Oh My Goodness!!!!!!!!!!!!!

Finally success.

I had to create the profile name on the server that I am using with the connection manager. I had previously created a profile on...

WebTechie38 (6/18/2012)

---

Well thank you for responding. But like a lot of the things I am seeing, there is one or two things that aren't explained.

I ran the script, but...