jbalbo (1/11/2012)

---

Hi,

Getting a syntax error on the following..

INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA)

SELECT TAG_NAME = 'CUST_AGE',...

worker bee (1/11/2012)

---

This converted the date but now I need to count...

SELECT

CONVERT(VARCHAR(10), UTCOccurrenceDateTime, 111)

FROM Alerts

WHERE (Heading LIKE 'Disk...

Not a VB dev, but in C# we set the SqlCommand.Timeout. Most likely it is the connection or command in your VB code that is actually Timing out, not the...

worker bee (1/11/2012)

---

I get an error on the CAST;

select ServerName, Heading, UTCOccurrenceDateTime

REPLACE(CAST(UTCOccurrenceDateTime as date),'-','/')

from dbo.Alerts where Heading like '%blocking%'

AND DATEADD(hh, -6, UTCOccurrenceDateTime) >= DATEADD(day, DATEDIFF(day, 0, GETUTCDATE()), 0)

order...

Try this bick, and please reply with the results... I am not on a machine with management studio, so can't test.

SELECT datakey,COUNT(datakey) OVER(Partition by datakey) AS Uniquedatakey,

...

Have not tested this, but :

SELECT COUNT(DISTINCT datakey) OVER(Partition by datakey) AS Uniquedatakey,

COUNT(DISTINCT CASE WHEN landline<>'' THEN landline END) OVER(Partition by datakey) AS...

Ooo. Sorry, I think I missinterpreted your requirements.

Try this instead:

SELECT qid, postcode_area, vehicle_group, premium, lic_years, ncb, proposer_age, email, created

FROM Mainstreet.dbo.leads l

---------------

--try this join

inner join (

SELECT distinct id

FROM Mainstreet.dbo.leads

) le

on l.email...

mike.barrett (1/11/2012)

---

I have yet to come up with a simple but fast way of retrieving rows from a table that have unique values in one or sometimes more than one...

worker bee (1/11/2012)

---

Okay, I have to add a convert for the UTC column and I have no idea where to put it, can some one help me out real quick?

add...

Gianluca Sartori (1/11/2012)

---

Maybe, indented properly it's less confusing: 😉

WITH MeaningfulCTEName AS (

SELECT c.owneridname as BSC,

z.Tpl_TotalGWP as Total2012,

...

the following query

select member_number, date, time_in, time_out from member_time where time_out <='9:30 am' gives the following data

member_number date time_in time_out

2550 1/9/2012 7:55:31 AM 1:08:15 PM

2563 1/9/2012 7:55:59 AM 4:30:00...

Not sure I fully understand the requirements, but why don't you just declare your parameters and then do your If/Else statements, and drop the cursor all together?

Stephen

In an attempt to help, you could obviously do some sort of +1 if/else statement, or a case when statement to a variable. The below code is very basic and...

"Big Data" I dream about. Being a young, junior DBA/developer/BI analyst, on a small project, I hope to one day dive right into the world of big data. I can't...

Thank you all for the good luck. I am hoping to become a more active member of SQL Server Central, and attending a SQL conference in the near future!

-Stephen