OK. This relies on the number of columns being known in advance and the data types also being known.

SELECT 'Car','Boat','MotorCycle','Scooter' FROM T1

This returns a row of data containing the...

Phil Parkin (5/3/2016)

---

Smendle (5/3/2016)

---

You can do this within SSIS. Its a populate SQL from variable, while the column names don't have to be the same I do believe the...

PSB (5/3/2016)

---

Hi,

I need to wipe out just today's data and insert new ones . Yesterday's data should be untouched . But the procedure is wiping off yesterday's record using the...

Not too be picky but if your requirement of the other columns is not needed than what you ask can be accomplished really easy..

SELECT ServerName FROM InstanceTypes GROUP BY ServerName

I'm...

You can do this within SSIS. Its a populate SQL from variable, while the column names don't have to be the same I do believe the number and data...

Hi Fred,

First I want to say thanks for the dataset to work with

However

You should probably understand that you will get a lot more help if you set up the...

Has it been this way for a year? I usually go back to my customers after a year with a usage report.

basically something like this

This is what you said...

Even though you invoke the maintenance plan as another user when it goes to interface with the file system it uses the SQL Server agent account.

To do this I would...

nadersam (3/29/2016)

---

GilaMonster (3/29/2016)

---

Space used + 2 bytes.

As for make everything varchar(8000), why? Is a person's first name going to be thousands of characters long? A city name? A company name?...

I can confirm I was able to failover from a 10.50.6529 version to a 10.50.6000 (sp3) version. I wouldn't recommend keeping the difference in versions but if you make...

I didn't even realize there were two sp at work here. What I normally do is use the GUI and then script it out which is what I showed...

I should have said to add those parameters to yours in the addlinkserver so combine your parameters and the user parameters and try again.

GilaMonster (4/15/2016)

---

EamonSQL (4/14/2016)

---

Is it possible to find out which updates were made against a first, second, third etc nested transactions?

For example, if select @@trancount returns 4 can I find out...

briancampbellmcad (4/21/2016)

---

Thanks in advance... I am trying to develop a stored procedure to pull Access data into SQL Server.

I created a linked server object using:

EXEC sp_addlinkedserver

@server =...

Since I don't know anything about your environment Im going to ask several questions

1. Is the cluster heartbeat on a separate nic/vlan?

2. Is there blocking occurring on prod?

3....