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

It all depends on how quickly you have to get the data from A to B, first option would be a linked server (via ODBC), have you tried this?

😎

First thought would be the PERMISSION_SET, check this out on the subject: http://technet.microsoft.com/en-us/library/ms345101.aspx

Ciao 😎

Window function solution, works on 2012 and later

😎

Create Table #Temp (ID int not null primary Key, Name varchar(25) not null, DOB datetime not null, Sex char(1), Race char(1), Height int,...

No better way of putting it!:-D

GilaMonster (4/9/2014)

---

Eirikur Eiriksson (4/9/2014)

---

According to my findings (observed behavior) , using the minus "-" bypasses (for the lack of better word) the logical operator, select * from table where x...

dj341 (4/9/2014)

---

Eirikur Eiriksson (4/9/2014)

---

According to my findings (observed behavior) , using the minus "-" bypasses (for the lack of better word) the logical operator, select * from table where x...

According to my findings (observed behavior) , using the minus "-" bypasses (for the lack of better word) the logical operator, select * from table where x >- y brings...

I have a sketch but cannot have it ready until the end of the month, is that OK?