Got it right finally. Maybe not the best solution but here's what I did. Split up both the input SSRS string and the "Paratype" strings, joined the two result set...

A quick google search returned this see if it helps at all

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2009/01/12/tempdb-monitoring-and-troubleshooting-out-of-space.aspx

How about right click on tempdb / Reports / Standard Reports?

Try

SELECT (DATEDIFF(SECOND,CAST('15:03:00.0000000' as TIME),CAST('16:02:00.0000000' as TIME))/3600)

Figured out. Thanks.

Hi Matt / Steve.

Thanks very much for your help. The...

http://msdn.microsoft.com/en-us/library/ms187928.aspx

No EmployeeId? Why? You might have two employees with the same name..

SELECT DISTINCT

EmployeeId ,

Date...

For that specific query your index design doesn't make much sense. Also I wouldn't create indexes on tables with only a few rows. You may want to drop your indexes...

Hi,

Just create a proc and replace your hard coded values with variables so that you can use them

as report parameters in SSRS. Something like this:

CREATE PROCEDURE mySSRSReport

...

Stefan Krzywicki (8/23/2012)

---

We have some jobs that rely on a connection to Oracle. This connection is not reliable and we frequently end up with the job hanging indefinately. If we...

Use the...

Abu Dina (8/22/2012)

---

Good morning,

We have 5 SQL Servers used by operations team.

QBDB01 - 62 Databases

QBDB02 - 41 Databases

QBDB03 - 39 Databases

QBDB04 - 31 Databases

QBDB05 - 28 Databases

The databases are mainly...

narendra.babu57 (7/26/2012)

---

Hi All,

In My Table A , Eid 101 having status all are "cp" then i need latest Edate, but in case 102 it is having different status so i...

s.khann786 (7/26/2012)

---

Hi Friends,

i have record in xml like

<root>

<row spareid='10' sparename='abcd' />

<row spareid='11' sparename='mno' />

<row spareid='12' sparename='xyz' />

</root>

i want to check the spareid in table to avoid duplication before insert for...