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...

isuckatsql (4/13/2014)

---

did VARCHAR(20)

SELECT top 10 CAST(did AS INT) FROM table

Msg 245, Level 16, State 1, Line 3

Conversion failed when converting the varchar value 'cht6p575l7ry61k1npt' to data type int.

SELECT CONVERT(INT, did)...

The query just has an incorrect path, this works:

😎

declare @urlRedirect nvarchar(4000)

set @urlRedirect=N'www.google.com'

declare @userxml xml

set @userxml=N'<user>

<information>

<userkey>0</userkey>

<domainname><![CDATA[192.168.0.97]]></domainname>

<ip>192.168.0.97:2007</ip>

<from><![CDATA[http://192.168.0.97/default.htm]]></from>

<time>02/08/2014 08:08:57 ?.?</time>

<q>https://www.google.com</q>

</information>

<urlarea>

<url>login.htm</url>

</urlarea>

<formarea>

<user><![CDATA[sa]]></user>

<pass><![CDATA[sa]]></pass>

<B1><![CDATA[Submit]]></B1>

<hascdata>false</hascdata>

</formarea>

<cookiearea></cookiearea>

</user>'

SET @Userxml.modify('replace value of (/user/urlarea/url/text())[1] with sql:variable("@urlRedirect")')

select @userxml

One way of doing this is to edit the package in a text editor and remove the values that way.

Before:

<DTS:VariableValue DTS:DataType="14">120</DTS:VariableValue>

After:

<DTS:VariableValue DTS:DataType="14"></DTS:VariableValue>

😎

Don't know if this is better, at least it is slightly different 😎

DECLARE @Emp ...

Lynn Pettis (4/12/2014)

---

There is another way, look at the last Fiscal Year calculation:

WITH SAMPLE_DATE(XDATE) AS

(

SELECT CONVERT(DATETIME2(0),XDATE,120) AS XDATE

FROM (VALUES

...

halifaxdal (4/11/2014)

---

I have a very simple stored procedure to be used in Dundas Dashboard:

ALTER proc [dbo].[ddGetCurrentOpenAndClosed]

AS

declare @Open int

declare @Closed int

select @Open = count(1) From Document Where DocType = 1 and...

I agree with Jeff here, a trigger is not a good idea. Could you shed a little more light on the setup?

Eirikur