in the recordset SELECTED for the user, or the server-side table?

lemonsqueezy101 (12/12/2008)

---

I'm sure it's me that's missing something not you!

From what I can gather, you're saying I can use the value I have that was entered via the DDL, check...

lemonsqueezy101 (12/12/2008)

---

Hi Chris,

I already have the currency name and currency symbol list in a table with the Currency Name populating the drop down list the user will select from.

This DDL...

lemonsqueezy101 (12/12/2008)

---

Hi Guys,

I have a requirement to store the currency name and the currency symbol for a record inserted by a user. I only want to have the user select...

Here's what the code looks like when it's given a bit of a cleanup:

[font="Courier New"]SELECT T1.PROJ_ID + SPACE(1) + T2.PROJ_NAME AS Project, -- fn CONCAT is an XQUERY function

   T4.org_name...

sunil.si (12/12/2008)

---

Can anyone help to find the syntax error in this query?

@query = 'select empID from EducationDepartment where DateDiff(hh, checkInTime, getdate()) > 2 and userPriority = 1 and status !=...

sujiakm (12/11/2008)

---

Hi.. appreciate your immediate reply...

.. in this query I am trying to run an INSERT cmd , which inserts the data collected at the LinkedServer into a local...

pushalydan (12/11/2008)

---

Can you please help me resolve this issue:

I have a temp table called temp_phone_interval, when I run this query:

select max(currdate) as rpt_date, sum(ivr2q) as total_calls, sum(q2assagt+q2agt)as ans_calls, sum(q2assagt+q2agt+qabn)/sum(ivr2q)...

jeffrey_bryant (12/11/2008)

---

It works!!!

I went with the original solution. It got what I needed but am going to try out Jeff's cursor'less version just to see how it works.

Thanks for the...

Lynn Pettis (12/11/2008)

---

Why would I do that? I am a born and raised Coloradoian. I love it here, it's Gods...

Josh Turley (12/11/2008)

---

SELECT 'Company A', 'Web', '01/01/2006' UNION ALL

SELECT 'Company B', 'Tradeshow', '10/03/05' UNION ALL

SELECT 'Company B', 'Magazine', '12/05/04' UNION ALL

SELECT 'Company C', 'Company A', '09/05/06' UNION ALL

SELECT 'Company C',...

Ian (12/10/2008)

---

Actually, the current DB design allows for multiple sub cats, so you could have Category/sub/subsub/subsubsub and so on, but the data I am using only goes to a...

Like this?

SET DATEFORMAT MDY

CREATE TABLE #referrals (company VARCHAR(10), referral VARCHAR(20), referral_date DATETIME)

INSERT INTO #referrals (company, referral, referral_date)

SELECT 'Company A', 'Web', '01/01/2006' UNION ALL

SELECT 'Company B', 'Tradeshow', '10/03/05' UNION ALL

SELECT 'Company...

Lynn, have you considered moving to Ohio[/url]?

Nomvula (12/10/2008)

---

hi

i'm not sure whether it's possible, i have data in my excel sheet of which i need to create a script from my sql database and join the fields...