Evil Kraig F (11/17/2014)

---

Eirikur Eiriksson (11/17/2014)

---

Quick suggestions, open the package in a text editor and search for the variable name, there should only be one deceleration with that name but...

Quick suggestions, open the package in a text editor and search for the variable name, there should only be one deceleration with that name but you might find another with...

Quick thought, don't use the traversing // if the position of the element is known, far more expensive than the direct reference.

😎

SELECT

x.item.value('@CLM_ID', 'NVARCHAR(max)') AS CODE

FROM @x.nodes('CLAIM/INPUT/HEADER') AS x(item)

That kind of summarizes it doesn't it? If there was an...

I should have mentioned DelimitedSplit8K[/url], it's perfect for the job.

😎

Then my suggestion is to check out EasySoft's odbc driver

😎

Guess you are on RHEL 6 given your kernel version;-), check this out "Microsoft ODBC Driver 11 for SQL Server on Linux"

😎

Which distribution (RedHat, Suse, Ubuntu etc.)?

😎

balasaukri (11/17/2014)

---

Hi,

Recently we migrated a database to SQL Server 2012 version and configured mirroring on it as per the requirement by the client. One of a client's application is running...

kriskumark96 (11/17/2014)

---

Hi All,

I have 3 different queries with 3 different where conditions ,then i want to get all those 3 columns displayed as a single table output.

Ex

Select col1, col2 from...

Raghunathan (11/17/2014)

---

based on the above data i want to generate a report as

MACHINEDATE

...

Guitar_player (11/17/2014)

---

Hi ,

I am kind of in Confusion in some simple logic i believe , so i need the help of you all .

My requirement is...

Quick solution using dynamic cross-tab

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.TBL_SAMPLE_PRODUCTS') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_PRODUCTS;

CREATE TABLE dbo.TBL_SAMPLE_PRODUCTS

(

[Product Name] VARCHAR(50) NOT NULL

...

Quick query without #temp tables which uses a CTE (Common Table Expression). Note that the joins have been changed from ANSI-89 and table aliases added.

😎

;WITH GROUP_SESSIONS AS

(

...

Jeff Moden (11/16/2014)

---

Careful now... If there are 3 column pairs for AirCraft and City, each pair of which is supposed to return a single row (i.e. 3 un-pivoted rows for...