Hi

Try to convert the odb.set_group to VARCHAR within your sub-select:

SELECT

CASE WHEN (select count(distinct c_number)

...

Hi

I would say it depends...

Especially huge brands usually have different suppliers to stay independent and one supplier usually also has different customers (the brands). We have both combination in different...

Hi

If the FOR XML AUTO fits your requirements you can simply add the name for the root element to be created:

FOR XML AUTO, ROOT('root')

Greets

Flo

Hi

Another way would be a CROSS APPLY to select the totals since the current year:

DECLARE @t TABLE (P_Year DATETIME, P_Purchases MONEY)

INSERT INTO @t

...

Jack Corbett (4/16/2009)

---

Florian Reischl (4/15/2009)

---

Hi

I also don't really understand the requirement. Do you mean that you want to append the filtered result with the unfiltered one? (What I still wouldn't...

Vladan (4/16/2009)

---

Florian Reischl (4/15/2009)

Do you know how it would be possible to add a CRLF to the end of the rows? If I use either CHAR(13)+CHAR(10) or a direct CRLF...

Hi Bob!

Bob Hovious (4/15/2009)

---

Keeping it simple....

UPDATE sometable

...

sgovoni (4/15/2009)

---

Hi Susannah,

I have completed the stored procedures in CLR languages 🙂 take a look at this post: http://community.ugiss.org/blogs/sgovoni/archive/2009/04/11/sqlclr-instead-of-ole-automation-sp_5F00_oa_2A00_-method.aspx the article that you reach by clicking on read more explains...

Hi Frank

This becomes the "most wanted" these days... 🙂

You can handle this by OR within your WHERE clause:

WHERE (@incident_id NOT NULL AND incident_id = @incident_id

OR (@res_id IS...

Hi Carol

Thanks for that. Especially because I thought since now the statement is...

Hi

I still would use an INT column as primary key. You can use GUIDs as UNIQUE CONSTRAINT column for data uniqueness over different databases/servers/locations. Anyway we use a simple string...

@Lutz

I would do exactly the same way as you did... 😉

But I have a short question:

Do you know how it would be possible to add a CRLF to the end...

Hi

Not the exact answer for your question but did you try to do this with BCP? It's much faster and you can export/import in native mode without all those problems.

Greets

Flo

Here a little snippet of a script I will publish in next weeks:

Since now this only scripts the tables. The indexes and constraints are not included.

SET NOCOUNT ON

DECLARE @check_exists BIT

DECLARE...

Hi

What about UPPER? 😉

DECLARE @t TABLE

(

txt VARCHAR(30)

)

INSERT INTO @T

SELECT 'CQS0002509'

UNION ALL...