In a DB, A user needs to have access to create new tables, but for certain tables that user should have only read permissions(no modifications). In What ways this can...

U missed the brace and alias name....

Check with the following Syntax.....

update stbl set EXTMARK=MARK FROM

(

SELECT A.REGISTERNO,SUM(A.EXTERNALMARK) [MARK],SI.EXTMARK FROM

(

SELECT PTEMD.REGISTERNO,OESM.EXAMSCHEDULEID,OESM.BATCHID,OESM.COURSEID,PTEMD.EXTERNALMARK FROM

pted PT

INNER JOIN Ptemds PTEMD ON PT.PSID=PTEMD.PSID

INNER...

U are joining the tables on Varchar field that to not with matching conditionds....

Joining with the like operation ....from above scenario it creates more records...

like 'san%'

It will joins all name...

The view contains Just SQL select statement only...

Cheers!

Sasi

We cant get all Select stattements from single procedure....

If u want all

Create different datasets for each select statement in ssrs

or

Use union of all statements with some column predectable...

Hi,

Question: using stored procedure with multiple select statements

As a SQL Developer/Programmer U can write multiple select statements....

If U r with .NET application then u may use all these multiple...

Thanks.....

where the file going to store or

What is the Default location of .dat file...

if i run the following command

EXEC XP_CMDShell 'bcp DB_Project_Test..pt_tEmployee out tEmployee.dat -S Test -n -T...

there are many ....Like Chart-FX or Dundas Charts etc....

hi,

This feature is not available in SSRS 2005. If we use 3rd party controls we can....

I think this may availed in SSRS 2008...

Cheers!

Sasidhar Pulivarthi

Hi,

Use the following Query...........Better to write a Function for this....

SELECT Convert(VARCHAR(30),

CAST(DATEPART(YYYY,GETDATE()) AS VARCHAR(4))+' '

+ CASE DATEPART(MONTH,GETDATE())

when 1 Then ' January '

when 2 Then ' February...

hi,

Your requirement is not Correct one...

How can you represent a column of different datatypes in a table as per Ur desired O/P

If you are using Pivot One column should remain...

hi,

Use Pivot query ...

see the below link....which gives more details....

http://www.mssqltips.com/tip.asp?tip=1019

Regards,

Chowdary

The Function is of Table return type....

So U should join Function with your select Query...

Example:-

Select a.Col1,a.col2,a.col6,fn.Col1,fn.col2

from Tbl a join (Select * from fn_func(par1,par2) )fn on fn.fn_col1=a.col1

In your qurey need to...

Updtae tbl_xyz set Col1='sdfsdfsdf',

Col2='12313'

OUTPUT(DELETED.COl1,DELETED.Col2)

INTO tbl_xyz_oldvalues (dltedCol1,dltedCol2)

the following code is...

Thanks Luke...

For Case 1: The report contains same 55K data.

I verified the maxRequestLength in web.config file. It contains 4096.

I have to test against 50MB as maxRequestLength.