Change is always good. its always feels better if you found a question marked answer. 🙂

These files are located in Log with name "ERRORLOG" in the installation drive of your SQL SERVER with the following name "ERRORLOG". By Default there are three files.

you can either...

I like these true, false questions. Thanks for sharing Steve.:-)

nice question Steve, Thanks for sharing

this link will be helpful for you to get info of ReportServer database

http://sornanara.blogspot.com/search/label/Query%20ReportServer%20Database%20Tables

.

hope it helps

Prefix is...

i have checked this on 2005, 2008, 2008R2, 2012(all the x64 bit versions) and it worked perfectly. Its a very strange behavior thou. try to put the statistic on for...

dopydb (1/31/2014)

---

cheers for , this i must have a play with it to see if i can use it!

the problem is i only want the customer record ignored if...

please share sample data and expected output, and is this query for MSAccess or SQL Server?

nice question and a very handy query as well 🙂

Below code is to demonstrate the working which can be performed on the original query

DECLARE @SubQuery1 Table (

LoadNumbervarchar(20)

,CUSTOMERvarchar(20)

,PickPalletCountint

)

DECLARE @SubQuery2 TABLE(

LoadNumbervarchar(20)

,CUSTOMERvarchar(20)

,con_countINT

)

INSERT INTO @SubQuery1

Select 'AL75152','CD113', 2 UNION ALL

Select 'AL75152','GI005', 3

INSERT...

its a vehicle information system rite, which means one number can be associated with multiple customers.

and its can have standard number and customer number. if this understanding is rite then

(Data...

can you share the sample data and expected output, its still a bit unclear

you can refer to the following link for the audit log techniques.

http://www.mssqltips.com/sqlservertip/1468/designing-tables-for-audit-data-in-sql-server/

hope it helps in the process.

this solution will be bring performance issues in case of bulk operation and if this table is heavily used you will get blocking issue. you better rethink your structure.