Viewing 15 posts - 1 through 15 (of 28 total)
I had refreshed the view. Does this make a difference?
select * from vwOps where ID = 24
vs
select * from tableA where type = 'S'and...
November 1, 2021 at 5:40 pm
Hi All, Thanks a lot for all the help. I think this is very helpful and gives me something to start.
May 15, 2018 at 7:23 am
Yes, there is ID column which is a primary key and Account column which is name of the company. Here is the image file with table structure.
May 14, 2018 at 1:11 pm
The participant column is a CRM column and I want to separate it for reporting. The format is not always same. The delimeter is consistent ";"
Thanks !
May 14, 2018 at 9:57 am
I agree that SQL can return the data in any order it feels like and there has be a ORDER BY, but how come it returns the data in descending...
September 23, 2014 at 7:26 am
If this is not appropriate then could you help me a updated SQL ?
February 20, 2014 at 10:51 am
Nevermind...I was able to figure out using the link posted by Luis. Came with this SQL and it works.
WITH Ranked (AID, rnk,...
February 20, 2014 at 9:01 am
It is only for display purpose in reporting because the user doesn't want to see 4 rows for each record if there are 4 email ids for that AID.
February 20, 2014 at 8:41 am
I know pulling the data directly from AD would have been easier but we are getting this data (flat file) from some other source (1 time activity) and don't have...
December 18, 2013 at 12:13 pm
Let's say somebody adds a new record in the Details table (#tblSDetails) with new Sub-Folder
insert into #tblSDetails values ('Invoice_Archive','CSS','Location','Action','Read')
OR
Updates the Access column from Read to Modify where FolderName = 'Invoice'...
November 16, 2012 at 2:01 pm
Mismatch meaning sometimes it is possible that in the Details table (#tblSDetails) the Subfolder might not exists or it maybe also possible that the data under Access column for a...
November 16, 2012 at 12:12 pm
Thanks, I got it using the DelimitedSplit8K function.
October 30, 2012 at 12:16 pm
Viewing 15 posts - 1 through 15 (of 28 total)