Here is the latest: After running a DBCC CHECKDB on the primary, no errors were found. So naturally I am attempting to rebuild the mirror so I issue the "ALTER...

Thanks for the reply Hugo. This tool does do a really good job at tuning so I wont be returning it. A tool is only as good as the person...

Sorry, Answered my own question...

Open it in "Code" (XML) format then use find and replace.

But you CAN check for the exitence of a file on your user's workstation.

With the appropriate permissions on both the server and workstations such as domain admins, you can touch...

Thanks for the post Lowell. I wanted to address the permissions and shares issues with this XSP, but thank you for putting the link. I will certainly check it out.

Agreed. There are numerous other ways to check for file existence with other tools. .Net and Powershell can handle this no problem. I posted this for those situations where everything...

But you know what doesnt work (i guess it is related to the original variable posting....)

Table Variables

Doesnt like the last comma:

DECLARE @var_TableVar TABLE ([Id] INT NULL, [Col1] INT NULL,)

Works just...

Thank you very much dwain.c-

I need to run through this a little bit and modify to my "exact" environment, but prelim tests look great! Thank You very much for pointing...

Thank you everyone for the input. I greatly appreciate your time and effort. Each one of the postings gave me a different way to run with this. for the N-th...

I know... My original question back to the requestor, but yes. What we are doing is an extract of sample data to be used for testing and they want so...

This is a tough one because the use of TRANSACTION is to ENSURE that there is an explicit COMMIT or ROLLBACK and ROLLBACK is the default upon lost connection, is...

Here is the statement I come up with:

SELECT Book_Code, Price FROM mySampleData

GROUP BY Price, Book_Code

Results:

Book_CodePrice

201000

202000

302000

401000

10001000

10002000

20001000

20002000

20003000

30001000

30002000

30003000

300010040

200010045

3010050

3020075

100010085

200020085

300020085

300030099

40100100

2000300130

3000400165

1000200180

VERY VERY NICE!!!

Perfectly explained and exactly what I was looking for.

Thank You very much!

JT

😀

arslantalib (10/11/2011)

---

thanx for reply...i tried it for two resellers but it didn't successful, i have two resellerid ('10','15') both hav a book_code='40100', for resellerid=10 its price is 100, for resellerid=15...

Answered my own question, but feel it needs a post. In case someone else has the issue.

Apparently, the data flow task was created from a copy and the meta data...