You could use "SET IDENTITY_INSERT <table_name> ON" to insert identity values into a table. Just remember to switch it off afterwards.

😎

That is vb.net code, if you are using C# then you need to change it, unfortunately I cannot do it at the moment.

😎

Another quick though:-D (and you could squash two bugs with the same code), check the file size. Found this lying around:cool:

Private Function intGetFileSize(ByVal strFileName As String)...

Here is a very simple approach

😎

USE tempdb;

GO

DECLARE @TXML XML = N'<?xml version="1.0"?>

<CommonEventData>

<Row>

<CallSource>999</CallSource>

<CallerCityStateZipCode>

</CallerCityStateZipCode>

<CallerName>TEST</CallerName>

<CallerPhone>TEST</CallerPhone>

</Row>

<Row>

<Beat>E27</Beat>

<MultiEventId>0</MultiEventId>

<PrimaryUnitId>E09A1</PrimaryUnitId>

</Row>

</CommonEventData>'

SELECT

MAX(RO.W.value('CallSource[1]','NVARCHAR(50)') ...

Quick thought, escaped back-slashes?

😎

public void Main()

{

string filelocation = @"D:\\myfolder\\emps.txt";

...

david.dartnell (5/28/2014)

---

Hi Everyone,

I am getting the error 'Incorrect syntax near the keyword set' with the following code snippet -

declare @dteTo Date

set @dteTo = CONVERT(date, GETDATE())

My intention is to set the...

Quick question, how do those two tables relate?

😎

A semi-dynamic query is straight forward

😎

USE tempdb;

GO

--CREATE TEST DATA

IF OBJECT_ID('tempdb..#PivotTestTable') IS NOT NULL DROP TABLE #PivotTestTable

CREATE TABLE #PivotTestTable

(

[SURVEY_REF] [nvarchar](100) NOT NULL

,[QUESTION] [nvarchar](MAX) NULL

,[ANSWER] [nvarchar](100) NULL

,[DATE_REC] [nvarchar](10) NULL

,[TIME_REC] [nvarchar](10) NULL

)

INSERT...

It is a connection manager error, by the looks of it, it cannot locate...

autoexcrement (5/27/2014)

---

I am using a database with a CI collation, but where some of the columns in some tables are set to a CS collation.

Is there any way to...

mickyT (5/27/2014)

---

Hi

I've had a look at a few options and for the data the I'm testing on, this appears to be the best solution (for SQL 2012 +). It...

Johnny H (5/27/2014)

---

Here is what I have tried. Setting GEOMETRY to GEOGRAPHY, then a inner join, I have also tried with a union with the same error results.

DECLARE @sign...

Roust_m (5/27/2014)

---

The problem is, if you hardcode the clock move dates, you may get it wrong, as Australian government sometimes changes those dates.

The server timezone is (UTC-06:00) Central Time (US...

Something like this?

😎

USE tempdb;

GO

DECLARE @test-2 TABLE

(

Test INT NOT NULL

,FristPull ...

Roust_m (5/27/2014)

---

Can you please elaborate on this?...