Thanks, i havent heard that term before...

The query works fine for me and inserts two rows into the table.

I think anyomous blocks are an ORACLE term, i have...

you dont have to enable it, TRY should turn blue once you have typed it in SMSS, unless you are using 2k then it won't work...

it parses fine for me,

is this the whole query?

Create the procedure that will update the table,

Under SQL server Agent in Object Explorer, right-click jobs and click new job...

follow the setup in here,

You will need to exec your...

You can do this by using the PIVOT function

Check BOL for syntax.

Kimball University is running this course in October which looks very good. They are considerd the world experts in DW/BI .

http://www.q4k.com/pages/special.php?id=78

Fair enough, The only place I have been to in the US is LA where everyone seemed to drive, though the traffic was so bad they didn't seem...

I guess I should let the wife know we still have it better than others when it comes to gas prices. What you paid works out to approx 8.33...

Either replace the (') with doubles ('')

or use (" ")

set QUOTED_IDENTIFIER OFF

select "Reji's"

Nice Question !!

You can script your tables from SQL management studio, right click on the database and click create to. then run this script on your other database.

But the point...

varsha.sinyal (7/7/2008)

---

Hello

Friends

new to sqlservercentral

i want to connect my web application to sql express come with vs 2005 but don't know the user name and password then what is the...

This is not neccesarily true, depending on how...

from BOL the syntax for openXML is

OPENXML( idoc int [ in] , rowpattern nvarchar [ in ] , [ flags byte [ in ] ] )

the first value idoc should...