dwain.c (10/9/2013)

---

Am I the only one left speechless and flabbergasted by this post?

http://www.sqlservercentral.com/Forums/FindPost1503017.aspx

I used to teach 2 methods to swap A and B in entry level university FORTRAN course (too)...

It means you can't get the certification anymore.

Instead you can achieve the SQL Server 2012 certifications.

I believe you can still do the 2008 exams...

EZ PZ 😀

Just like you would against SQL Server. DB2 also supports CTE expressions.

I'll let them know 🙂

Remember that if you execute something on production, you're responsible for it. If something goes wrong,...

hoseam (10/9/2013)

---

Hi

Yes there is actually nested query:

BEGIN TRANSACTION [new_Account]

INSERT CUSTOMER(NAME, CITY, STATE)

VALUES ('Izetta','Greenville', 'AL')

IF EXISTS (SELECT * FROM CUSTOMER WHERE NAME = 'Izetta')

BEGIN

BEGIN TRANSACTION

INSERT BALANCES(AVERAGE_BAL, CURRENT_BAL)

VALUES(1250.76, 1431.26)

END

ELSE ROLLBACK TRANSACTION

COMMIT

BEGIN...

Here you go:

SELECT TOP 25

RowNumber= number+1

,DateField= CONVERT(DATE,DATEADD(dd,number,'2009-11-09'))

,DateGroup= (number/4)+1

FROM master.dbo.spt_values

WHERE type = 'P';

I used the system table spt_values to get a list of numbers, but there are other methods to...

When I run the query John is still in the table.

SSRS will not display the text. It expects a dataset with the predefined columns.

Since the resultset doesn't contain any rows, it will show an empty report.

Are you developing on Windows XP?

Maybe the HyperV improvements?

Using SSIS or BCP you won't achieve your requirement.

Either you code it with .NET, or you use a macro to do the formatting.

Another option is to create a report in...

You'll need to check which permissions...

OK. Next time use the SSIS forums 😉