Dynamic SQL isn't even necessary. In fact, the table of field names isn't really needed either...

Try this on for size:

DECLARE @t1 AS TABLE (

tab varchar(100)

);

INSERT INTO @t1 VALUES ('I');

INSERT...

Is it possible that the function gets a dependency "taken out from under it", so to speak, and then when accessed, there has somehow been no opportunity to re-establish that...

I'm guessing, but you appear to have mixed the install of SSDT from a CTP release with an RTM install of SQL Server. Generally, that's not a good...

Alvin Ramard (6/3/2015)

---

sgmunson (6/3/2015)

---

I'm not 100% sure I know exactly what you are looking for, but if you're looking to compute the time difference between two fields that are stored...

Have you looked into the LEAD and LAG functions? The latter is what you appear to need. See the following blog for an example usage:

http://blog.sqlauthority.com/2011/11/15/sql-server-introduction-to-lead-and-lag-analytic-functions-introduced-in-sql-server-2012/%5B/url%5D

I'm not 100% sure I know exactly what you are looking for, but if you're looking to compute the time difference between two fields that are stored as character fields...

luissantos (5/29/2015)

---

Hello Dohsan

i understand your doubt but i need the range of my invoiceheader dates .

without this range all invoices are appear.

In pratice, and i don´t know if it is...

If it's "well-structured", that might suggest that loading it into an appropriate table design via SSIS might make sense, and depending on what testing bears out, you might even script...

To cover the possibility of no spaces resulting in a NULL value, try this:

WITH mytable AS (

SELECT 'Alok Kumar' AS [Name] UNION...

manoj.ramaiah (6/1/2015)

---

I have a package which is creating a excel file 'ExcelName.xls' and storing in 'E:\Reporting\Delivered_Reports'. Now I have to attach this report using send mail task and send it...

I usually make folders using VBScript, but you can use a Script Task within SSIS, and use Visual Basic. I usually do it in a separate task...

As I'm not familiar with how the XML stuff works in sufficient detail, all I can offer is a simple REPLACE:

SELECT REPLACE(

(

SELECT

-- Root element attributes

'http://tempuri.org/Form.xsd' AS xmlns,

'http://www.w3.org/2001/XMLSchema-instance' AS 'xmlns:xsd',

(

SELECT

-- Creating...

Meatloaf (5/27/2015)

---

Hello,

I am looking to create a simple IF Else statement in a SPROC but my syantax seems to be wrong. Can someone advise what I am doing wrong?

IF (vchDept='IT')

BEGIN...

Alvin (myjobsinus),

SSCommitted...

Can you use a variable name to supply the value instead of just pure text? If so, how about:

DECLARE @VER AS nvarchar(255) = @@VERSION;

DECLARE @TXT AS varchar(3);

SELECT @TXT...