selvakumar.sms (4/16/2012)

---

hi

how to access multi user in remote desktop connection of ms server.plz give any idea. i want to connect more than one person...

sqlbi.vvamsi (4/16/2012)

---

Ok. Here it is

CREATE TABLE [dbo].[test](

[a] [numeric] NULL,

[date] NULL

) ON [PRIMARY]

GO

ab

11981-08-14

21985-10-03

32012-04-13

select SUM(a) from test group by b having b=CONVERT(date,GETDATE())--This returns nothing

select SUM(a) from test where b=CONVERT(date,GETDATE())--This returns...

Phil Parkin (4/16/2012)

---

Read up on...

Jeremy... (4/16/2012)

---

I'm having an issue with this case statement:

CASE WHEN CLPCR.LicenseExpirationDate IS NOT NULL THEN CAST(CLPCR.LicenseExpirationDate AS DATE)

WHEN CLPCR.LicenseExpirationDate IS NULL THEN 'Perpetual' END AS 'Expiration'

When executing, i get...

Really? Try running this code:

WITH TestData(dates) AS (

SELECT

...

Those are table alaises, and I highly recomment using them. In fact, I should have...

sqlbi.vvamsi (4/16/2012)

---

true, I want sum(a) in the query that is why I'm using a group by there. Below is the exact query I'm trying.

select sum(a) from dbo.test group by b...

Your requirements may have changed, but ours hasn't. Following the link in...

Rob Schripsema (4/16/2012)

---

If the range of values for u.selection and u.period are constrained to single digit integers [1-9], why not skip the cast as varchar/int parts and just work with...

sqlbi.vvamsi (4/16/2012)

---

Hello,

I've a table with a numeric and date columns. Assuming a,b are the column names, I'm writing a query which isn't returning any rows. Below is the query

select *...

Something like this:

CREATE TABLE #users(id INT PRIMARY KEY, selection INT, period INT)

INSERT #users VALUES (1, 1, 1)

INSERT #users VALUES (2, 1, 2)

INSERT #users VALUES (3, 1, 3)

INSERT #users VALUES (4,...

Really, then show us how the calculation is being made....

I don't see a column #users.number in your definition shown above.

hbtkp (4/16/2012)

---

MAY BE U CAN understand by this

NUMBER CUMULATIVE

...

Shouldn't have any issues since both are running SQL Server 2008 R2. You may want to be sure they are both a the same build level.