Topics
Started by
Posts
Last post
Does anyone know what is more efficient for selecting distinct rows...select distinct or using a gr…
2 replies
Hi, Does any body know how to list user rights to databases in TSQL, or how to get a list of databa…
4 replies
Is there any way to create a T-sql query/SQL JOB that checks the status of MSSQLSERVR.exe(in C…
2 replies
I Need to write a query to capture if a call was sent to the field and then cancelled, what defines…
3 replies
I have a table that records page hits, the relevant bits are as follows create table pagehits( id…
10 replies
my dilemna is that all of the data that I have to work with is currently stored in sql server in cr…
4 replies
In the last days we need to create some Kind of Extended Property equal to MS_Description, that whe…
1 replies
Hi folks, I need to create a cursor by: Select WorkRequestID From WorkRequest there should be a wh…
2 replies
Hello everyone, I need to create a recordset of records, which are 3 days old from a…
5 replies
Hey folks, I think I already know the answer to this one, but I'm hoping you may have another way o…
6 replies
Hi all, my brain seems to have stopped functioning. Does anyone have a really clever way of getting…
4 replies
We have a Bloomberg trade feed that comes in and updates a SQL table, with a unique constraint…
6 replies
I've got 2 queries ... SELECT * FROM RemoteServer.dbname.dbo.viewname where fieldname = @var …
10 replies
Hi , I have a situation to insert records from one table to 2 other tables. Situation is as below: …
3 replies
I want to check for records that were created today and are one hour old but not two hours ol…
6 replies
Viewing 15 topics - 7,066 through 7,080 (of 17,082 total)
You must be logged in to create new topics.