Viewing 15 posts - 2,071 through 2,085 (of 2,894 total)
dwain.c (3/1/2012)
You may try it yourself if you don't...
March 1, 2012 at 3:19 am
dwain.c (2/29/2012)
Sorry to be unclear. I referred to the query posted by Eugene.
Try before commenting. My query returns exactly what OP has asked.
The rest of solutions are based on...
March 1, 2012 at 2:36 am
script it!
Id you don't know how, create the one empty database in SSMS, then script it out.
Copy-&-Paste with replacing the db name part.
February 29, 2012 at 5:43 am
Alexander G. (2/29/2012)
...The insert happens by daily execution of a sql script (plain delete, insert and update statements, no transactions) starting sqlcmd from an agent job.
...
Does your job have...
February 29, 2012 at 2:50 am
dwain.c (2/28/2012)
UPDATE b SET [AvlBalance] = [AvlBalance] - [LoadAmt]
OUTPUT Inserted.[CardProduct], x.[LoadAmt], x.[LoadDate], x.[LoadType]
INTO [dbo].[Loads]
FROM [dbo].[Balance] b
INNER JOIN...
February 29, 2012 at 2:40 am
You are welcome!
I would like to add some more for your consideration. Usually the solutions like yours would also include some kind of regular (most likely scheduled) reconciliation process, which...
February 28, 2012 at 12:13 pm
Based on your setup you can do the following:
select T.Name,T1.Title, T2.Title AS [Version], T.USERNAME
from test1 as t
join Test as t1
on t1.Name = t.name
and t1.id =1
join Test ...
February 28, 2012 at 10:06 am
You are welcome!
Please post your final one, so you get free code review :hehe:
February 28, 2012 at 9:24 am
As the query from your original post only needs a Name, there is no point to use UDF you have. Looks like you can join directly to BIDATAWSQL.DynamicsV5Realtime.dbo.empltable
Also, as...
February 28, 2012 at 9:21 am
ram_kamboz2k7 (2/28/2012)
How do you mean? Currently ev erytime an account is inserted into the call_list table, it automatically generates and that row is inserted into out_calllist table.
Is there an issue...
February 28, 2012 at 9:13 am
ram_kamboz2k7 (2/28/2012)
if bigint is an issue, can nvarchar be used for the telephone number?Thanks
Yes, usually people would use character data type when storing telephone numbers. Howevere, as J. Drew...
February 28, 2012 at 9:10 am
Do you see the difference in returned resultset in SQLServer MS or in a client/server application?
Your application may cach the query results, SQLServer doesn't do it. It can cach the...
February 28, 2012 at 8:58 am
Try the following:
Selectpe.EMPLID, pe.Name
Into #allempl
From DynamicsV5Realtime.dbo.PROJTABLE proj
Join udf_R000_EmployeeList() pe On proj.RESPONSIBLEFINANCIAL = pe.EMPLID
Where proj.DATAAREAID...
February 28, 2012 at 8:50 am
From DynamicsV5Realtime.dbo.PROJTABLE proj
Join DynamicsV5Realtime.dbo.SalesTable shed On proj.RESPONSIBLEFINANCIAL = shed.MARProjectEngineer
Join udf_R000_EmployeeList() pe On proj.RESPONSIBLEFINANCIAL = pe.EMPLID
is very different...
February 28, 2012 at 8:29 am
In your first sample, you want to round 99.7971 to 99.80 which does look like a ROUND,
but in the second smaple, you have 99.9959 rounded to 99.99 which looks like...
February 28, 2012 at 4:58 am
Viewing 15 posts - 2,071 through 2,085 (of 2,894 total)