Topics
Started by
Posts
Last post
I have a variable that gets set by a user on a web form, and the user can set that value to somethi…
6 replies
I need to figure out how to do a group by on this query by number of days between start and end dat…
4 replies
I have a view that is built on OPENQUERY function calls to linked server (Oracle db). When I run q…
1 replies
Hi Everyone, I have an app that creates groups and designates members based on their age. Now I wou…
2 replies
Hi, I need help with querying an xml file with openxml. My xml file looks like that (it is longer, …
2 replies
Hello, In my limited experience I have used a cte to write simple hierarchical result sets but this…
14 replies
hi friends i want to add a column to a table with conditions below : 1- it has a default value=0 2-…
5 replies
I am trying to write a where clause that tests for a string which may or may not contain a specific…
2 replies
Hi All', I want to validate where each parent intermediary is also a parent to itself. So t…
1 replies
Hi, I am trying to implement OFAC Compliance check using sql queries to search for data in our data…
10 replies
Hi,Can some one throw some light on how to approach this.... CREATE TABLE A (ID1 VARCHAR(10),ID2 VA…
10 replies
greetings all, I'm trying to return a row of data for each licence and want that row to include the…
3 replies
Hi Friends, I'm new to SQL. And I wand to know Which is faster, Sub Query or Join? and Why ? Thanks…
4 replies
Create table #temp ( ID int identity(1,1), ActivityName varchar(max), ActivityDate datetime ) In…
6 replies
Can someone help me with querying the snapshot data as show in the attached file?
1 replies
Viewing 15 topics - 3,616 through 3,630 (of 10,647 total)
You must be logged in to create new topics.