Hi David, I am trying now to use the ssis import wizard, but each row is not ending correctly its staggering the data. How do I tell that after x...

Hi there I have changed the file now and its fails on all datetime/date..

This is my new formatfile

<?xml version="1.0"?>

<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<RECORD>

<FIELD ID="1" xsi:type="CharFixed" LENGTH="10"/>

<FIELD ID="2"...

@mc1 varchar(100)

worked

🙂

Hi Chris, I have to set what my parameter is before I call it like so

ALTER PROCEDURE [dbo].[GetCategory]

@mc1 nchar

AS

; WITH OrderedData AS (

SELECT

rn = ROW_NUMBER() OVER (ORDER BY Dockets...

No problems Chris. Thanks for your help on this matter.

J

Chris M do I need to give more information ?

I can see the finish line almost 🙂

Yes, that is how you create a primary key.

Check what error it's failing with if it doesn't set the PK (my guess, the column is nullable)

Spot on mate...

Sorry

OK normally I drag my tables onto my Dataset designer and run queries against it like so

SELECT Con1, Con10, Con2, Con3, Con4, Con5, Con6, Con7,Weekend, Contract, Docket_Category, Docket_Date, Docket_DateRaised,...

Anybody help me find my error?

In VS when I have a query like this it ask me for the dates, but running this is VS complains about parsing variables.

This is what I have tried...

There is lots of selects in this so I am not 100% where to put the date part. I also want to use Variables form from C# app.

(Docket_Date BETWEEN...

I found out the Row grouping was incorrect in my report so its working now. I will eventually select Docket_Date also but will try a figure out where to put...

When I execute this in SQL the results are perfect and in the correct order, I use a stored procedure and then drag to my DataSet designer in VS2010 create...

Wow just like that, that so far advance to what I was trying 🙁

I will try make some sense of it and understand just what is happening.

Thank you Kindly.

I am...

Is it possible to select Pct_To_Total and sum on this column and generate another column?