TheSQLGuru (5/28/2014)

---

Eirikur Eiriksson (5/28/2014)

---

Luis Cazares (5/28/2014)

---

Maybe you could use SQL Server Profiler with the correct filters and use the option "Discard results after execution" (Options->Query Results->SQL Server->Results to Grid).

Maybe someone...

Luis Cazares (5/28/2014)

---

Maybe you could use SQL Server Profiler with the correct filters and use the option "Discard results after execution" (Options->Query Results->SQL Server->Results to Grid).

Maybe someone else can give...

Good question, thanks!

😎

Quick thought, if the "signs" are points then I would have thought that the STContains function would be more appropriate.

😎

The CHAR()/NCHAR() functions can be used as a parameter for the REPLACE function

😎

SELECT REPLACE('STUFF TO |REPLACE',CHAR(124),'')

Use either the ASCII() or UNICODE() to find the character code

SELECT UNICODE(N'|')

SELECT ASCII('|')

This code lists...

Quick thought, as the table is in tempdb, change the statement to

DROP TABLE tempdb..#NewEmployees

😎

viresh29 (5/28/2014)

---

Hello Folks,

I am using Flat File Connection to process files into Database.

Files coming with text qualifier and delimited by comma.

But in some of the columns I am...

Are you looking for something like this?

😎

;WITH TEST AS

(

SELECT 'KM' AS Channel, '2012-06' AS TrailMonth UNION ALL

SELECT 'KM' AS Channel, '2012-06' AS...

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?

😎