mmmm.. the date formating issue again. i once had many nightmares sometime back about this formating issue.

i ended up using the format suggested by mkeast.

INSERT #temp(id, dt) VALUES (1, '20060717')...

if for example,they are word documents that you want to upload to a website, you can store them in a folder and create a reference in the database. this would...

i have never seen this one, but i will try to do it. oops!!!which reporting tool are you using?

>why would you want to break the referential integrity of the db introduce triggers that have to be maintained and

-in no way does using triggers break the referential integrity....

i have a default instance on 2000, and a named instance on 2005, the service pack install did not have any problems picking the 2005 named instance.

during the installation you...

for my suggestion the key values wouldn't overlap because they would be EXCLUSIVE OR [XOR]

which is similar in concept to what the other guys are suggesting with the only difference...

you can use the bcp tool or the ssis import export wizard.

i think if the Dept ID are XOR between the tables then you can use the union of the two tables with a trigger on the referencing table

the reason why it does not work is because when you have @myIDParam = 019988, 019999

the @myIDParam is no longer a valid expression or subquery. please refer to your bol...

you can use a table variable

DECLARE @RowCount BIGINT --tracker

DECLARE @RecCount BIGINT --record counter

Declare @bill_ID bigint

DECLARE @tbl TABLE

(

[ref] [BIGINT] IDENTITY (1, 1) PRIMARY KEY NOT NULL...

depending on the reporting services you are using try

C:\WINDOWS\Microsoft.NET\Framework\\aspnet_regiis -i

where = v1.1.4322 or v2.0.50727

yap, i think john's suggestion should work for you

oops raq, i might have to eat my words.

please goto

http://blogs.msdn.com/astebner/archive/2006/03/19/555326.aspx#605285

and

http://blogs.msdn.com/astebner/archive/2006/05/29/610435.aspx

i am trying to extract the files in the .exe file using winrar and see if i...

yes i hear you. but i think sql express was maybe aimed at the hobbist and entry level developers etc to play around with.

i am saying that because they ms...

I haven't done it, but i am thinking why would microsoft give you the functionality for an express edition?