tinausa (7/13/2012)

---

Thanks. I did not think this was necessary info, so I did not mention it earlier.

But this query is an ASP.NET app where the user will enter from and...

somehwere inside your procedure, you are...

anthony and i are on the same page 😀

so you want everything from 2011 plus just january of 2012?

i'd think this will do what you are asking:

SELECT

*

FROM [AllData]

WHERE [YearEnd] = 2011

...

i'm guessing if you wanted all months, it should be like this instead:

SELECT * FROM [AllData] WHERE

(([MonthEnd] >= 1

AND ([YearEnd] >= 2011)

--here is the fix!

AND ([MonthEnd] <= 12)

...

there's a neat trick using FOR XML you can use to concatinate rows into a delimited list.

is this what you are looking for?

SELECT DISTINCT

...

Lucky9 (7/13/2012)

---

I have to redesign the Database...To do that first i have to identify the Risk Analysis of the current database.....

So i would like to know the steps required to...

it sort of depends on what you mean by risk analysis;

here's one whitepaper that might help:

http://www.almaden.ibm.com/cs/people/peterh/172.pdf

are you looking for the potential for data loss?

stolen credit card numbers?

folks who have...

what are you having trouble with?

format files are not always needed, so we need a bit more information.

if you have an existing table structure, you can create a format file...

not offhand, sorry; i only looked briefly at teh psot i showed you, and would have to read up on it;

it really does sound like soemthing i'd put into a...

one of the links here:

http://charlottecredittechnology.blogspot.com/2008/11/sql-2008-excel-like-linest-function.html

seems to have a proc/function that i found after searching for sql server excel linest equivilent

here's my best guess getting the date ranges; i leave it up to you to convert it to the cross tabl format, and whatever the data is you want in...

glad I could help a little bit Jerry; you probably had 99% of it, except for that last part, right?

it's always the little things!

i was still looking at this as it kind of caught my interest.

i'm trying to get a working example of multi threads to work; each thread would call my DoStuff...

here's the vb.Net code to do what you were doing in VBA.

if you grab a code sample from my previous link, you could see how to spawn , say, 10...