bery cool. i will take that and use it for my own. a little more intense on the system but much less code

I’m converting a client’s db to our internal structure. In doing so I need to bring their files down. Import them into sql then convert them to my internal structure....

ah. row number w partition. nice. i was about to cross apply it to itself to get the darn id to reset. thanks

run the insert and select. Notice there is no id col being retruned. It's in the desired output. i need to find a way to generate that id patter in...

I need to generate the id col values. I don’t know how to make a rank or rownumber reset.

notice it goes back to one. When it gets to a new...

i got it. Really cool dynamic solution

DECLARE @columns NVARCHAR(MAX), @sql NVARCHAR(MAX);

SET @columns = N'';

SELECT @columns += N', p.' + QUOTENAME(colname)

FROM (

SELECT o.colname

FROM [dbo].[conv_onet_update_sourceTable_test] o

GROUP BY o.colname

) AS...

is there data in the other fields of your detail table and ur app is not pulling it back? or is there no data for all the other columns in...

again i'm not a front end guy but we used entity framework which i thought used link when u used the sql objects for querries it called them as dynamic...

linq is for front end developers who have to build a database driven site w/o having extensive sql development knowledge.

u can prob write linq in a fashion that it would...

actually. no. i shouldn't have any security issues running sql smd prompt manually. i was thinking of running it in script call or via job. I'll give that a try...

Oh, and as far as Joe goes. As my dad used to say. "Every a-hole's got an opinion." I thought it was funny. I sent the post to all my...

1) Sql cmd exe is disabled on all prod sql instances due to security issues.

2) I can’t add them all to 1 script because it’s dropping and creating objects...

lol. CELKO. Easy there. Not only is this not my code but there’s darn near 200,000 lines of it across 30 scripts that will have to run next week. I...

i suppose i could use sql cmdshell to call a .sql file and put them in sequencial steps in a job. That would also allow for me to track runtime...

i suppose i could if i had to however some of them are dependent. So, I'd have to modify the contents or add some sort of try catch or error...