Topics
Started by
Posts
Last post
Hi, I have this scripts which works well on local server, now, my problem is, i want to run it on a…
1 replies
I'm getting my feet wet with T-SQL and would like a little feedback. I did NOT write this, but, won…
3 replies
Hi, I need help with a query I have a table with a surname field I need to check if any of the cha…
1 replies
I have three tables as below. How can I query them to provide the result below? PersonName 1John…
4 replies
Hi, I have a CUSTOM_PROFILE table with the following columns ID integer PARENT_ID …
2 replies
With SQL Server 2000, with is a quick and simple way to backup a sql table using SQL Code. Say, I h…
2 replies
How can I INSERT INTO VALUES for a table with a primary key? I have a table called TEST with the fo…
1 replies
Hi! guys I'm trying to workout turnover percentage but I just cant seem to get the query right. Ple…
2 replies
I cannot see why I am getting this error msg in QueryAnalyzer results window: Server: Msg 7354, Lev…
1 replies
I get 8 records out of my database when I use this query: SELECT email FROM tblExperts WHERE Expert…
21 replies
OK, so after spending too much time on reviewing everything and trying to teach myself SQL, I'm won…
4 replies
We have a very simple stored procedure to return the TOP 100 rows from the largest table in a datab…
2 replies
SET NOCOUNT ON DECLARE @tablename VARCHAR (128) DECLARE @execstr VARCHAR (255) DECLARE @objectid …
1 replies
i need to convert DateTime to BigInt through query in SQL plz let me know
32 replies
Is there any valid way to write a CASE statement like this? Select distinct d.Field1, Field2, coun…
4 replies
Viewing 15 topics - 1,996 through 2,010 (of 17,082 total)
You must be logged in to create new topics.