You can use SSMS to script data for you too.

Right click the database -> Tasks -> Generate Scripts.

Choose whatever object(s) you want. Then go to Set Scripting Options. Click the...

Your sample data does not match the explanation of desired output. This sounds like you want a type of running total but I can't quite figure out what you are...

That...

Kurt W. Zimmerman (11/12/2013)

---

I'm not a big fan of the way you've constructed your INSERT/SELECT statements on your CATCH logic. I prefer to specify the columns in both the...

This is a mighty big topic. I would start by looking here. http://www.sqlservercentral.com/stairway/72399/%5B/url%5D

You are going to have to provide more details here. I took your sample data and turned into something consumable but there are no errors.

create table ciscorawdata

(

TransID int identity,

dateTimeOrigination int

)

insert...

krypto69 (11/8/2013)

---

Hi,

My understanding is that it is possible to use create an indexed view in SQL2000 standard edition? (was going to buy Enterprise)

The main slow performing query that I have...

Not exactly sure what you are trying to do here.

Not...

roy.tollison (11/8/2013)

---

and I can't seem to find the correct syntax.

UPDATE UPDTABLE

SET updtbl_lat = i.infotbl_lat,

updtbl_long = i.infotbl_long

FROM INFOTABLE i inner join DTLTABLE d on d.dtltbl_group...

I don't think your set commands will work properly...

jermaine.grant (11/8/2013)

---

Hi,

Im trying to set idenity insert on on a table, however i cannot do this using the db server and database name as parameters.

declare @DestDB varchar(100)

declare @DestServer nvarchar(30)

declare...

frank 36119 (11/8/2013)

---

I am looking to incorporate replace statements in a case statement. I have a view which produces the data that need and I have a query that...

d_uvarajan (11/8/2013)

---

Sorry, I don't know why it's not attaching!

I clicked on "Insert Image" icon and typed the local file path and it inserted the html text here. But image...

SQL006 (11/7/2013)

---

Sean Lange (11/7/2013)

---

Excellent job posting ddl and sample data. I wish everyone posted everything like that to make it easy!!!

Something like this should work.

declare @EmployeeID int = 285;

with EmployeeTree...

erikd (11/7/2013)

---

Louis Hillebrand (11/7/2013)

---

You can use this query with the testvalues.

The WHERE filter on 3 * the same character to start (REPLICATE(LEFT(t.name,1),3) + '%')

and secondly on starting with a character...