GRANT select on SomeView to SomeUser

davdam8 (10/22/2012)

---

Thanks

Im using:

SELECT PROJ, CARAC

FROM X

ORDER BY CASE WHEN MSP_LOOKUP_TABLE_VALUES.LT_VALUE_TEXT = 'None' THEN MSP_LOOKUP_TABLE_VALUES.LT_VALUE_TEXT END DESC

But it gives me repetitive results. Like 2...

Then you need to figure out what you need to store. What are the entities in this system? What...

wailoon.ho (10/22/2012)

---

Hi

My application need at least 2 approval for an request.

I need to generate a report to count which combinations are the most.

example

ApplicationIDDateTimeApprovalUserID

110/10/20121

110/10/20122

110/10/20123

211/10/20121

211/10/20123

312/10/20122

312/10/20123

413/10/20121

413/10/20122

514/10/20121

514/10/20123

615/10/20121

615/10/20123

716/10/20121

716/10/20122

My report should show

Approval1Approval2Approval3Count

1231

122

133

231

I manage to the the...

graham 47698 (10/19/2012)

---

Hi

I have a table which has columns containing sales values for each month for example..

Id, versionId, jul,aug,sep,oct,nov,dec,jan,feb,mar,apr,may,jun

The 'versionId' joins to the period table which has the end dates...

AVB (10/22/2012)

---

I'm building an import package for a CSV file that has about 200 columns. If every column was maxed out it would be about 2200 bytes and is well...

SQLLux (10/22/2012)

---

CREATE FUNCTION dbo.Split

(

@String varchar(8000),

@Delimiter char(1),

@RetStrPos int

)

returns varchar(100)

as

begin

declare @idx int

declare @slice varchar(8000)

declare...

With the total lack of information there is little anybody can do to help here. However, your dynamic sql is full of errors. You are not escaping your single quotes...

naqib_bs (10/22/2012)

---

Hello everyone,

I have recently joined Ms Products, we have a Database server in SQL Server 2000(located in X computer). I want

to connect SQL Server 2000...

info 58414 (10/22/2012)

---

Hello,

i am searching for a StoredProcedureGenerator-Tool to generate Insert, Update, Delete, and Select Stored Procedures (SQL-Server) for selected tables for a particular database.

what would you recommend? ....stand-alone...

santa326 (10/19/2012)

---

Hi Sean,

Thanks for the response.

Number of resulting coloumns will be consistant.

From the query you posted ,i could not get the...

Awesome job posting sample data and desired output in a readily consumable format. That makes this a LOT easier.

There are two techniques involved here. The first is to split the...

Yes, SSIS. This is the very first line of that article.

The Export Column transformation reads...

So just telling us that the table value function returns the same thing as table is not helpful. We speak in t-sql around here. Why would you have a table...

You might also consider changing your where clause so you can avoid the index scan on Cap. Change the condition to greater than and you should see some improved performance...