Viewing 15 posts - 1 through 15 (of 23 total)
Thanks every body I solved my problem. Here is the solution.
I am really grateful to every body for help and time
ALTER PROCEDURE [dbo].[AdminSelectMovie]
@Movies VARCHAR(20), --For where clause. It can...
November 23, 2009 at 11:46 pm
I know it can be done using simple stored procedure using IF condition but I am just trying to play with dynamic sql and I was trying to implement this...
November 23, 2009 at 10:36 pm
I added quote in the query as below. But now it gives following error
-----------------------------------------------------
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation...
November 23, 2009 at 10:29 pm
column name
that can be Title or MovieID
November 23, 2009 at 5:42 pm
Hi thanks for looking I solved my problem using FREETEXT.
Solution is given below
@Query VARCHAR(50)
AS
SELECT Mname
FROM Movies1
WHERE FREETEXT(descript,@Query)
Thanks again.
November 18, 2009 at 9:59 pm
Thanks it works
October 2, 2009 at 10:32 am
Thank you very much for your reply, I got your idea. I didn't knew about the disadvantage of using wild card till today.
So this has been good learning step...
August 17, 2009 at 8:48 pm
Let us say we have a following table
CREATE TABLE Temp1 (
Aa varchar(10),
Bb varchar(10),
Cc varchar(10),
Dd varchar(10),
Ee varchar(10),
Ff varchar(10),
Gg varchar(10),
Hh varchar(10)
)
Now let us insert some thing in table so
INSERT INTO Temp1 VALUES...
August 17, 2009 at 3:20 pm
I don't want to use SSMS. I want a query because I want to use it not only in MSSQL 2005, but may be in My SQL and Oracle too....
August 17, 2009 at 12:37 pm
Thanks you were right.
I never thought about that.
Thanks again.
June 17, 2009 at 9:54 pm
Thanks for viewing. I have figured it out, but with additional work.
Solution should be some what like this.
SELECT fname, lname, speed,acc, tyre
FROM temp
GROUP BY fname, lname, speed,acc, tyre
It will return...
June 17, 2009 at 4:40 pm
Thank you very much I think I can figure it out how to change the job logs.
I have access to SQL 2008 but I am not sure all will work...
April 13, 2009 at 12:12 pm
After running SELECT @@VERSION Query I got the following result.
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000...
April 13, 2009 at 11:54 am
I am pretty sure it is MS SQL 2005 and and I tried to edit the jobs but there was nothing to edit.
April 13, 2009 at 11:41 am
Viewing 15 posts - 1 through 15 (of 23 total)