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...

typically, you want to insert into a temp table, so you get everything in a single table for ease of review.

this seems to have worked for me:

USE master;

GO

IF (SELECT OBJECT_ID('Tempdb.dbo.#TBHELPUSER'))...

in a programming language, you could use a thread pool and spawn mulktiple asyncronous commands, like the code you are using to refresh each excel spreadsheet.

you'd have to convert from...