GilaMonster (7/13/2015)

---

The order by should be removed, or moved to the query which selects from...

mattsynco (7/12/2015)

---

Im writing a query and I have to use "?" as parameters. "?" will represent two things. StartDate parameter and an EndDate parameter. I know they go in order...

gentong.bocor (7/13/2015)

---

I'm running SQL Server 2008 (x64) version.

How can i create a linked server for Microsoft Visual Foxpro databases ?

I'm using Microsoft.ACE.OLEDB.12.0 driver.

I success create a linked server, and...

Jacob,

Thanks for finding the boo-boo in my code. I didn't quite have the right condition specified, and with that method, the condition becoming correct would be ridiculouly complex, and...

drew.allen (7/10/2015)

---

sgmunson (7/10/2015)

---

Just curious as to whether you might be allowed to add the ROW_NUMBER() column to the table as a computed, persisted column... Might simplify things quite...

SimonH (7/6/2015)

---

Hi I have a table dbo.CustomerServices with over 10 Million Rows

I have none unique Indexes on CustomerID and ServiceID

I've also created a unique Index across both columns.

My delete...

Matt Miller (#4) (7/10/2015)

---

In short - no, not really, at least not from the few times I've used SSRS. Even if it were possible - what do you hope...

Jeff Moden (7/10/2015)

---

raghava_tg (7/10/2015)

---

i can't post the query , because of restrictions in my Company.

will post sample tables data and query i am using.

in the mean while can any...

Ed,

Applying the final query from the previous posts, to your situation, yields this:

DECLARE @tags AS TABLE (

TagNumber varchar(38),

Prefix varchar(7),

Number numeric(38,0)

);

INSERT INTO @tags (TagNumber, Prefix, Number)

VALUES

('840003008335608','8400030',8335608)

,('840003008335609','8400030',8335609)

,('840003008335610','8400030',8335610)

,('840003008335611','8400030',8335611)

,('840003008335612','8400030',8335612)

,('840003008335613','8400030',8335613)

,('840003108335614','8400031',8335614)

,('840003108335615','8400031',8335615)

,('840003108335616','8400031',8335616)

,('840003108335617','8400031',8335617)

,('91BDO2751','91BDO',2751)

,('91BDO2752','91BDO',2752)

,('91BDO2753','91BDO',2753)

,('91CQO2754','91CQO',2754)

,('91CQO2755','91CQO',2755)

,('91CQO2756','91CQO',2756)

,('91AEO2757','91AEO',2757)

,('91AEO2758','91AEO',2758)

,('91AEO2759','91AEO',2759)

,('91AEO2760','91AEO',2760);

WITH cteGroup AS (

SELECT T1.*,

ConsecutiveGroup =...

99zardoz (7/10/2015)

---

Hi

I have a stored procedure which returns a result set as follows:

(Headers)Total,WV1,WV2,WV3,WV4,WV5.....

(Example data) "Some total name",1,2,3,4,5.....

The WV1, WV2, WV3 column names will be different depending on parameters passed to...

raghava_tg (7/10/2015)

---

i can't post the query , because of restrictions in my Company.

will post sample tables data and query i am using.

in the mean while can any one directing...

jon.wilson (7/10/2015)

---

The FY does not match up with Calendar year.

What I'm ultimately looking for are the number of records in a given FY where the RecordDate was from...

Any chance the remote table has a constraint on the date field?

raghava_tg (7/10/2015)

---

hi Sql folks,

i am using open query in ms sql 2012 to access some data from my sql using tables and joinings.

in the query , i am using some...

Given that you have the DATE_FY field to determine your fiscal year, the question is, does your fiscal year ALWAYS match your calendar year? (I'm also assuming that both OccurrenceDate...