Topics
Started by
Posts
Last post
Is the following possible by SQL alone, i.e. no cursors, want to see if you can do it by SQL a…
3 replies
Can someone explain why I need to do a DISTINCT in the second query? The first query uses Temporary…
2 replies
Hi, I am trying to create a script that deletes transaction tables and leaves master data like cust…
2 replies
Hi i need a help in parsing out data from a particular field and placing it into another field. wha…
7 replies
I have a table 2 fields only: group member It is possible that a gorup can be a member as well. Eg:…
11 replies
I have a table with the following structure: MemberNbr char(9) StartDate datetime EndDate datetime …
1 replies
I need to create a dataset (working with ASP.NET) based on a selected retrieving the 6 most recent …
3 replies
I am new to pivot tables and SQL. I am using the following T-SQL code to gener…
8 replies
Hello, I had to write a simple view in SQL Server and create a pivot report from Excel based on thi…
2 replies
Hi! I'm not sure whether this is the right place to post this, but I'm getting a frustrating error …
3 replies
Can anyone try the following syntax to query an excel sheet? Which one works for you? The post http…
5 replies
I know there is an easy way to display all the tables in a database, but I can't seem to find it. C…
11 replies
Hi, I need to join two tables using datetime fields, but i only want to join using t…
6 replies
I have a table called logon table which has some columns like userid, Firstname, lastname, email an…
2 replies
The IN oparator looks at value1 OR value2 OR value3 etc. What I want is the same, but with value1 A…
16 replies
Viewing 15 topics - 8,071 through 8,085 (of 17,082 total)
You must be logged in to create new topics.