Jan Sorenson (10/19/2012)

---

Is it possible to grant access to specific columns in a table with restriction to the data with a where clause? Similar to building a view but...

Here is another way to do it if you have a Tally table. You could insert the output of this into a permanent table and assign a RowNum using ROW_NUMBER...

deepeshdhake (10/19/2012)

---

Hello,

Using the table EmpHistory, it is not satisfying all the rules. So I want to use this function as it satisfies all the rules. This is what I want:

I...

vs.satheesh (10/19/2012)

---

Hi All

In My project one table my old employees using following format id generation.Hoe to generate this sequence...

Grant Fritchey (10/19/2012)

---

Sean Lange (10/19/2012)

---

Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes....

BOL is the best place for this kind of stuff. http://msdn.microsoft.com/en-us/library/bb510489.aspx

If...

Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes. No other sites are...

rocky_498 (10/19/2012)

---

Some body ask this question during interview. I didn't the answer i would like to know if someone give me the answer of

this simple or tuff question.

Q) What...

You might look into table parameters too. This seems like a good candidate for one.

What you are describing is a process not an event. There isn't a book you can read and when you finish you are now able to write efficient queries. One...

ericb1 (10/19/2012)

---

Sorry, thanks for the help. The first query is from a custom SQL database, the results of the query give me this:

reviewer accountid accounttypeid...

valentina1983 (10/19/2012)

---

Hey guys ,

I'm new here and I really need your help.

I need to write a script that creates registration (for first visit to the website) and then login...

jbalbo (10/19/2012)

---

Thanks... fixed it. dumb on my part... thanks

I don't know whats going on with the nolicks, I inherited this.

to be honest, newer at this and not sure what it...

This looked like an extremely odd situation but a fun challenge. It can in fact be accomplished without loops. You have to combine a couple of techniques, both the delimited...

yuvipoy (10/19/2012)

---

Hi

I am getting the error as

declare @pi_input varchar(max)

declare @query varchar(max)

select @pi_input ='0123456'

SET @query = N'Select '+'SUBSTRING(@Input,'+convert(varchar,0) +',1)'

print @query

exec (@query)

Select SUBSTRING(@Input,0,1)

Msg 137, Level 15, State...