You can also do this 🙂

if ('c'+@a+'c') = ('c'+@b+'c' )

print 'True'

else print 'False'

Sanaullah (7/7/2008)

---

Hi All,

Here i am having two tables Table1 and Table2 and both the tables are having same number of records and columns i.e 14522, now see the problem.

when i...

Hi Chris,

Thanks for the post dear.

I am aware that I have posted in SQL 2k forum.

Thought that the logic/query I have posted might be helpful to our dear friends...

Hi Jeff, In this query, the condition is rightly mentioned as rowno>1 and shouldn't be rowno=1

What the purpose of this query is to remove all duplicate records except one record....

Yes Mr. Actually I have read the requirements and I have correctly suggested the intended solution to delete duplicate records.

Although I have intentionally mentioned it for SQL SERVER 2005,...

Hi, use this query.. It is very important to delete duplicate records 🙂

;with remove_dup as

(

select rowno=row_number()

over(partition by name order...

You can do following if your start_date is of character type and you have problems comparing the date columns:

select * from tablexyz

where convert(datetime,convert(varchar(10), getdate(), 101)) between '01/01/2008' and '02/25/2008'

--date format...

U can have a look at such links

http://www.programurl.com/swissql-sql-server-to-oracle-migration-tool.htm

NOTHING IS IMPOSSIBLE WITH SMART WORK🙂

You can use ISDATE() function to handle NULL values instead of using ISNULL

SELECT user_key User_id, update_date createDate

FROM accounting.dbo.user

WHERE user_key NOT IN

(

SELECT DISTINCT CONVERT(INT, RIGHT(vendor, LEN(vendor)-1)) user_key

FROM Prod.dbo.return_vendors)

AND ISDATE(update_date)=1

AND update_date...

We have successfully pulled data from AS400 to SQL Server 2005 using Ritmo .NET Provider for AS400. You can search for it on Google, it's documentation is included in the...

It is much more convenient to use temp tables while using stored procedure if the views are not created in the first place. If you think that you will be...

Ya definitely u should have resolved ur problem using indirect configuration via envi variable and xml config file. But dont ever forget to set ProtectionLevel property to 'dontSaveSensitive' otherwise the...

Ya steve, you are absolutely correct. I agree with you cent percent. I also thought the same way and good that you think the correct solution to this problem