prakashr.r7 (3/5/2013)

---

You can solve your immeditate problem by using the solution I proposed above - generate a table of all 36 values (or whatever) randomised relative to an incrementing numeric...

winmansoft (3/5/2013)

---

ChrisM@Work (3/5/2013)

---

INNER JOIN the two tables using LIKE. If that doesn't work, you will need to split out the words in 'checkout and play'. It will work but it...

prakashr.r7 (3/5/2013)

---

Jeff Moden (3/4/2013)

---

I hardly ever use the word "stupid" in describing something but the people asking you to do this are freakin' stupid to their core! How many...

winmansoft (3/5/2013)

---

I will explain with example. I have a query "select work from entries1 WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'" and lets say it will return result

training

checkout

surfing

develop

...

I have another...

chingarova (3/5/2013)

---

OK, let me explain...

The script I posted is just an example(my real example is different and much more complex,but this doesn't matter), what I need to understand is why...

chingarova (3/5/2013)

---

The business key is the FirstName. I am merging the initial table with update tables and I am doing this based on the FirstName(which will not chanege in my...

chingarova (3/4/2013)

---

Hi,

I am having a BIG problem with the merge statement in SQL 2008:

When I have an entry (for example an employee name) in the table which is already...

Krishna1 (3/4/2013)

---

Dear All

For one table I need to create insert statemetn with data. For this I used SSMS-Task -Generate script - Data only it creates inserts will all...

Investigate the properties of the Compute Scalar operator - right-click on the icon, choose "Properties". Expand the collapsed nodes.

Your requirement isn't totally clear Alan so I'll take a shot at interpretation and suggest ROW_NUMBER(), like this:

SELECT

rn = ROW_NUMBER() OVER (

PARTITION BY Software_Name_Raw, Software_Version_Raw, Software_Publisher_Raw

ORDER BY Load_Date),

Software_Name_Raw,

Software_Version_Raw,

Software_Publisher_Raw,

Software_Category,

Software_Subcategory,

MSDN_Flag,

CDL_Flag,

Source,

Pending_Classification_Flag,

Auto_Classification_Flag,

Software_Classification_Version,

Manual_Deletion,

Load_Date

FROM...

jamesnorton (3/4/2013)

---

Hi not sure if this is the correct forum but I need some help with dates in SQL.

I have been given a database that has the dates stored in...

With the added cost of Event_Channel in the matrix table correlating with the inner query, it may be worthwhile splitting the query up, like this:

SELECT *

INTO #Matrix

FROM Tijdsintervallen

CROSS...

geert.de.vylder (3/4/2013)

---

Hi ChrisM@Work,

Yes, event_channel has to be populated, even if there isn't a match in the Tussen_Ticket table. This is because I have to update the results into another table...

Run this: SELECT @@VERSION

prakashr.r7 (3/4/2013)

---

Eugene,

I can generate unique values....what i am asking is " How do you generate unique values for 40 rows ? " We can generate upto 36 right? How...