geo123abram (6/21/2014)

---

I have multiple parameters for a sp, where I am executing a dynamic sql statement using sp_executesql. Now the parameter definitions can be dynamically set. However, all the parameters...

Sachin Nandanwar (6/22/2014)

---

Eirikur Eiriksson (6/21/2014)

---

Those would...

Don't think there is a need for a cursor

😎

UPDATE E

SET E.ActiveRoles = dbo.udf_GetRoles(P.pkPerson)

FROM dbo.tEmployee E

INNER JOIN P

ON E.pkPerson = P.pkPerson;

The correct cursor code

DECLARE @pkPerson...

Those would then certainly be valid...

deepu chan (6/21/2014)

---

i have a table like below

create table #temp

(

valid_id int not null,

valid_no varchar(50)

)

10001

20002

30011

40012

i need to select the valid no without '0' lie 1,2,11,12, how do i?

someone please clarify me...

sstomp (6/20/2014)

---

We are getting this error message when attempting to connect a linked server to an ODBC data source logged in with SQL authentication:

OLE DB provider "SQLNCLI10" for linked server...

Appreciate the effort! Thanks!

😎

Prefer...

Jeff Moden (6/21/2014)

---

ykonline (6/20/2014)

---

Hi,

I want to insert data periodically from an excel file into a table using a SSIS. But each time the no. of columns in excel may vary....

+#2222CC

😎

Thought it would be Purple, half the time one sees red:blush: and the other half on is feeling blue:(

😎

Mi dispiace,

thought I had answered this long time ago:-D

😎

USE tempdb;

GO

create table #prova

( Valuta varchar(2),

Misura DECIMAL(18,5)

)

insert into #prova values ('EU',1000)

insert into #prova values ('$',2000)

/* Adding a row number */

;WITH DIM_BASE AS

(

...

muthyala_51 (6/20/2014)

---

I am trying to upgrade my 2008 sql server to sql 2014 with windows upgrade to 2012. Just came to know that we are on 2003 Active directory and...

Lynn Pettis (6/21/2014)

---

Here is how I am importing an XML file into an XML variable for processing. The key is the OPENROWSET BULK option. Hope this helps some.

declare...

Jeff Moden (6/19/2014)

---

Eirikur Eiriksson (6/19/2014)

---

Jeff Moden (6/19/2014)

---

My problem is that I really don't understand what you're trying to do. This start out with "counting characters in a string before...