fregatepllada (4/17/2014)

---

Thank you for a great article!

I am not quite agree with this statement "SQL Server has no specific functions or methods for validating XML".

How about strongly typed XML...

Jacob Pressures (4/16/2014)

---

I have the following tables:

Customer,

Customer Credit Card,

Credit Card

Order

But a customer can also pay with cash.

Should I have a payment or transaction table which allow null IDs...

I agree with rVadim that you should probably consider another approach if possible.

Having said this, here an example code for a procedure to drop and create the view:

CREATE PROCEDURE dbo.USP_REFRES_THE_LATEST_VIEW

AS

IF...

What about the values passed in the where clause, a typical mistake would be mixing up the two parameters.

😎

dwilliscp (4/16/2014)

---

I have a lookup records that feeds into a OLE DB Command. When I execute everything turns green and the lookup match output gives 847 rows.

But looking at the...

This should get you started, cannot do this in a view though, in a stored procedure it works fine.

😎

USE [tempdb]

GO

CREATE SCHEMA [SCHEMA01] AUTHORIZATION [dbo];

GO

CREATE SCHEMA [SCHEMA02] AUTHORIZATION [dbo];

GO

CREATE SCHEMA [SCHEMA03]...

Check out this article, Control Flow Task Errors – Level 9 of the Stairway to Integration Services[/url]

😎

Quick question, why the (nolock) hints?

😎

Looks like something has changed, what does this query bring back?

😎

SELECT

sc.configuration_id

,sc.name

,sc.value

,sc.minimum

...

The .ods or OpenDocument Spreadsheet can be opened with Excel 2007 or later, OpenOffice and LibreOffice.

It contains multiple files within a zip file, one way of importing is to rename...

FYI: Ran the function through the test script with the same result aggregation as I used for the article.

😎

SplitterName ...

Here is another way, using ranking

😎

WITH CTE_OPT_BASE AS

(

select

ROW_NUMBER() OVER

(

...

This should get you started 😎

DECLARE @REF_DATE DATE = '2014-06-01';

DECLARE @MEM_PAY_DATE TABLE

(

PAYMENT_ID INT NOT NULL

,MEMBER_ID ...

The most usual approach is to use one file for each environment, a dev config, a testing config and a production config.

😎

Add "carriage return" and "line feed" characters, see the example

😎

SELECT 'THIS IS A COMMENT LINE 1' + CHAR(13) + CHAR(10) + 'THIS...