Topics
Started by
Posts
Last post
Hi! I have a similar query, that runs fo 30-60 seconds with [max degree of parallelism] equal 1 and…
4 replies
SELECT COUNT(table1.ID1) AS counter, table2.ID2, table2.ID3 FROM table2 INNER JOIN table1 ON table2…
3 replies
Hey all i have a job that can be done using the following ways: 1) using Cursors 2) using a Single …
1 replies
Hi all, I'm using the INFORMATION_SCHEMA views to query remote databases. I use INFORMATION_S…
1 replies
Anyone know how to dynamically create a table variable that can be used in the scope of a stored pr…
11 replies
Is it possible to take in a parameter and use it as the column name or column number in the ORDER B…
4 replies
I really want a simple way of assigning a variable's value to a value returned by dynamic SQL. …
3 replies
Hello all. I am having a difficult time trying to find a way to use an SQL string in ASP.NET to pas…
6 replies
tranxdate: 2004-11-20 00:55:41.000 How to get the previous date(2004-11-19)? tranxdate - 1?
3 replies
Hi expert, I want to select from different databases (HFC and HFC_EPAY) but it gives me an err…
5 replies
I am busy converting all our Crystal reports over to Report Designer and have hit a snag. I have a …
3 replies
Hi, My question is, in SQL Server when I create a temporary table, in tempdb database the table nam…
6 replies
I currently have tables that are comprised of stock tick prices minute by minute. I now need to que…
3 replies
Can anyone help me out .. not really sure where to start looking on this one. this statement below …
4 replies
I'm stumped. We have the following table :- CREATE TABLE [dbo].[NotifierGroup] ( [NotifierID] [smal…
1 replies
Viewing 15 topics - 11,716 through 11,730 (of 17,082 total)
You must be logged in to create new topics.