gklundt (12/1/2010)

---

You cannot disable windows groups.

From BOL (TSQL Reference on ALTER LOGIN):

You cannot use ALTER_LOGIN with the DISABLE argument to deny access to a Windows group. For example,...

May be number of queries in the report cause OutOfMemory exception. Tyr tuning the queries. You may handle rendering of report by checking record count, but what if the query...

I remember one of my developers has done this. Let me check with him and get back to you.

Agree with Snigdha. It's not supported in SSRS.

vina117831 (9/20/2013)

---

Import Canon XF300 MXF to FCPX. Mountain Lion 10.8.2. Many threads seem to point to needing a converter for these files before FCP X will read them. If...

tibco29 (9/11/2013)

---

I want to check field/column exist or not in a table and populate the value

Example: Does the column1,column2 exists:

case1:return column1 and column2

case2:return column1 or column2

case3:return column1

case4:return column2

case5:return...

Sean Lange (9/17/2013)

---

C Hrushi (9/17/2013)

---

This might hep for n number of columns :

*********************************************************************************************

DECLARE @Q NVARCHAR(4000),

@CName VARCHAR(255)

DECLARE ColCur CURSOR

FOR

SELECT C.name as Column_name

FROMsys.columns C

LEFT JOIN sys.tables t

on C.object_id = t.object_id

WHEREt.name...

It is possible to achieve. Not sure what values you would be comparing. Please provide some more details.

Do you need to create the third table by querying first two tables?

Thanks for sharing!

I don't see any relationship between these two tables.

Is it that in your Table A, you are maintaining list of Tables

and AssociatedTable1 is an another table for which...

ChrisM@Work (9/12/2013)

---

kapil_kk (9/11/2013)

---

Its not a good practice to use functions like...

If you need to handle another condition along with NULL, you may write something like

CASE

WHEN TCBOV.cboValueName IS NOT NULL THEN

CASE TCBOV.cboValueName ...

SELECT * FROM Table A

INNER JOIN Table B

WHERE LEFT(A.UserName, 7) = B.ID -- RELEVANT FIELD FROM TABLE B

Not sure if this helps you out. In a similar situation, I created a report parameter with values same as the sub-report. For my sub-report, I have a sql stored...