Topics
Started by
Posts
Last post
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
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
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
I have a parameterised query here I pass one parameter In query parameter name @path. Now I want to…
5 replies
I have the following code that retrieves tha last characters '200BB' The value is variable so it co…
12 replies
Hi all, I'm trying to rewrite the following function that we use to trim certain catalog numbers in…
36 replies
I am trying to write SQL to write the SQL to alter all columns in a DB from char to varchar. DECLA…
9 replies
Viewing 15 topics - 7,636 through 7,650 (of 12,230 total)
You must be logged in to create new topics.