Viewing 15 posts - 121 through 135 (of 287 total)
prasan.dash83 (9/25/2012)
I have an MIS system where I have to run 15 queries and update 15 sheets which takes a lot of time as I need to make changes...
September 25, 2012 at 3:26 am
rocky_498 (9/19/2012)
Here is my query,
SELECT SID FROM chartdDB
WHERE ADate = @ADate
AND SID NOT IN (SELECT SID FROM UPLOADRequest )
when i run this query sometime...
September 20, 2012 at 10:12 am
adminorama (9/12/2012)
I created a function that returns "0" if the file is...
September 13, 2012 at 9:15 am
Stewart "Arturius" Campbell (9/10/2012)
Alternatively, in theOUTPUT Inserted.* into delkkline, remove the " into delkk" statement, i.e. the OUTPUT statement should reflect( Orderdatum, txtKortingBdr,Klantnummer, Tal)
OUTPUT Inserted.*
That's what I...
September 10, 2012 at 5:22 am
pastori (8/30/2012)
Hello, and thanks for your reply!This SQL is in production use, so I can't use that developer version?
Probably not the best of ideas to deploy an Evaluation Version of...
August 30, 2012 at 8:27 am
I guess if you absolutely must store a formatted phone number you could use a computed column.
August 30, 2012 at 7:19 am
AppSup_dba (8/30/2012)
Thanks for the info OTF... i will try this with OSQL...
No worries.
As I understand it, OSQL works fine in that regard in Sql Server 2008.
August 30, 2012 at 5:59 am
Okay, I've just run a quick check and all the statements are actioned, however, only the first "rows affected" message seems to be returned.
This behaviour had been reported as a...
August 30, 2012 at 5:24 am
AppSup_dba (8/24/2012)
Actual output:
Starting the Transaction.
Beginning to run the queries.
(0 rows affected)
Queries executed successfully.
Transaction committed successfully.
Expected output:
Starting the Transaction.
Beginning...
August 24, 2012 at 9:46 am
AppSup_dba (8/24/2012)
I am trying to use SQLCMD to run a SQL Script. The script is of type.
Begin tran
Delete .....
Insert .....
Commit tran
The output captured doesnt show the proper output. Only...
August 24, 2012 at 8:45 am
Krissh_pallu (8/23/2012)
This Job has nearly 10 steps...
In each step I am parsing the date to my stored prcoedure.
Based on this date it will generate a report..
...
I got your...
August 24, 2012 at 8:07 am
Krissh_pallu (8/23/2012)
If anybody knows about token in sqlserver ...Please provide me one smalll example for STRTDT token IN A JOBThanks in Advance..
USE [SandBox]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[JobStartDate](
[dte] [date]...
August 23, 2012 at 7:37 am
YarHad (8/22/2012)
I have two tables as follows
salary table with columns (salary_id, student_id, salary, from_date)
student table with columns (student_id, firstname)
I am trying to retun (s.student_id, firstname,...
August 22, 2012 at 9:50 am
MSzI (8/21/2012)
Hi,Sure you can. Just try it!
But first of all, you need to make a "FULL" backup, otherwise just a differential backup without a full base is useless.
If I remember...
August 21, 2012 at 5:28 am
Lynn Pettis (8/11/2012)
CELKO (8/11/2012)
CELKO talked aobut DDL of my post, but here I only ask the question about the extra comma
A reflex on my part. I assume that...
August 13, 2012 at 10:20 am
Viewing 15 posts - 121 through 135 (of 287 total)