Join the social network of Tech Nerds, increase skill rank, get work, manage projects...


  • No Featured Found!



How to Merge XML CTE's in SQL Server Using Common Refid Key

I have the following CTE's, and I'm trying to combine XML1 and XML2 CTE's in Sql Server by their common refid key. ;With TBL1_Fruits As (Select '1' as refid, 'Apples' as fruits, 'Red' a...

Why am I getting null values for lease_id in Rent?

Passing primary key values in the parent table to foreign key values in child table with parent insert and child insert being in separate stored procedures.   Parent is Lease table, the child is Rent table. I am getting null value...
Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: