Topics
Started by
Posts
Last post
Just wondering, I have this query: select ProductID, SUM(OrderQty) nOrderQty, SUM(ScrappedQty) n…
4 replies
Hello, I'm can't seem to figure out how to get my XML to format the way I need it. I created a sa…
2 replies
I have a table (example testing code below) that has a number of records grouped for a particular i…
11 replies
I would like to create a job for SELECT datediff(n, dc_date ,last_start_date) FROM PARM if the outp…
2 replies
Hi all I'm creating a trigger that should send a mail if a stockcode is created in the inventory ta…
2 replies
I cannot get this to work. I believe it is because of the date columns (they do not match exactly).…
3 replies
Hi All, I searched on google and came to know about the list of SQL standards. SQL-86 SQL-89 SQL-9…
1 replies
Is there a way to capture improperly formatted source records when all of a source file's records c…
1 replies
I've gotta set up a view that either drops; re-creates and inserts records into a physical or temp …
2 replies
Trying to return current month as a char(2) Ex - July would return '07' I need two characters exact…
3 replies
Hi Folks, I have some issues with stored procedure on SQL Server 2005. My Conditions: 1-by date r…
2 replies
I have this query that is giving me issues, if you have any suggestions they are apperciated! Task:…
6 replies
I have a SQL 2005 table (Table_A). One field (File_Name) may contain many instances of the same val…
2 replies
Hi All, I have to transpose column values into column name. I see there is a little bit trick in th…
7 replies
Hi, I have a table where the columns are set to Polish collation (in order to store Polish characte…
1 replies
Viewing 15 topics - 1,726 through 1,740 (of 12,234 total)
You must be logged in to create new topics.