Not sure what are you looking for and for what purpose. can you elaborate more with Sample data and proper structure?

No wonder my friend! It been a while Microsoft has come up with new versions and keeping few old features for backward compatibility.

There is no difference in CURRET_TIMESTAMP / GETDATE()...

I tried some ways to do this but I am not getting the expected result as mentioned in trail. Here is some workaround (see the attachment)

Hi asranantha

can you provide the sample data so that I can show UNPIVOT example.

Internally it checks the existenace of records for matching criteria and even we can introduce some indexes to get more...

That's right! nvarchar is the data type you should use for storing encrypted value as it supports to store unicode charachters.

Use Dynamic Query to do this.

declare @dtbak varchar(50) = replace(replace(getdate(), ' ', ''), ':', ''), @sql varchar(1000)

select @dtbak

set @sql = 'backup database db1 to disk=''d:\Backup\a_'+ @dtbak + '.bak''';

print @sql

You have the information with you! No worries then...

You can create the Trigger on table and check if stock code is prefix with prefix 'Y%' in magic tables. Thats it...

Use UNPIVOT operator.

e.g.

SELECT VendorID, Employee, Orders

FROM

(SELECT VendorID, Emp1, Emp2, Emp3, Emp4, Emp5

FROM pvt) AS p

UNPIVOT

(Orders FOR...

mitzyturbo (6/28/2011)

---

Wondering if anyone else has come across this problem.

I've been getting some severity level 21's on a particular database, error below:

Unable to find index entry in index ID 1,...

SQLRO (6/29/2011)

---

Table1 contains name & address concatenated together.

ID Col1

1 Name1,address1

2 name2,address2..

There are certain set of words stored in col2 of table2(~300) and those words...

Sean

Sorry about not providing the dll. I have attached the sample script. We dn't need any data with as we need to get the metadata information. Its not excatly the...

Thats bit strange ! No one replied with any suggestions :w00t:?

I am still struggling with the issue...

Have you tried with only NTML authentication?

<AuthenticationTypes>

<RSWindowsNTLM/>

</AuthenticationTypes>

One more vote 🙂 !

Logically & practically there won't be any performance impact as such.

The only differenece between using >= and > i can see here is one result...