here you go;

this is using the FOR XML trick to concat your values together:

create table #temp

(

offerid int

, Catg varchar(100)

)

insert into #temp( offerid, Catg )

select 1, 'health' union all

select 1, 'fitness'...

they linked server syntax you used is a bit different from what I typically use; i'm posting it here for reference;

also, just a confirmation, your server is not 64 bit...

tendayit thanks for posting everything we might need to analyze it; it's so large, it'd take a lot to look at it all;

your functions 2200+lines ,and it's all doing...

imtiazm (2/4/2010)

---

This is the reply i get

...

File activation failure. The physical file name "f:\XXX.ldf" may be incorrect.

File activation failure. The physical file name "f:\XXX.ldf" may be incorrect.

The log cannot be...

the right thing to do is to go tell your other admins to not fiddle with your development server. Going behind their back and trying to lock them out is...

Rup you might want to check for other iterations based on html differences; for examples spaces before/after the equals sign just to be sure;

i'm glad this worked for you.

--original:

set @pre...

Ruprecht I'm halfway there from a sinlge command solution, but i wanted to post an immedite fix right away; if this is a one-time solution, this would give you everything...

glad this was helpful for you , Leena; I've never found a practical use for it so far, but it is good to know; of course there is always more...

eric could it have to do with disk permissions?

for example, on my win7 laptop, i cannot write to c:\mydb.sdf, but i have no problem writing to C:\Program Files\Microsoft SQL...

would that mean you have to add a dml trace to the server so you can capture the user/application name/hostname and other information, i guess to complement the changes CDC...

no, sorry DR; a function cannot call a stored procedure, only extended stored procedures;

the reason is a function is not allowed to affect objects, and since a stored procedure could...

i think you'll have to use MAX(*) functions and a group by statement:

SELECT

Dt ,

MAX(Wire) AS Wire,

MAX(Convergys) As Convergys

FROM YourTable

Group By Dt

malware? it's just my crappy dev site that holds all my ugly screenshots and script examples; i don't see anything wrong, can you pm me whatever you are seeing?

like Wayne said, there should be an event for OnFormClose you cna use to prevent the form from being destroyed if a process has not completed; also, you should also...

Gaby if you are inserting single rows at a time, even if there are lots of them per second, scop-identity() should work fine.

if you have a single statement that is...