This topic came up a few months ago and I posted a really NASTY ugly cursor based dynamic sql solution that I created about a decade ago. Lowell also posted...

I think the more important question is how can you eliminate your cursor and therefore not really care about some of the subtle details. 😛

Honestly cursors are one the most...

That error message is pretty self explanatory. You did not provide the required parameter to sql. I see a lot of c# code referencing a user defined data access piece....

As long as the instance name stays the same (or it isn't a named instance) the connection string should remain the same as it was before.

Yeah you have two controls with the name Label1. This of course has nothing to do with sql and everything to do with your web form code.

Daryl AZ (8/11/2011)

---

Create a function that takes a comma delimited sting and returns a two column table. (ID, LookupValue)

Select yada

FROM MyTable

Left Join fnc_tableFromString(@argMyString) theName ON myTable.name = theName.name

where myTable.id...

That is trying to assign two string values to a single variable.

You might need something like

@loginnames= '''XYZ'', ''SQL'''

Of course you need to have a plan of actually...

Another important thing to note, you are using select * in your view. This will hold the current columns at the time you build the view. It will NOT be...

Not much detail to go on there but take a look at substring and charindex. Should get you started in the right direction.

If you want fixed length use a fixed length datatype.

cast( zip_code AS char(9))

That will effectively right pad your data.

User defined routine, trigger or aggregate tried to rollback a transaction that is not started in that CLR level. An exception will be thrown to prevent execution of rest of...

You have an extra comma at the end of the last parameter.

Minaz Amin (8/10/2011)

---

Hi All,

I want to have a general statement which depending on the parameter I provide will create a view with the column names from the tables.

This can...

Best source of any documentation is BOL. The partition will be found as part of the syntax for ROW_NUMBER.

It is not on the Reserved word list from Microsoft. Not sure why that one visually looks like a keyword.