Complicated? CTE's with Window (sometimes called Analytical) functions do the exact opposite. They un-complicate queries. It would be well worth your time to learn about ROW_NUMBER, RANK, NTILE, and a...

Hi

Thanks for the query, its returning what i want, but i have never used CTE and have no knowledge of it, guess its time to learn.

is there no easy way...

Hi

this is what im trying to do;

I have a sql server as follow

Windows server 2003

SQL server instance 2000

32 bit i presume

i open import and export data --> on destination i...

Hi guys

Thank you so much for the prompt help, I’m sorted out now.

Kingston Dhasian - the easiest way: Took 00:02:10 to execute

imex – I’m not really good with CTE, I...

Eugene Elutin (9/11/2012)

---

One of the column you return in one of your "selects" (I think it's a first one

) is of smalldatetime data type (we don't know which column exactly,...

Hi there,

The image you posted is not opopeningp dude.

Regards,

okbangas (6/13/2012)

---

Just for the record, this issue can show up very quickly if a user database and tempdb have different collations, as all temp tables are created in tempdb and...

anthony.green (6/13/2012)

---

You will need to drop and rebuild all indexes, primary keys etc to enforce the new collation.

Or you could add COLLATE database_default to then end of any string comparisions

SELECT...

michael vessey (5/21/2012)

---

there are 2 ways

right click on the database and choose properties and then in one of the screens there will be a recovery mode box (i don't...

michael vessey (5/21/2012)

---

looking at that you definatly have a couple of DB that are in simple (WRHL for one) and that will cause that statement to potentially fail..

i think you...

Steve that I wouldn't know Honestly, unless you tell me how to see that, but this is the...

Hi, yes its a SQL 2000

and after running that sp_helpdb this is what i got in return and im now lost

No permission to access database 'PhoenixCBL_Restore'.

name ...

Ok heres the initial...

John, since i got it working.... i will try to reverse the process and regenerate the same error and post it here lets say tomorrow....

thanks anyways

John this is the first error

CREATE DATABASE [BGPhoenix] ON PRIMARY

( NAME = N'msphxx_data001', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Phoenix.mdf' , SIZE = 25853440KB , MAXSIZE = UNLIMITED, FILEGROWTH...