Viewing 15 posts - 1,876 through 1,890 (of 2,452 total)
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.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 7, 2012 at 4:49 am
sivag (7/5/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 5, 2012 at 12:04 pm
sivag (7/3/2012)
J Livingston
sorry for the twodays i was admitted in a hospital due to an injury on my right leg now only i...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 4, 2012 at 11:49 am
Hi Sivag
would be interested to know if and how you manged to resolve your problem?
regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 3, 2012 at 2:19 pm
Jeff Moden (7/1/2012)
sh3llm4n (6/30/2012)
Thanks alot dudes...😛
It works as good as past...
Heh... "dudes". Not a compliment where I come from. 😉
a colloquial meaning, maybe?
no offence where where I come from...though...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2012 at 10:44 am
is this any help?
SELECT s.ACCOUNT,
s.ORGANIZATION,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2012 at 10:34 am
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]...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2012 at 8:41 am
ok...
GROUP BY StudentName
HAVING (MAX(CASE WHEN Question = 5 THEN Answer ELSE '' END) = 'help')
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2012 at 5:30 am
santa326 (6/30/2012)
Hi,How do i query the above result by using where clause?..
i want to use where Student Name like "Stu%"
regards
Ravi T
HAVING (StudentName like 'Stu%')
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2012 at 5:10 am
try this approach
SELECT @str1 = CASE
WHEN ( Substring(@cString, @x, 1) ) BETWEEN 97...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2012 at 2:24 am
maybe worth a look..??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2012 at 11:00 am
ReginaR1975 (6/24/2012)
COALESCE ( expression [ ,...n ] )
I don't understand this example. It has 3 parameters.
SELECT CAST(COALESCE(hourly_wage * 40 * 52,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2012 at 12:38 pm
so.eslami (6/24/2012)
i use this command for giving ranking of user but i give errorselect Score, (DENSE_RANK() OVER ( order by Score desc)) AS Ranking
FROM cuscore
ORDER BY Ranking
not really sure...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2012 at 11:49 am
WebTechie38 (6/18/2012)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 18, 2012 at 1:01 pm
WebTechie38 (6/18/2012)
I ran the script, but...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 18, 2012 at 12:21 pm
Viewing 15 posts - 1,876 through 1,890 (of 2,452 total)