I agree 100% with Chris. The easiest way to prevent sql injection in this is...

There are a couple of issue with this code. First is nonSARGable. You are doing date conversion functions in your where clause so you will be stuck with index scans.

Something...

This sounds a job for SSIS. No sql script is going to be very efficient at doing that sort of thing.

Here is one of thousands of places to get started....

raghuldrag (7/24/2012)

---

in that same procedure i want to the column of

prev_colsing_bal =(

...

I think you should take a look at this article. http://www.sqlservercentral.com/articles/T-SQL/71550/%5B/url%5D

It seems to be exactly what you are looking for.

seshu2all (7/23/2012)

---

Thanks, Sean.

From MSDN, what i could see is to grant permissions to all the views & functions separately. So, your query would help me generating a batch to execute...

Jan Van der Eecken (7/23/2012)

---

@ Sean

surely you meant

declare @MyTest int = 436

select * from Tally where N < @MyTest

select * from Tally where @MyTest > N --identical but makes me...

If you want some help you have to help us. Please provide enough information to give someone a chance at answering. We don't have ddl, sample data, desired output or...

To add to Capn's response, the following script can be tweaked to generate the sql you need.

declare @login VARCHAR(30) = 'UserID'

SELECT 'Grant View Definition ON ' + schema_name(schema_id) + '.'...

We don't even know what the question is yet. You talk about making 1 table into 5. We don't...

weston_086 (7/23/2012)

---

I have two inputs “address” and “net” . I may have to convert these two inputs into binary form. And then apply logic “AND” function....

Is this a blog post or a request for help?

Your splitter is not the most optimal. Take a look at the link in my signature for splitting strings.

That aside...

Not sure about Lynn but my crystal ball is still broken. We can't see your screen, we have no idea how you want to map these columns, we still don't...

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1333964-150-1.aspx

Is there a question here?