Search results for query: *

It appears [sys].[sp_columns_100_rowset] simply returns schema data for a DB, or table. I see it being called in a trace I have on a DB, but I'm not sure why a process would use this system SP. It's being called via RPC by VS2013 application. (Either manually, or automated - I can't tell.) Any...

Thanks everyone! :-)

To be more specific, I need to create a column populated with names that are semi-colon delimited. I do have this, but would like to insert into separate rows into a single column. DECLARE @TestString varchar(max), @NewString varchar(max) SET @TestString...

I have this list: Name1;Name2;Name3; etc. And need to write code to pivot it to this: Name1 Name2 Name3 Any suggestions?

I'm afraid my example was too simple. Your example does work - If the values were the same. (And I appreciate the response.) This is a better example of my resultset: Column1 Column2 column3 Column4 Column5 etc... John Attended John Unattended John...

I have a table that spills out this way: Column1 Column2 column3 Column4 Column5 etc... John Attended John Attended John Attended Tom Attended Tom...

Thanks Jefferson! This is a quick and easy way of adding a copy! I appreciate your answer. :-)

Thanks for everyone's input. I never found the syntax for my approach, but I did find an alternative using conditional split. https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/ Thanks again!

Yes, I was already aware of that from my testing. thanks for your input, however. :-)

Yes i'm aware that drop table drops the table, however from the link I provided it was suggested a cell range could be dropped. If it cant, it cant, but if I'm on the right track I'm asking for syntax help. Th sheet name length is irrelevant to my issue.

I'm trying to delete two specific cells in a ss. (A32 and A33) I'm using an Exxecute SQL task to do this. I've seen examples online that show this syntax: Drop Table ['My Sheet Summ$A32:A33'] - The name of my sheet is ['Agent Summary Report-Agent Summ$'] This doesn't work, since it can't find...

I'm trying to delete two specific cells in a ss. (A32 and A33) I'm using an Exxecute SQL task to do this. I've seen examples online that show this syntax: Drop Table ['My Sheet Summ$A32:A33'] - The name of my sheet is ['Agent Summary Report-Agent Summ$'] This doesn't work, since it can't find...

I have a report I checked-out and I want to simply open the rdl (Not in XML) and save it as a new name in my file system. (Make a copy as a new template.) I can't seem to open the rdl after I check it out. It defaults to the XML view. What am I doing wrong? VS 2008 is what I build reports in.

I'm getting an unhandled exception error for the designer when starting a NEW Silverlight application: System.NullReferenceException Object reference not set to an instance of an object. at...

That's very clever PWise! Thanks for that option!

I appreciate ALL feedback! :-) Olaf, I'm not INSISTING there should be a function. I'm simply ASKING. :-) Borislave - that is very cool! Much appreciated!

That is certainly creative - however I'm not sure that it would be a better option than comparing two substrings. :-)

Is there a function that will help me check a field for a repetition of characters in a single field? Such as: Field1 ------- AAAAAAAA 00000000 44444444 Currently I use substring to check to see if the first four characters = the last four characters. If substring(Field1, 1, 4) =...

Thanks fredericofonseca - I did fail to show the set value. :-) The table is highly denormalized, yes. It's a proprietary format for a flat file creation. I don't control the table design. I'll test case suggestion. Thanks everyone!

I feel like I have a lot of code that could definitely be written better. Here is one example: I have 20 fields that need updating from a temp table (#Final) that has a numeric counter field (MyCount). Currently I have 20 sets of updates for each field. UPDATE MainTable SET Field1 FROM...