It seems you are new around here. Welcome!!! In order to provide help we need to have enough details. That means we need ddl, sample data and desired output based...

Chrissy321 (1/29/2013)

---

Hello All,

Can I insert the results of a stored procedure into a dynamic table?

I am looking for the equivalent functionality of SELECT...INTO but with the data being returned from...

So what table(s) do you think you might need for this?

I gave you a basic syntax. Given the lack of details that is the best I can do. All you need to do is figure out what the query is...

Incredibly sparse on details. You just need to create your update statement.

Something like this.

update alias

set Col = slt.val

from linkserver.database.schema.table alias

join SomeLocalTable slt on slt.ID = alias.ID

rockandhra.net (1/29/2013)

---

SELECT GETDATE() AS 'Today''s Date and Time',

@@CONNECTIONS AS 'Login Attempts'

shows

72624361

How accurate is this data? Is it really SQL Server login (success/failure) attempts

I use sql-server connected through ADO.NET only(99%)

1. direct...

monilps (1/29/2013)

---

Hi,

I want to generate script that will have insert statement and select statement for each table in a database.

For Example:

insert into tableA (idA, columnA)

select idA, columnA from tableA

insert into...

Customers...

Glad it is working for you.

The point in time thing is good for a single column but can be a real pita to show what the entire table looked...

What have you tried so far?

The parser doesn't care about logical processing. It sees the same create temp table and throws up its hands. Maybe you can change your logic a little bit to avoid...

L' Eomot Inversé (1/29/2013)

---

Sean Lange (1/29/2013)

---

It seems that today's QOTD fits in nicely with this discussion. A very simple method was presented there using a constraint to allow a table...

Please read and follow the instructions found by reading the article in my signature about best practices. Nobody can help because we don't have ddl, sample data, desired output.

Or you could use and INSTEAD OF trigger and not have to worry about the transaction.

CREATE TRIGGER dbo.tr_test_D

ON dbo.test

INSTEAD OF DELETE

AS

BEGIN

...

It seems that today's QOTD fits in nicely with this discussion. A very simple method was presented there using a constraint to allow a table to have only 1 row.

CREATE...