You are correct, you cannot :pinch:

You can create a dynamic SQL statement, but you cannot execute

Hi Tara

You should restrict your SQL Server instance not to use the complete memory. SSMS -> right click your SSE instance -> Memory. Configure a value which depends on your...

I'm curious why you need to store this trailing spaces. 🙂

Hi

The problem does not depend on your CREATE FUNCTION but on the fact that you cannot call OPENROWSET with variables as parameter.

This also doesn't work (outside of a function):

DECLARE @filenameString...

Hi hunter

I really want to help. Could you please provide DDL (CREATE statements) for your sample data, some INSERT-statements for the sample data and the SELECT you are using? Problem...

Hi

You should have a look to BOL for the INSERT statement and its OUTPUT clause. It can be used to write the data into another (e.g. variable) table.

Greets

Flo

Hi

If your applications are primary inserting data you could create some staging tables which will be used by less users and use bulk operation to add the data into your...

Hi Taffy

I'm not sure if this helps but I had the same problem and I handle it with a table variable which receives the output of xp_cmdshell. After this I...

Hi

I'm not sure if I got you but maybe you're looking for a TIMESTAMP (not DATETIME) column. Try this in SSMS:

CREATE TABLE TestTS (Id INT, TS TIMESTAMP)

INSERT INTO TestTS (Id)

...

Steve,

Luke's post here is very nice, but it shows a great option for cross-side-scripting (by including an iframe into his post).

Maybe you should speak with the site developers?

@luke: Nothing against...

Paul White (5/14/2009)

---

Bob Hovious (5/14/2009)

---

Hey Bruce and Paul... how is life in New Zealand? Where do you each live again? Bruce, you're on the North Island...

Jan Van der Eecken (5/15/2009)

---

Florian Reischl (5/15/2009)

---

I'm a city guy from here but Munich is a very green city with many parks.

Anyway, 30 minutes to some nice lakes and 45...

GilaMonster (5/15/2009)

---

Ahhh!!!! Damn it! Twice this year!

Flat broken into again last night. Among other things, took the zune that I bought to replace the ipod that they stole last bloody...

Either change the functionality of your VB-Scripts to work with config-files instead of copying around or have a look to SSIS.

Greets

Flo

So take a valid value for your @acOrderID.

Start with your first JOIN (the SELECT which fills the other variables) and copy into a separate query window. So you can figure...