Hi,

I. SELECT COUNT_BIG(*)

II. SELECT COUNT_BIG(column_2)

III. SELECT COUNT_BIG(ALL column_2)

IV. SELECT COUNT_BIG(DISTINCT column_2)

I Answered this question selecting II,III and IV (which actually is a correct answer) guess what i was indicated as...

Hi,

I am executing a stored procedure and i encountered the following error :

Server: Msg 3624, Level 20, State 1, Line 1

Location: recbase.cpp:1375

Expression: m_offBeginVar < m_SizeRec

SPID: 63

Process ID: 688

Connection...

Hi I went on to add one more record to the table 'TableTest' as under:

TestID UserID

1 26

and wrote...

Hi,

to get the next working day after the immediate sat,sun you can use the following query:

Declare @dDate as datetime

set @dDate = '30 may 2008'

select case datepart(dw,cast(@dDate as datetime)+1)

when 1...

HI RAHUL FOLLOWING FUNCTION SHOULD SOLVE YOUR PROBLEM

---------------FUNCTION START

CREATE FUNCTION dbo.fn_aviSplit(@vNumber varchar(50))

RETURNS @MyTable TABLE

(

Number int

)

AS

BEGIN

DECLARE @vNumberDump varchar(50),

@vChar varchar(50),

@iCommaPos int,

@iPos int,

@iEndPos INT

SET @iPos = 1

WHILE (len(@vNumber)>0)

BEGIN

SET @iCommaPos...

Hi Rahul,

I think the solution of your problem lies in the following function :

----------- STARTING OF FUNCTION

CREATE FUNCTION dbo.fn_aviSplit(@vNumber varchar(50))

RETURNS @MyTable TABLE

(

Number int

)

AS

BEGIN

DECLARE @vNumberDump varchar(50),

@vChar...

Hi Anup,

I would suggest you try increasing the size of the parameter from 15 to any greater value having sufficient difference say 50 or 100.

Hope this would help,

Regards

Avaneesh Bajoria

Hi,

None of the DML statements can be used in a User Defined Function(UDF)

Hence the update being one of them fails.

Regards

Avaneesh Bajoria.

Hi,

you can try out the following queries:

select * from A where A.col1 not in

(select A.Col1, from Table A, Table B where A.col1=B.col1)-- This will fetch common results in both the...

Hi,

One solution to the problem can be :

select teachid,stds from(

select t.teacherid as teachID,count(s.teacherid) as Stds from teacher t

left outer join student s on t.teacherid = s.teacherid

group by t.teacherid) as...

Hi,

to save the result to a text file, you can simple right click on the results pane in query analyser and save dialog box pops up then save it as...

Hi,

The best and most flawless solutions is to make a job. 🙂

Regards

Take Care

Avaneesh.

Hi,

I think you need to insert the following lines as well

Dim tables As New DataTable("inuse")

dim adap as new sqldataadapter

*comm is sqlcommand

comm.Connection = con

...

Hi,

you can make use of temporary table as follows:

select * into #TempTable from SourceTable

Regards,

Avaneesh.

Hi,

You can use the following query :

USE Master

select * from sysdatabases

to identify the current set of databases exiting on your sql server..

Rgds

Avaneesh.

"The severity of itch is inversely proportional to...