So if you...

redy007 (8/6/2013)

---

Hello guys,

I am new in t-sql (started today). Could you help me with the issue I have?

on line 14 (if EXISTS(SELECT * from @table_name)) the output is

Lookup...

muthyala_51 (8/6/2013)

---

The problem is we have too many tables which are inter related....

No problem. Sometimes it is just the second set of eyes needed to look at the problem. Happy to help.

Sounds good. I am sure that if I am not able to help you that some of the...

muthyala_51 (8/6/2013)

---

I am working on a project to help developers to know the relationship between the tables. Let us assume pk in table A is foreign key constrain in table...

freecoder (8/6/2013)

---

You are right

The sample data is very different.

I just wanted to give a hint ..how the table should look like..its not actual representation of the data..

hope it makes sense?...

Lrobinson 93181 (8/6/2013)

---

I have provided the code and an example of the expected result set...so I am not sure what doesn't make sense? Maybe a step-by-step would help...it took me...

Maybe I am missing something but your sample data does not seem to make sense compared to the picture you posted for desired output. You have 3 rows and they...

Your table and the sample data don't seem to line up very well. First you were inserting the identity but when I removed that there are datatype mismatches. Is LeaveTypeName...

karunakar2351 (8/6/2013)

---

Code:

SELECT

IDENTITY(INT,1,1) AS D_Key,

C_Key,

D_Num,

D_Name,

D_Address

INTO D_Table2

FROM D_Table1

I need to populate a table based on results from a query. If I do:

INSERT INTO table2

SELECT

IDENTITY(INT,1,1) AS D_Key,

C_Key,

D_Num,

D_Name,

D_Address

FROM D_Table1

It gives me...

This produces the same results.

select name , convert(int, LOGINPROPERTY(name, 'BadPasswordCount')),

convert(datetime, LOGINPROPERTY(name, 'BadPasswordTime')),

convert(datetime, LOGINPROPERTY(name, 'DaysUntilExpiration')),

convert(datetime, LOGINPROPERTY(name, 'LockoutTime')),

convert(int, LOGINPROPERTY('loginname', 'IsLocked')),

convert(datetime, LOGINPROPERTY(name, 'PasswordLastSetTime')),

DATEADD(DD, 90, (convert(datetime, LOGINPROPERTY(name, 'PasswordLastSetTime'))))

from sys.server_principals

where type = 'S' and is_disabled...

Lrobinson 93181 (8/6/2013)

---

I have provided the code and an example of the expected result set...so I am not sure what doesn't make sense? Maybe a step-by-step would help...it took me...

What you are describing is string parsing. While the article referenced above is ok, the one in my signature has a version that is way faster than xml parsing. I...

Thanks for the ddl and data. What I don't understand is the desired output. Since WKBW has a bit fewer rows let's look at that one.

OUTPUT

WKBW 7/5/13 12:00 PM 7/5/13...