inevercheckthis2002 (4/7/2014)

---

Insert values:

INSERT INTO visited

VALUES

(N'Home', N'Kim'),

(N'Contact', N'Kim'),

(N'Products', N'Kim'),

(N'Home', N'Joe'),

(N'Contact', N'Joe'),

(N'Home', N'Pam'),

(N'Home', N'Sam'),

(N'Contact', N'Sam'),

(N'Products', N'Sam'),

(N'Home', N'Ray'),

(N'Products', N'Ray),

(N'Home', N'Kim'),

(N'Home', N'Pam'),

(N'Home', N'Sam')

;

(Actually, this did not work, I had to insert each row...

The nodes() method of the xml datatype makes this straight forward.

😎

DECLARE @X XML

SET @X = '<root>

<production.Categories categoryid="1" categoryname="Beverages" description="Soft drinks, coffees, teas, beers, and ales" />

...

Jeff Moden (4/6/2014)

---

naresh0407 (4/5/2014)

---

Hi..Actually are asked to validate this task without scripttask.We should use inbuilt transformations to achieve this task.Could you please tell me how can we acheive this.Just let...

If you only have few tables to check, do not use sp_MSforeachtable, it executes the statement once for each table in the database, regardless of what ever filtering you use.

The...

Peter2012 (4/6/2014)

---

Hi Eirikur,

Thanks for your response.

I've checked the given URL and it's not what I'm looking for as it's checking for all tables.

What I want is to check for certain...

In Sql Server 2008 the support for multi document type / multi format document files is very limited and some workarounds are needed. Without using...

lmarkum (4/1/2014)

---

We have a SQL Server 2005 instance that hosts an OLTP environment for our finance system (Navision). We have CRM on a SQL Server 2008R2 instance on a...

What version of SQL Server / SSIS are you using?

You'll find detailed instructions in this article

Determining space used for each table in a SQL Server database[/url] by: Greg Robidoux

😎

Jeff Moden (4/5/2014)

---

print concat('drop table ',@tablename);

I just can't help it. CONCAT seems so much less natural and less obvious and more difficult to read than...

print 'drop table ' +...

The problem is that you cannot pass sql identifiers such as table names...

Assuming that you have...

naresh0407 (4/5/2014)

---

Basically i have Header and DetailRow table seperalty.So need to transfer H row to header table and D row to DetailRow.

Can i acheve this without scriptask?

I have one...

This code creates a polygon and 200 points (lat/lon) and then selects the points that are inside the polygon

😎

DECLARE @POLIGON geography;

SET @POLIGON = geography::STPolyFromText('POLYGON ((5 5, 10 5, 10...

What's next, business holidays and weekends? 😀

Just for the sake of completion:

SELECT Eventdate,Status

INTO #AP_DATA

FROM (VALUES

('2014-01-20 18:00', 0)

,('2014-01-20 18:30', 0)

,('2014-01-20 19:00', 1)

,('2014-01-20 19:30', 0)

,('2014-01-20 20:00', 1)

,('2014-01-20 20:30', 0)

,('2014-01-20 21:00', 0)

,('2014-01-20 21:30',...