and how many results do you expect ? - can you post what you expect the final data to look like - because with only 2 columns in your table...

ljvarga (5/11/2012)

---

Is there a way I can create a template (ie. declare the stuff from wip like hours and dates) and test with an if statement where if the employee...

is it just because it's friday that the questions are getting worse?

FTP can be scripted - in ssis you could call a batch file which contains your FTP commands

try googling FTP scripting

joe

you really need to give us more information

do you have a network connection between the sites ? - how do you know which sites have db servers - how...

riya_dave (5/11/2012)

---

hi

i have unique identifier field in one sp, that i need to pass into another sp.

when i copy paste it to another sp as a parameter value,i am...

komal145 (5/11/2012)

---

I have 2 tables:

dbo.Doc_activity and dbo.event_type

CREATE TABLE [dbo].[Doc_Activity](

[Entry_Id] [int] NOT NULL,

[Event_Type_Id] [int] NOT NULL,

[Event_Value] [varchar](1023) NULL,

[Event_Time] [datetime] NOT NULL,

[User_Name_Event] [varchar](200) NULL,

[Last_Updated_User] [varchar](1023) NULL,

[Last_Updated] [datetime] NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[Event_Type](

[Event_Description]...

John Bates-251278 (5/11/2012)

---

Hi everyone,

I have configured CMS on my 2008 R2 server.

I have a CMS node containing several SQL 2005 server names.

I want to query info from those servers and...

off the top of my head this should do it

SELECT EmpCustom.EmpCustValue AS Team, Employee.Empfname + ' ' + WIP.WEmpLName AS Employee, WIP.WCltName AS Project, WIP.WSCDesc...

apostolis.karayiannis (5/11/2012)

---

Hello

My problem is the following:

I have a table (table A) that has several columns and each one of those columns has a description on the description property. I...

+1 lynn

the more info you give us and the clearer the question, the more likely you are to get a well formed and correct response.

look at it this way -...

elham_azizi_62 (9/27/2011)

---

hello all.

I use this script for export query result to existing dbf file :

insert into openrowset ('MSDASQL','Driver=Microsoft Visual FoxPro Driver; SourceType=DBF; SourceDB=c:\Temp','select * from dskwor00')

select * from test

but get...

there is an issue with the 64 bit installation of windows - it doesn't install the MSDASQL drivers

kirkm 55368 (5/7/2012)

---

Sure, thanks. But it's still being designed (badly!)

SELECT qryUC.Serial, qryUC.Title, qryUC.Artist, qryUC.Lyrics

FROM qryUC INNER JOIN tblAAA ON qryUC.Serial = tblAAA.Prefix

WHERE (((qryUC.Lyrics) Like "*climb*"));

So it's where instr(qryUC.Serial,tblAAA.Prefix) > 0.

I'm...

if forgot to add - there are certain limitations/ workarounds for the replace function with regards to length of the string being no more than 8000 characters (see books on...