i think this should give the same results and be quicker

but without data i can't prove it

LEFT OUTER JOIN

(SELECT DsSupcode,DsLocationCode,TerminalNumber,MIN(recid) as recidmin FROM MOC_DT.dbo.TCN_Xref

WHERE

AND (group by TerminalNumber,DsLocationCode,DsSupcode )...

employ good database administrators 🙂

brillian - thanks -

"The session keys for this conversation could not be created or accessed. The database master key is required for this operation."

OOPS - forgot to create the...

oh - and i also forgot to say i switched the message type to VALIDATION=NONE just in case it was badly formed XML, didn't fix the problem

John Bates-251278 (5/11/2012)

---

Thanks, Michael.

No, I'm trying to avoid using Linked Servers.

With CMS you can query many servers via a single query. Info for all your central management servers is returned.

But...

tburk 5368 (5/10/2012)

---

I have this access query that I need to convert to sql and not quite sure what to use.

UPDATE Attribute_Data

SET Attribute_Data.AttValue = Int([AttValue])

WHERE (((IsNumeric([AttValue]))=-1) AND ((Right([AttValue],2))=".0"))

OR (((IsNumeric([AttValue]))=-1) AND...

komal145 (5/11/2012)

---

entry_id sys_Routing_Action sys_WkfStep_Current

123 ...

was i too harsh on this chap??

as for stored procedures - well frankly if your manager doesn't know how to give you permissions to add stored procedures then he should...

there is no harm in looking at the market and seeing what options are available - even go for an interview or two ... you don't have to accept the...

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