Viewing 15 posts - 421 through 435 (of 5,590 total)
Good going Lynn.
You Lynn are a genius!
July 8, 2015 at 2:31 pm
Alvin Ramard (7/8/2015)
I've had it. Enough is enough! When are people gonna stop hiring people that don't have a clue about they're hired...
July 8, 2015 at 1:28 pm
shezi (7/8/2015)
I have Temptable showing as
Columns:EmpName, Code, Balance
Rows1: EmpA, X, 12
Rows2:...
July 8, 2015 at 1:25 pm
Jeffery Williams (7/8/2015)
Here is what I am playing with:
...
July 8, 2015 at 11:55 am
jcobb 20350 (7/8/2015)
Luis Cazares (7/8/2015)
I also changed the pivot approach to a...
July 8, 2015 at 11:37 am
You've left a lot of work for us to do to help you out. Please read the link in my signature, and then help us help you by providing:
1. CREATE...
July 8, 2015 at 10:54 am
kraaitje (7/8/2015)
Situation:The table looks like this:
SELECT OrganisationCode, PostcalCodeStart, PostalCodeEnd
FROM dbo.DimOrganisation
Gee, that looks more like a query to me, and not a table.
A table would look more like:
CREATE TABLE #DimOrganisation (
...
July 8, 2015 at 10:11 am
Nope, that is indeed how to remove them.
You might want to consider renaming them, and letting them sit there for a period of time (say, 3-6 months), to ensure that...
July 8, 2015 at 10:00 am
Lynn Pettis (7/8/2015)
Minnu (7/8/2015)
Numeric values in the first query should be converted to INTEGER.
You can't mix character data and integer data in the same column.
What are you trying to accomplish?...
July 8, 2015 at 9:53 am
I've lost track... who has the crystal ball?
http://www.sqlservercentral.com/Forums/Topic1701092-391-1.aspx
July 8, 2015 at 9:46 am
Sean Lange (7/8/2015)
Junglee_George (7/8/2015)
Instead of removing cursor, please help to me to modify the existing code within.
I think you are missing the point. The reason the performance of this is...
July 8, 2015 at 9:43 am
Comments in the code.
-- need to create a data "island" of the times in each department.
-- to do this, you need a sequential number for each employee,
-- a sequential...
July 8, 2015 at 9:31 am
Minnu (7/8/2015)
Hi,first query result :
1
2
11
20
32
68
100
124
246
256
second query result
A1
A10
A11
AB1
AB10
B1
B2
B21
B31
want to generate the complete output in single select statement.
How about a simple modification to Lynn's code?
select Data from #TestData where Data not like...
July 8, 2015 at 9:15 am
SQL Server 2008 did add several new data types (see this link) (date, time, datetime2, hierarchyid, geometry, geography) . However, nothing in the existing data types was changed that would...
July 8, 2015 at 9:05 am
GilaMonster (7/2/2015)
Do you get the feeling that IT people, especially ones at the top-end of the field, are...
July 2, 2015 at 4:19 pm
Viewing 15 posts - 421 through 435 (of 5,590 total)