waxingsatirical (9/29/2011)

---

Hi Guys,

There is a particular statement in one of my stored procedures that is causing me a headache. As far as I can see it's a very straight forward...

pespes009 (9/29/2011)

---

Urgent help please

Ways to Improve this function:

CREATE FUNCTION [dbo].[LBS_Quotes_GetEarliestCurrentVariantCode]

(

@p_quote_idINT

)

RETURNS VARCHAR(1)

AS

BEGIN

-- declare temporary variables

DECLARE@ResultVARCHAR(1),

@count_oldINT,

@count_preINT

-- count number of old and pre-current vehicles in the quote

SELECT@count_old= SUM(case when v.current_variant = 'O'...

mjbkm (9/28/2011)

---

Also - you said:

"It is also possible the inserts are not actually going to the end of the table, but are being inserted all over the table, then the...

kishoremania (9/28/2011)

---

Actually the data will be like

10 1 1

10 1 2

10 2 1

10 2 2

10 3 1

10 3 2

11 1 1

11 1 2

11 2 1

11...

mjbkm (9/28/2011)

---

OK - Now I am really confused and need help understanding this. Uggg.

I have a query that was running really slow with a huge table. The indexes...

rashid_alavi (9/28/2011)

---

Hello All experts,

I have requirment to run the queries against three tables with left outer join,

it has give all the all rows from a table and plus matching...

So how about:

select a,...

kishoremania (9/28/2011)

---

I am showing you dummy data

select A,B,C from TEST

Output:

10 1 1

10 1 2

10 2 1

10 2 2

10 3 1

10 3 2

I need a query to get the record of...

sjerromeharris (9/27/2011)

---

There is a table in my database that stores client information. There is a second table which stores details for people who might be contacts for that client....

zwheeler (9/28/2011)

---

Hi

I am using the round function in my select statement and it works for the following

Round(avg(h.mtr_fass_score)) as mtr_fass, <------THIS WORKS

Round(avg(case when p.mtr_unit_count...

le fevre (9/28/2011)

---

Hello.

Iam at the moment working on a projekt for at company, where I did make a MsSql database to contain data for different servers.

Basis

Many of the servers...

Amy.G (9/26/2011)

---

I have a general question about a certain type of SQL query. This is where instead of typing somehting like:

SELECT Var1

FROM Table1

Somethimg more like this is used:

DECLARE

wshmstr (9/25/2011)

---

Hi,

There's an option called CONTEXT_INFO() for using it as @@MYGLOBALVARIABLE.

I can use it like:

DECLARE @userid BINARY(128)

SET @userid = CAST(132456789 AS BINARY(128))

SET CONTEXT_INFO @userid

Then:

SELECT...

ggoble (9/23/2011)

---

Unfortunatly no. default is set to master.

Another note... I've went onto both the production server where the database is being backed up from and the server...

ggoble (9/23/2011)

---

I'm trying to restore an HP Quality Center database with full text catalog and the restore works initially however, when i try to restore it again my "ALTER DATABASE"...