are you asking about the .net development side of it?

if yes, you can take a look at this one:

http://www.codeproject.com/Articles/675933/Returning-Multiple-Result-Sets-from-an-Entity-Fram

this is using a stored proc in an EF model.

Yes, That's right

In cases like this, when I concat column data together I always use a special character as a separator to make sure that kind of conflict won't happen.

No, you cannot use it like that

you are going to have to use Dynamic SQL and exec command to accomplish this type of commands

gary.morey (12/9/2013)

---

I have 2 tables. Each one has the following columns: SSN, PKT and FICE_NBR.

I need to be able to retrieve the rows from table A where the...

I think for the NULL values you can set the default value for the column to 0 in the column definition, so when the data is not provided, it will...

bkshn (12/3/2013)

---

Hello

I define a temp table to fill with execution of stored procedure, but I have an error that

Invalid object name '##UserMidListTable'

is my syntax in temp table wrong?

...

why don't you try the SQL Server Partitioning instead of trying to manually implement such a thing?

If I am understanding correctly, you only are doing this because the table is...

newbieuser (12/2/2013)

---

Hi friends,

I'm trying to import customer's SQL 2005 database(database.bak) onto our SQL Server 2012 server. I right clicked on database in the Management studio 2012 , restore...

dndaughtery (11/26/2013)

---

I had a collegue write the following query. He got defensive when I asked what he was trying to accomplish with it.

Select count(*) from tblevent a inner join...

I assume By "Locked" you mean Encrypted? are you seeing this little Lock icon over your stored procedures names?

If that is the case, I dont think you can Decrypt them...

imrsam2002 (7/14/2012)

---

Hi all, this is my first ever post on ssc. I've just passed my MCTS 70-432 SQL Server 2008 Implementation/Maintenance exam with a high score and would like to...

maybe you need to install a new instance of sql server,

the default probably has beenused for your 2005 version

while istalling the wizard will show you the installed instances and will...

hey i think i found my solution:

CREATE VIEW UV_ProductsPrices

AS

WITH PriceCompare AS (

SELECT i.productid ,ph.actiondate,ph.feebuy,ph.feesale,ph.feeenduser,ROW_NUMBER() OVER (Partition BY ph.ProductId ORDER BY...

hi

i thing the solution in sql2000 is that you may need to use a temp table and try somthing like this for generating a row_number

SELECT IDENTITY(int, 1,1) AS ID_Num

INTO NewTable

FROM...

hi

i think gsquare's solution is verywell,

works fine