It depends.

I have seen this done both...

erouse (9/21/2016)

---

Jeff Moden (9/16/2016)

---

erouse (9/16/2016)

---

Can somebody please help? Is there a fairly simple way to do this?

This is my data now.

LABORLC

152685A B C D E

152969A B

This is what...

What Nicholas proposed will work provided that CN= always comes before OU=. Working with AD, I've see that this is not always the case. If this is how it is...

dbodell (9/20/2016)

---

You know that is an interesting comment because I recently changed the code to use MERGE instead of separate INSERT and UPDATE processes. Removing and rebuilding the indexes was...

dimpythewimpy (9/20/2016)

---

Here's the code I have. Can someone please suggest an improvement. Is it syntactically correct?

CREATE FUNCTION [HSIP].[Isnumeric]

(

@sResponse_string varchar(250)

)

RETURNS BOOLEAN

AS

BEGIN

RETURN

DECLARE @Output AS INT

select @Output= CASE @sResponse_string

WHEN @sResponse_string= ISNUMERIC(REPLACE(REPLACE(@sResponse_string, ',',''),'$',''))...

I have used SSRS for like this (as both a data input and for data retrieval) and think SSRS is terrible for this. The main problem is that you have...

drew.allen (9/19/2016)

---

TIME data DOES NOT...

JALLYKAMOZE (9/19/2016)

---

Thanks Allan, this throws an error, i passed the column in the table and set that column as the default value for the variable @time ,

i did this:

DECLARE @Starttime...

Assuming the 6 in your example represents an hour you could do this:

DECLARE @time varchar(10) = 24;

SELECT MAX(CONCAT(REPLICATE(0,2-LEN(@time)),@time,'00'))

WHERE @time BETWEEN 0 AND 24;

This returns the time in military format;...

My solution:

-- sample data

DECLARE @sampleData TABLE (stringID int, string varchar(1000));

INSERT @sampleData

VALUES

(1, 'Day20ReminderCampaign2016_09_15_13:46:57'),

(2, 'Day3ReminderCampaign2016_09_19_02:28:39');

--Solution

SELECT

stringID,

part1 = SUBSTRING(string,1,split-1),

part2 = STUFF(REPLACE(SUBSTRING(string,split,8000),'_',''),9,0,' ')

FROM

(

...

You can't assign the results of a query that returns multiple rows or columns to the value of a variable. This is not allowed:

DECLARE @sRESPONSE_STRING VARCHAR

set @sRESPONSE_STRING = (SELECT...

That is a potential design problem - I would consider...

Vendor Databases are generally not designed by database gurus which is a good thing, it helps keep us database people employed.

For a situation like this, clustered indexes, non-clustered indexes...

Ben Teraberry (9/15/2016)

---

Joe asked: "Can you give me example of something that has to be done with the CLR instead appear SQL?"

A while back I did a C# CLR function...

Gazareth (9/15/2016)

---

Also SUM with OVER()

DECLARE @table TABLE (stateName varchar(20), Count1 int, TotalChargeOffAmount int);

INSERT @table

VALUES

('Alabama',5,1000),

('Arizona',2,4000),

('Arkansas',3,5000);

SELECT

stateName,

Count1,

TotalChargeOffAmount,

100.0*Count1 / SUM(t1.[Count1]) OVER...