Topics
Started by
Posts
Last post
I am using SQL Server 2005 Express. A table named appts is defined such: CREATE TABLE [dbo].[apptts…
7 replies
Hey guys, this is probably a novice question for most of you out there. I've been tasked with crea…
1 replies
Hey guys, this is probably a novice question for you. I'm a GIS guy that has been tasked with crea…
2 replies
Hi there, I am trying to get scale & precision of all the fields with decimal/numeric datatype…
2 replies
I always got good answer while posting here but this time, I have a situation which I think will as…
5 replies
Hello, I have an issue with this query. What I want is to sum qty1 in table2 and qty2 in table3 and…
11 replies
Hello ALL, In my table have multiple columns such as DDS,DEClearedDate, SomaticMCClearedDate, PsycM…
2 replies
Hi Doest anyone know if it's possible to save a XML formatted query (using for example FOR XML stat…
1 replies
I have a table with following schema Table Name [OfficeDirectory] Columns EmpID RoomNumber …
2 replies
By: Atif
In 2005, the exciting feature is Common table expression. Is use of CTE is cost effective?
6 replies
This may not even be possible but I have been staring at this data all day trying to figure out how…
3 replies
Hi, can anyone suggest how I can improve this query? Are there any glaring bad bits of code in this…
15 replies
By: schwizla
Hi, I am importing tables from access to sql server 2005 using SSIS package(right click on database…
1 replies
When I try to modify a not existing column in a not guilty condition I get an error. Why is the SQL…
24 replies
Hi, I hope you guys are doing great. I was writing this query and got stuck - How do I use "CaseNo…
6 replies
Viewing 15 topics - 7,636 through 7,650 (of 12,234 total)
You must be logged in to create new topics.