since you are using access, those are two different queries;

the GO statement is valid for SQL Server;

each of the two queries needs to be saved separately...been a while since i...

the method of entry into a table wouldn't really...

moving the data more complex than it need to...

i don't see a need to move the data, other than it makes "sense" to someone (the data is different...

i've done this on the .NET side of things, after i've already loaded the data into a .NET DataTable.

from there, it's fairly easy to format the data into a string...

Duran (6/21/2011)

---

Hello,

I'd imagine that somebody would have come across this before, I am trying to install SQL 2005 R2 (downloaded from MSDN) to install in the D drive, I specify...

nice job on posting details so we can follow along...but is there a question in there somewhere? is this related to compact edition(the forum you posted) or a specific version...

ok first the concept:

you can use DATADD and DATEDIFF to fiddle with dates, keeping everything in the proper datetime variable.

test this to understand the concept:

select

--midnight of TODAY.

DATEADD(dd, DATEDIFF(dd,0,getdate()), 0),

--older...

i seem to remember that the biniaries that are the core srvice and stuff must be installed on the %systemdrive%, with no choice in the matter...you can move the databases,...

if you cannot use the builtin getdate() function for the current date and time,

you can stick the results into a temp table, and insert from there as well.

CREATE TABLE...

yes, opc.three's comment is the key; i testest it to make sure...for me i created a suite of tables and then 4 different functions and procs, all with GO statements...

see opc.three's post from the thread below;

i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i know better:

http://www.sqlservercentral.com/Forums/Topic1125836-391-1.aspx#bm1125844

the hanging of the app from the command line is that messagebox dialog, guaranteed;

I hate to say this, but you'll have to check the 3rd party apps documentation to supress...

malachyrafferty (6/16/2011)

---

hi all

i have a 3rd party demo software called Crystal Command which lets you execute a crystal report in the background using command shell and save it/email it etc

what...

what's this post counter of which you speak?:-D

Kevin for me, to get a table based on select into, I usually use a WHERE statement that will guarantee no rows:

SELECT * INTO ...

WHERE 1=2

that builds...