L' Eomot Inversé (4/18/2013)

---

What concerns me most though is one thing that Donna said: that this has made he think twice before posting a request for help. That surely...

britinusa (4/18/2013)

---

Seems simple enuf?

So I have a datetime field in a db which happens to be 04/10/2013

I do a

select * from orders

where

create_date like '%/10/%'

returns nothing.

So clear not...

kalpit_yellow (4/18/2013)

---

Following script by Ashish Jain fixed my issue 🙂

CREATE FUNCTION dbo.DistinctList

(

@List VARCHAR(MAX),

@Delim CHAR

)

RETURNS

VARCHAR(MAX)

AS

BEGIN

DECLARE @ParsedList TABLE

(

Item VARCHAR(MAX)

)

...

Stephanie Giovannini (4/18/2013)

---

I'm trying to help my client solve an issue with frequent "breaking changes" to procedures that use table-valued-parameters.

The calling code is in a highly branched environment, but...

patrickmcginnis59 10839 (4/18/2013)

---

Also, keep in mind, many of the "highly rated" posters actually get points for posting rote replies like "see this post for instructions on how to submit your...

kalpit_yellow (4/18/2013)

---

Hi,

I am working on stored proc to update master table from temp table and getting following issue.

temp_table

sa, Logger, Reader

master_table

sa, Reader

Reqired_Output_On_master_table

sa, Reader, Logger

So i only want to add...

You haven't posted anywhere near enough details to offer much help here. I don't even know what the question is. I don't know that in this case you need to...

sivajii (4/18/2013)

---

i go throughed the links Sean Lange

they are fine but i am not able to implement this kind of dynamic solution for my store procedure

so plz tell...

chintan.floydian (4/18/2013)

---

Thanks very much guys...Unfortunately I'm still on 2008

I've tried the below and it works, but I'm not sure how to achieve this through the quirky update as advised in...

SCGJohn (4/18/2013)

---

Thanks for posting this, I'm pretty sure you've resolved a long standing issue I've had.. For those of us who use Stored Procedures exclusively, this is a great...

ScottPletcher (4/17/2013)

---

The code's not really ready to be used in dev or QA either.

NO reason to search the same table multiple times, esp. not once per column.

Instead, should do a...

Again, if you can post something we can work with we can help you. I would suggest looking at MERGE. It will likely be a good choice here. Certainly a...

Sqlism (4/17/2013)

---

1)find number of users on a database in sql server 2012

2)find number of users accessing in sql server 2012

3)find users using a specific object on a database inn sql...

jerry 5150 (4/17/2013)

---

Thank you all for your suggestions, and I apologize for not reading the instructions on how to post before posting. I think your replies have clarified for me...

:blush:

Ahh yes indeed. DOH!!! Easy enough...