Rough guess based on what you described above.

Step 1: Generate a random number between 1 and 10000

Step 2: Output random number in step 1 + DATEDIFF(DAY, '1/1/1800', dateColumnInTable).

If they're doing...

This is probably more a job for SSIS than for stored procs.

Calling a web service in SSIS is pretty easy (there's a task for it), and you should be able...

select

ccp.part_id,

ccp.warehouse_id,

ccp.count_freq,

ccp.last_count_date,

pl.qty

from

cycle_count_part ccp LEFT JOIN part_location pl ON ccp.part_id = pl.part_id AND ccp.warehouse_id = pl.warehouse_id

where pl.part_id IS NOT NULL

AND

ccp.warehouse_id in ('GSS_PROD','AIRCRAFT_PROD')

...sorry for the bad formatting.

High level overview of how to do this (we do this a lot in our application).

Use a sproc that takes an XML parameter.

Wrap the parent and child updates into XML

Have...

If you're trying to implement paging (which it sounds like you're doing), have a look at: http://www.sqlservercentral.com/columnists/jSebastian/3181.asp

It has seveal links to ways to accomplish paging, including front and back...

It's still eating your XML, but assuming it looks like:

<TestCaseID>12345</TestCaseID>

<TestCaseID>12346</TestCaseID>

You can use:

INSERT INTO <table> (field) SELECT T.T.value('.[1]', 'INT') FROM @XML.nodes('/TestCaseID') AS T(T)

Should do what you're trying to do without a...

Mmmm... One of those having tricks can solve this.

SELECT

    Pole_ID

FROM

    XX

GROUP BY

    Pole_ID

HAVING

   COUNT(*) = SUM(CASE WHEN Date IS NULL THEN 0 ELSE 1 END)

Note that...

Interesting...

I used the:

<xsl:for-each select="/Report/table1/Detail_Collection/Detail">

syntax in XML Notepad against the XML you posted, and everything worked fine, once I removed the reference to the XML schema (https://corepm.acme.com, since that doesn't...

Can't check this right now, but I'm pretty sure you need to either change the

<xsl:template match="/">

to