dandenise316 (7/29/2015)

---

It's pretty simple, instead of

SELECT

DATE_TRUNC('month', n.campaign_date) <--- i want the date trunc to reflect ONLY the 1st - 23rd of every month. I then want to...

Robert klimes (7/29/2015)

---

I am trying to calculate cumulative GPA which is currently it is being done via a cursor and i was looking to change it to set based if...

dandenise316 (7/29/2015)

---

My goal is to select values from the same date range for a month on month view to compare values month over month. I've tried using the date...

RRIOS42 (7/29/2015)

---

Anyone have any tricks to separate this column from:

"testlname,testfname comment section > comment section testlname,testfname 6/30/2015 9:05:58 AM > testlname,testfname 6/30/2015 9:06:18 AM > comment section testlname,testfname 6/30/2015 9:10:05...

tomullus 69522 (7/29/2015)

---

I think i was misunderstood. I made a mistake in the original post by copying the wrong query into it. The current post (after my edit) is the...

Here is another alternative.

with Something(someVal) as

(

select '{_cpn}=1743; {_cpnll}=4511'

)

select xx.Item

from Something s

cross apply dbo.DelimitedSplit8K(s.someVal, ';') x

cross apply dbo.DelimitedSplit8K(x.Item, '=') xx

where xx.ItemNumber = 2

You can find the DelimitedSplit8K by following the article...

Here is some that will generate different text on every page load. http://www.lipsum.com/feed/html

PI28 (7/27/2015)

---

Hi all,

I want to migrate my table in Sybase to MsSQL. I am using SSIS for this, just truncating the destination mssql table and loading it from sybase. This...

Not much detail here to work...

tomullus 69522 (7/29/2015)

---

Hi,

I came upon an odd issue today:

I have a query that runs fine and at an acceptable speed (a few seconds). It looks like this:

select count(row_id) From table1...

jude.pieries (7/28/2015)

---

Any of you have run to a select permission error when attempting insert data to a table. received the following error

Msg 229, Level 14, State 5, Line...

I would suggest starting...

Seems to me there are three, four including mine, example in this...

spam reported

SqlMel (7/29/2015)

---

Good question and something to keep in mind always.

I ALWAYS use Top 1 when assigning values to variables even though in all cases I can think of I use...