Same again, but with my SELECT MAX() solution tagged on to the end.

CREATE TABLE temp (ID INT, Date DATE);

WITH E(n)

AS (SELECT...

astrid 69000 (4/20/2016)

---

Thanks so much.

I read and read and I understood. and it worked :-P:-P

Here is my code

declare @x xml

DECLARE @site_value INT;

SET @site_value = 0;

WHILE @site_value <= 1000

BEGIN

select @x =...

Here's an UPDATE version:

IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL

DROP TABLE #test;

CREATE TABLE #test

(

Id INT PRIMARY KEY

,dt DATE

...

Dhivya Elan (4/20/2016)

---

Hi Phil,

I tried using the ForEachLoop container. Here's what I did:

1) Made all my Excel Source tabs identical, by adding missing column headers (although they might not contain...

Dhivya Elan (4/20/2016)

---

Hi John

I've been trying to use the derived column transformation, unable to find a guide on how-to, that matches my requirement. I would really appreciate any helpful links....

Dhivya Elan (4/20/2016)

---

Hello All,

I have recently started using SSIS, and have been exploring various transformations trying to make the best use of them. I currently have a requirement where in,...

rafnunes (4/20/2016)

---

thanks for your answer.

But correct if I'm wrong, after reset SQL server Service and application the lock should not disappear?

It's possible to know if a table is locked,...

singhamitpal (4/19/2016)

---

I have spoke to some people who claim themselves to be SQL Guru's. Anyways, below is what I found...

1.Very few developers will be able to create a consistent stored...

rafnunes (4/20/2016)

---

I have a code that execute this steps in some table:

1 - Update 5000 rows with will be to extract, is a bit column with value NULL 0...

Eirikur Eiriksson (4/20/2016)

---

Phil Parkin (4/19/2016)

---

Ed Wagner (4/19/2016)

---

Are...

pvong (4/19/2016)

---

Phil, thanks for your help.

Jacob, I marked you as the answer because I learned how to do an error output file thanks to you suggesting it. Remember, I'm...

singhamitpal (4/19/2016)

---

Thanks for the response...

I’VE have been advised to stay away from the stored procedures meaning the business logic should NOT be stored in stored procedures, except where really really...

I'm sure you know this, but ispac files get deployed only to SSISDB (as far as I know).

Looks like you have two instances of the DB engine installed.

One will be accessible by typing 'localhost' in the server name.

The other will be accessible by typing [machine name]\SQLExpress in...

Ed Wagner (4/19/2016)

---

Are you thinking something along...