Viewing 15 posts - 31 through 45 (of 45 total)
Hi gupta.sreekanth,
I'm not that expert in scripting, but for the starting u may use following i guess:
Select SUBSTRING(dbo.Table.Column, 0, CHARINDEX('-', dbo.Table.Column, 1,)) as Column1
March 1, 2011 at 12:09 am
Thank you very much bro, it's working pretty well, just little problem is my supervisor asked me not to use temp table, as there gonna be huge DB, in this...
November 11, 2010 at 1:00 am
Thanks Craig Farrell for that, it's running.
But when I run it on real data getting a massage: 'timeout expired'. Then I run it on 10 data only on...
November 10, 2010 at 11:57 pm
I guess it was slowly changing dimension, topic is closed
October 21, 2010 at 1:35 am
Thanks to Jan Van der Eecken, it's working exactly as I wanted :-):-)
ColdCoffee, that one i tried already, that flags the first day of last 2nd month also. If it...
June 4, 2010 at 3:29 am
That didn't help Wayne, just starts flagging second day of the month. In your note all of them are giving first day of month, week... What I need here, is...
June 3, 2010 at 10:56 pm
Finally passed from misunderstandings 😀
I've created a table to insert a result to a table
CREATE TABLE [dbo].[Result](
[Staff No] [nvarchar](50) NULL,
[Staff Name] [nvarchar](50) NULL,
[DateIn] [datetime] NULL,
[DateOut] [datetime] NULL,
[Duration] [float] NULL,
[DateNumber] [int]...
March 17, 2010 at 1:26 am
Hi Forum,
I'm so sorry that I posted the same massage again and again. I'm totally new, and I didn't realize that my posts are getting to the next page....
March 16, 2010 at 8:32 pm
Hi Jeff Moden.
I face some problems while building the cube. Need your help to finish the project. Can we sum total seconds by day, and do splitting by day if...
March 15, 2010 at 11:38 pm
Hi Jeff Moden.
I face some problems while building the cube. Need your help to finish the project. Can we sum total seconds by day, and do splitting by day if...
March 15, 2010 at 10:46 pm
Hi Jeff Moden.
I face some problems while building the cube. Need your help to finish the project. Can we sum total seconds by day, and do splitting by day if...
March 15, 2010 at 10:43 pm
Thank you very much :-):-)
That's exactly what I'm looking for. Think, the rest I can get in Analysis Services.
Thank you so much...
March 15, 2010 at 5:25 am
Here are rules for calculation:
1.If person come in and go out one time: Calculate time duration in the office.
2.If person come in and go out multiple time: Calculate summery of...
March 11, 2010 at 9:19 pm
Hi again, here is a code for my Data
--===== Create the test table with
CREATE TABLE [dbo].[Data 00](
[Transaction date] [nvarchar](50) NULL,
[Transaction Time] [nvarchar](50) NULL,
[Transactin Code] [nvarchar](50) NULL,
[Transaction Description] [nvarchar](50) NULL,
[Staff...
March 11, 2010 at 5:51 am
Viewing 15 posts - 31 through 45 (of 45 total)