tell me whether i am right in understanding your problem

u have stored procedure with select query and you connecting this stored procedure to you db grid control. when you add...

Stuart (3/31/2008)

---

Hi

I have an Exec SQL Task that runs a simple insert statement but is it possible to capture the @@rowcount value and to map the resulting value to a...

patcherke (3/31/2008)

---

found the error : since it was SQLexpress, It seems I have to enter the servername

syntax will look like this :

bcp "SELECT line from WMSFSTD42.dbo.t_conversion_lines order by...

no steve it is...

ramadesai108 (3/28/2008)

---

Hi all,

I am trying to insert a new record in true db grid with bound data from a vb6 application. The bound control is connecting...

Jeff Moden (4/1/2008)

---

GSquared (4/1/2008)

---

select dateadd(month, 1, cast(enddate + '01' as datetime)) - 1

from dbo.sasimp

Should give you what you need. If it gives you an error about converting enddate to...

Hi Michal

From my experience you cant know query cost before selecting record but only after you can see the query cost by following statement

SET STATISTICS I0 ON

SET...

dont stick on your points only

you must listen other points also

many cases you are right, like you others points also right

i want remind you that it is the discusson not...

HI All

The query will work without any error. the suggested answer is wrong

the answer for the question is

Retrieve all columns additionally the date column as a atfirst column

by all

shamsudheen

hi blahknow

infact i am using sybase only now, i did read one article before to calculate row count of tables. which says

Declare @row_cnt INT

SELECT @row_cnt = rowcnt from...

hi Diann

i am confused at first you asked solution for if condition and

john rowan replied the solution and told that it is working

at the end you telling you required not...

hi

there is no array types in sql server. but we can use function with temp table to work like arrays .

you can see the techniq from following address

http://www.sommarskog.se/arrays-in-sql.html

hope...

Hi Steve

this is shamsudheen following is pasted line from your editorial words

There are lots of people that would just like to do their jobs well and not be the...

derived table concept is very usefull from seeing performance issues

it is very good article

i was using derived table , but my current company not advicing me to use, since here...