feodon (2/12/2009)

---

the error now is :

Msg 4104, Level 16, State 1, Procedure SearchFlightByCities, Line 41

The multi-part identifier "fff.airline_id" could not be bound.

But I'm baffled about it ,

could anyone alter this...

DECLARE @startingFrom nchar(33), @destination nchar(33), @RowNum int

SELECT @startingFrom = [YOUR VALUE IN HERE], @destination = [YOUR VALUE IN HERE]

DECLARE @FlightsLook TABLE

( ...

GilaMonster (2/12/2009)

---

Eeep..

http://www.sqlservercentral.com/Forums/FindPost655667.aspx

I want to do a PhD in the area of database optimisers. Can anyone suggest a good topic?

Gees, it took me months of reading to decide on an appropriate...

Yes it is, but...

In addition to the above, the table alias [fff] has not been assigned in this statement:

-- procedure

SELECT * FROM @FlightsLook

JOIN Airlines aaa ON fff.airline_id...

Santhosh (2/12/2009)

---

Hi

In Linked Server(Access database)

Can we know which columns are having ntext data type?

(when i went through the sproc sp_columns_ex i came to know that

MEMO data type of...

Yes, and you can easily do that...

This should put you on the right track...

IF OBJECT_ID('tempdb..#Worksheets') IS NOT NULL

DROP TABLE #Worksheets

CREATE TABLE #Worksheets (TABLE_CAT varchar(30), TABLE_SCHEM VARCHAR(30), TABLE_NAME VARCHAR(50), TABLE_TYPE VARCHAR(20), REMARKS VARCHAR(30))

INSERT INTO #Worksheets

EXEC sp_tables_ex @ServerName

carriem (2/11/2009)

---

I'm new to all this and I'm just beginning to learn how to create scripts for reports using SQL and Crystal reports. I found it interesting how some...

Anybody seen my...

See here.

It would also be good practice to examine the query to establish if it can be optimised.

Sander A. (2/9/2009)

---

Interesting solution. But i don't see this working in my situation. In real world the columns of the statistics table and the kpi table are very different. So...

Grant Fritchey (2/6/2009)

---

Oh there are individuals, but the culture seems different. The Air Force bases were always so clean & orderly & mannered where as, except for boot camp &...

GSquared (2/6/2009)

---

Chris Morris (2/6/2009)

---

GSquared (2/6/2009)

---

Iay amay uenflay inay igpay atlinay. And speak/write attrocious Spanish. My French is worse than my Spanish. My English is abysmal, but I...

How about some sample data with that, Rob? 😉