krayknot (11/24/2008)

---

Kiran Kumar MP (11/24/2008)

---

the table is having lakhs of rows.if i select a date range from 1-10

there should be fixed (Tenor) column for alll date ranges and other columns...

Kiran Kumar MP (11/24/2008)

---

the table is having lakhs of rows.if i select a date range from 1-10

there should be fixed (Tenor) column for alll date ranges and other columns are...

Patrick Ige (11/24/2008)

---

I have and update and insert statement in a stored proc like so:

If Exists (Select * From table WHERE a=@a and b=@b)

update table

set

a= @a,

b=@b

from table...

Kiran Kumar MP (11/24/2008)

---

Hi I have a table A

----------------------------------------

Date 1M 2m 3m...

mblack (11/21/2008)

---

I'm hoping to learn more about when to use a view and the correct to use a view.

Overview:

I use stored procedures to return information to the website for reports...

Merge both the stored procedures in one. and if not possible then

use separate command object for separate for separate...

karthikeyankasi (11/24/2008)

---

Hi All,

I am having one Sqltransaction in C# code, through this transaction am accessing a table T1.

Inside this transaction there are two operations,

1. Inserting a new record R1...

garethmann101 (10/29/2008)

---

Hi, just started migrating from SQL Server 2000 to the free version of SQL Server 2005.

In the SQL 2000 Enterprise Manager you could simply right-click on a database...

sukusupremo15 (11/21/2008)

---

HI, Actually I will get 5 sets of results from a query. And I need to paste this results into an excel sheet(single sheet). Is there any way of...

check the LockEscalation event in the...

donnelcyril (11/23/2008)

---

Hi,

Please help me with the following query:

It is giving this weird error giving me no idea where to start looking:

Msg 248, Level 16, State 1, Line 1

The conversion...

You can also create global temporary tables. These are named with two pound signs. For example, ##YakHerders is a global temporary table. Global temporary tables are visible to all SQL...

Nuts (11/23/2008)

---

Hi Guys

I created a temp table in Management studion and when I try to access this temp table through BI using select * , it gives an error saying...

anupamabr (11/13/2008)

---

Hi

I am new to Sql

I created asp.net web project.I need to connect this website to my locally installed database

.For that I need to modify the connection string of...

tuthuan (11/12/2008)

---

Hi everyone,

currently I need to install a SQL-2005 server on an existing SQL-2000 server server.

If you have done this before, would you kindly give me some notices how to...