That's not what you said in your original...

lewisdow123 (5/24/2012)

---

Hi,

I'm hoping someone will be kind enough to give me a hand on a little problem I have.

Basically we a relationship table, that uses a parent-child association, this table...

I wish I had the authority to enforce that sort of rule

dwain.c (5/22/2012)

---

Cadavre...

ColdCoffee (5/22/2012)

---

using System;

using System.Data;

using System.Text;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

public partial class UserDefinedFunctions

{

[Microsoft.SqlServer.Server.SqlFunction]

public static SqlInt32 SortDigits(SqlInt32 Number)

{

...

SQLKnowItAll (5/22/2012)

---

Cadavre (5/22/2012)

---

Bit of a guess: -

SELECT Num,

((SELECT bits

FROM (SELECT SUBSTRING(CAST(Num AS VARCHAR(19)),n,1),

Num

...

The only reason that springs to mind is interview/homework question to see if...

Bit of a guess: -

SELECT Num,

((SELECT bits

FROM (SELECT SUBSTRING(CAST(Num AS VARCHAR(19)),n,1),

Num

FROM #Number...

I agree with the previous statements made, you are going to have many difficulties.

However, your current design can be used if it absolutely has to.

SELECT MRN, additional_procedure, additional_procedure_Location,

STUFF((SELECT ','+

...

Or do it in one go -

DECLARE @sql NVARCHAR(4000);

SELECT @sql =

'exec master.dbo.xp_cmdshell ''rmdir "c:\tempo_SGCTLOCAL\"'', no_output;'+CHAR(13)+CHAR(10)+

'exec master.dbo.xp_cmdshell ''mkdir "c:\tempo_SGCTLOCAL\"'', no_output;'+CHAR(13)+CHAR(10)+

'exec master.dbo.xp_cmdshell ''MOVE '+@caminho+'*.* c:\tempo_SGCTLOCAL'', no_output;'+CHAR(13)+CHAR(10)+

'exec master.dbo.xp_cmdshell ''rd /s/q '+@caminho+''', no_output;'+CHAR(13)+CHAR(10)+

'exec master.dbo.xp_cmdshell...

dwain.c (5/22/2012)

---

Doesn't work obviously! Note the statement at the end of my post, which I put there suspecting that the data in the catenated string may not be very...

dwain.c (5/21/2012)

---

If you're trying to join the two tables based on common names, you can also use PATINDEX.

Create table #basetable(Id int identity, Component varchar(256))

Create table #dailytable(ID Int, FILENAME Char(50), PROCESS...

Much easier to answer you now.

SELECT '#TmpAct' AS TableName, 'ACCOUNT_ID' AS ColumnName,

COUNT(DISTINCT b.ACCOUNT_ID) AS NumDistinctValues,

MIN(c.ACCOUNT_ID) AS MinValue,

MAX(c.ACCOUNT_ID) AS MaxValue

FROM #TmpAct a

CROSS APPLY (SELECT CAST(a.ACCOUNT_ID AS VARCHAR(MAX))) b(ACCOUNT_ID)

CROSS...

Without DDL and sample data that reflects what...

Total guess having not seen sample data or DDL.

SELECT TableName, ColumnName, COUNT(ColumnName) AS DistinctValues,

MIN(MinValue), MAX(MaxValue)

FROM (SELECT

'ACCOUNT' AS TableName,

...

Are you attempting to join your two tables based on the comma deliminated list in "component" and the "process" ?

If so, something like this might help: -

SELECT *

FROM #dailytable daily

INNER...