Kristen-173977 (9/14/2015)

---

A function can't insert into a table. I presume that is the error that you are encountering.

A Stored Procedure could do.

The Function could return the SQL, for the code...

This seems somewhat long-winded and will not scale well (because it's not an iTVF).

Can you give a bit of background about what you are trying to achieve & what the...

Kristen-173977 (9/14/2015)

---

Any mileage in looking...

I would recommend that you create a calendar table[/url] and create a left join from your calendar table to the table which contains data.

HookSqlDba7 (9/11/2015)

---

We have SQL Server 2014 EE SP1 and are using Project Deployment via SSMS. Just curious, I read that if a project is deployed to the same location...

vipin_jha123 (9/11/2015)

---

Hi all,

I have 2 source folder .

I have created variable for both source folder like below

User::Source1 and User::Source2

and 1 destination folder variable like below

User::Destination

Now I have to search a...

Eirikur Eiriksson (9/9/2015)

---

Phil, not going into the begininator/terminator debate 😀 as this is a habit for the...

Eirikur, a semi-colon before a CTE? I expected better from you! 🙂

jaquino012 (9/2/2015)

---

Hi Experts,

How can i accomplish to delete a selected ID's using T-SQL.

I have use this query DELETE FROM `table` WHERE id IN (264, 265).

But if my parameters are selected,...

Resender (9/1/2015)

---

Ok quick scenario,our primary file server is changing between today (Sep 1 2015) & the next 6 months.

On this file server we have a share where we put flat...

Lavanyasri (9/1/2015)

---

I am planning to delete a login from SQL logins because he moved out from project .when i try to delete the login , it throws an error saying...

Good work.

I have only skimmed the article so far, but one question which came to mind relates to project-level parameters.

As these are not part of the package DTSX, I am...

I think not. This code gives...

Vladan (9/1/2015)

---

Phil,

i may be mistaken, but I understand the reply with "consecutive months" precisely in the way you asked the question 🙂 that is, that there is no overlapping except...

Can you give us some...